select * from [viewArchiveCatalogue] where category_name = 'Lenses' and mastercat_name='Camerastore' and subcat_name = 'Canon SLR Lenses'

Canon SLR Lenses

Canon SLR Lenses


	Canon EF 28-105 f4.0-5.6 USM Canon EF 28-105 f4.0-5.6 USM

	Canon EF 28-200mm f3.5-5.6 USM Canon EF 28-200mm f3.5-5.6 USM

	Canon EF 80-200mm f4.5-5.6 II Canon EF 80-200mm f4.5-5.6 II

	Canon EF 28-80mm f3.5-5.6 Canon EF 28-80mm f3.5-5.6

	Canon EF 28-90mm f4.0-5.6 USM Canon EF 28-90mm f4.0-5.6 USM.

	Canon EF 28-200mm f3.5-5.6 Canon EF 28-200mm f3.5-5.6

	Canon EF 28-90mm f4.0-5.6 Canon EF 28-90mm f4.0-5.6

	Canon EF 35-80mm f4.0-5.6 Canon EF 35-80mm f4.0-5.6

	Canon EF 90-300mm f4.5-5.6 USM Canon EF 90-300mm f4.5-5.6 USM

	Canon EF 90-300mm f/4.5-5.6 Canon EF 90-300mm f/4.5-5.6