select * from [viewArchiveCatalogue] where category_name = 'Tripods' and mastercat_name='Camerastore' and subcat_name = 'Consumer Tripods'

Consumer Tripods


	Manfrotto 190CL Tripod with 128RC Fluid Video Head The Manfrotto 190CL Tripod with 128RC Fluid Video Head. Ideal for the semi-professional or professional photographer.

	Manfrotto 190D Tripod with 141RC Head The Manfrotto 190D Tripod with 141RD Head. Ideal for the semi-professional or professional photographer.

	Manfrotto 190CLB Tripod Legs Manfrotto 190CLB Tripod Legs

	Manfrotto 190D Tripod with 128RC Fluid Video Head Manfrotto 190D Tripod with 128RC Fluid Video Head

	Manfrotto 190D Tripod with 700 RC2 Head Manfrotto 190D Tripod with 700 RC2 Head

	Manfrotto 190D Tripod with 804RC2 3 Way Photo Head Manfrotto 190D Tripod with 804RC2 3 Way Photo Head

	Olympus 0-88 Tripod Olympus 0-88 3 section tripod.

	Velbon Ultra Luxi SF Tripod Velbon Ultra Luxi SF Tripod

	Velbon Ultra Luxi F Tripod Velbon Ultra Luxi F Tripod

	Velbon CX-200 Tripod Short version of CX-300. Just 44cm when folded. Compact enough to be put in a camera bag. Weighs just 1.0kg. Features Maximum capacity for loaded weight : 1.8kg