Home About US Terms Products Contact
Cart ContentsCheckoutMy Account

Tags

Border Tags
Border Tags
Checking Tags
Checking Tags
Classic Tags
Classic Tags
Colored Shipping Tags
Colored Shipping Tags
Gangs of 4 Tags
Gangs of 4 Tags
Garment Tags
Garment Tags
Globrite Tags
Globrite Tags
Hold Tags
Hold Tags
Inspection Tags
Inspection Tags
Inventory Tags (6 1/4 X 3 1/8)
Inventory Tags (6 1/4 X 3 1/8)
Jewelry Tags
Jewelry Tags
Key Tags
Key Tags
Kraft Tags
Kraft Tags
Luggage Tags
Luggage Tags
Manifold Tags
Manifold Tags
Manila Tags
Manila Tags
Merchandise Tags
Merchandise Tags
Metal Rim Tags
Metal Rim Tags
Packaged Tags
Packaged Tags
Re-order Tags
Re-order Tags
Repair Tags
Repair Tags
Sale Price Tags
Sale Price Tags
Silver Foil Tags
Silver Foil Tags
Sold Tags
Sold Tags
Strung Tags
Strung Tags
Tyvek Tags
Tyvek Tags

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'american_bastagest13.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '46' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]