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

http://www.thedukesofhazzard.com/vintage-daisy-duke-shirt-002-p-30.html Vintage Daisy Duke Shirt #002 <p>This shirt is not available here. Please use this link to order this Daisy Duke shirt: <a rel=&#34nofollow&#34 href=&#34http://bit.ly/daisydukeshirt&#34 target=&#34_blank&#34> Dukes of Hazzard Daisy Duke T-shirt</a><img width=&#341&#34 height=&#341&#34 border=&#340&#34 ilo-full-src=&#34http://www.tqlkg.com/image-1232592-10676519&#34 src=&#34http://www.tqlkg.com/image-1232592-10676519&#34 /><br /></p><p><br /></p><p>Daisy Duke!! Sweet!</p> <p>Brown T-shirt. Vintage Style. 100% Heavyweight Cotton</p> http://www.thedukesofhazzard.com/dukes-hazzard-general-lee-shirt-006-p-91.html Dukes of Hazzard General Lee 01 shirt #006 <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><p><a href=&#34http://www.thedukesofhazzard.com/youth-dukes-hazzard-general-lee-shirt-006y-p-129.html&#34>Click here for youth sizes</a>.<br /></p> http://www.thedukesofhazzard.com/dukes-hazzard-general-lee-long-sleeve-tee-007a-p-133.html Dukes of Hazzard General Lee 01 Long Sleeve Tee #007a <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>Gildan brand</p><p>100% Heavyweight cotton<br /></p><p />