Home About US Terms Products Contact
Cart ContentsCheckoutMy Account

Embellishments

Arrows
Arrows
Book Rings
Book Rings
Brads
Brads
Buttons
Buttons
Clip O's
Clip O's
Corners
Corners
Eyelets
Eyelets
Grommets
Grommets
Hemp Cord
Hemp Cord
Metal Edge
Metal Edge
Mini Brads
Mini Brads
Nail heads
Nail heads
Paper Raffia
Paper Raffia
Pinwheels
Pinwheels
Rhinestones
Rhinestones
Rivets
Rivets
Safety Pins
Safety Pins
Snaps
Snaps
Swarovski
Swarovski
Tokens
Tokens
Washers
Washers

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 = '28' 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]