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

http://www.thedukesofhazzard.com/love-duke-tshirt-014-p-65.html I love Bo Duke T-shirt #014 <P>100% cotton cap sleeve shirt. The shirt is black with red ringers, and the heart has embedded sparkles.</P> <P><B>Note:</B> If a size is not listed we do not have it.</P> <P>Dimensions: <BR /> Large: Length = 23 inches, width = 17 inches <BR /> Medium: Length = 21 inches, width = 16 inches <BR /> Small: Length = 21 inches, width = 15 inches <BR /> </P>