-----
(mysql): SELECT type_name FROM prod_subtypes WHERE prod_subtype_id=14
-----
-----
(mysql): SELECT * FROM products WHERE prod_subtype_id=14 ORDER BY sku_c4l ASC LIMIT 1
-----
Axles | Caster Hardware | Casters4Less.Com
-----
(mysql): SELECT DISTINCT prod_subtype_id, type_name FROM prod_subtypes WHERE master_cat=2 AND prod_type_id !=7 ORDER BY prod_type_id ASC, prod_subtype_id ASC
-----
-----
(mysql): SELECT * FROM products WHERE prod_subtype_id=14 ORDER BY sku_c4l ASC
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='181' ORDER BY date_added DESC LIMIT 1
-----
