select distinct p.products_id,p.products_image, pd.products_name,pd.products_short_description, p.products_afterbuy_model,p.products_weight, p.product_is_new,p.product_is_specials, p.product_is_always_free_shipping, p.products_stock_status, p.product_predict_have_stock_date from products p, products_to_categories p2c, products_description pd, categories c where c.categories_id in (1002606) and p2c.categories_id=c.categories_id and p.products_id=p2c.products_id and p.products_status=1 and (c.categories_status=1 OR c.categories_status=2) and p.products_id = pd.products_id and pd.language_id = 2 order by p.products_ordered, p.products_date_added DESC

Camiseta