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 = '36' AND products_status=1 AND pd.products_id=p.products_id ORDER BY p.products_date_added

http://www.thedukesofhazzard.com/youth-dukes-hazzard-general-lee-long-sleeve-tee-007y-p-115.html Youth Dukes of Hazzard General Lee 01 Long Sleeve Tee #007y <p><span style=&#34font-weight: bold;&#34>SPECIAL: </span>Buy this shirt and get a FREE General Lee 01 Sticker!!</p><p>&quot;01&quot; on the front</p><p>Bright orange<br /></p><p>100% Heavyweight cotton<br /></p><p>Youth sizes only.<br /></p> http://www.thedukesofhazzard.com/youth-dukes-hazzard-general-lee-shirt-006y-p-129.html Youth Dukes of Hazzard General Lee 01 shirt #006y <p><span style=&#34font-weight: bold;&#34>SPECIAL: </span>Buy this shirt and get a FREE General Lee 01 Sticker!!</p><p>&quot;01&quot; on the front</p><p>Bright orange<br /></p><p>100% Heavyweight cotton</p>