Justin's Dukes of Hazard Store http://www.thedukesofhazzard.com Justin's Dukes of Hazzard Store en

SELECT p.products_id, products_model, products_image, products_price, products_date_added, products_tax_class_id FROM products_description pd, products p, products_to_categories pc WHERE p.products_id = pc.products_id AND pc.categories_id = '29' AND products_status=1 AND pd.products_id=p.products_id ORDER BY p.products_date_added

http://www.thedukesofhazzard.com/general-lee-orange-hat-047b-p-92.html General Lee 01 Orange Hat 047b <p>Your head will thank you for sportin&#39 this hat!</p>