casters4less.com

Caster Hardware

----- (mysql): SELECT DISTINCT a.prod_subtype_id, a.type_name FROM prod_subtypes AS a, products AS b WHERE b.prod_subtype_id=a.prod_subtype_id AND a.prod_type_id = 14 ----- ----- (mysql): SELECT * FROM prod_pics AS a, products AS b WHERE a.prod_id=b.prod_id AND b.prod_subtype_id=13 LIMIT 1 ----- ----- (mysql): SELECT * FROM prod_pics AS a, products AS b WHERE a.prod_id=b.prod_id AND b.prod_subtype_id=14 LIMIT 1 ----- ----- (mysql): SELECT * FROM prod_pics AS a, products AS b WHERE a.prod_id=b.prod_id AND b.prod_subtype_id=16 LIMIT 1 ----- ----- (mysql): SELECT * FROM prod_pics AS a, products AS b WHERE a.prod_id=b.prod_id AND b.prod_subtype_id=17 LIMIT 1 -----

	Bearings
	Axles
	Bushings
	Bearing Retainers