Categories
Products
  Architectural Casting
  Film and Set Design
  Building Products
  Restoration & Eco-Building
  Cement
  Lime
  Aggregates
  Fibreglass
  Plasters
    Allied Custom Gypsum
    Georgia Pacific Alpha Gypsums
    Georgia Pacific Beta Gypsums
    Georgia Pacific Casting
    National Gypsum
    Wall Plasters
    Plaster Additives
  Clay
  Safety/PPE
  Tools
  Prosthetic/Orthotic Bandages
  Polyurethanes
  Tapes
  Pigments & Tints
  Flue Liners/Tops
  Brick
  Silicones
  Ultraboard
  Plaster Reinforcement
  Accessories
Manufacturers
What's New?
Zhermack AL-PR Fast Setting Alginate (500g bag)
Zhermack AL-PR Fast Setting Alginate (500g bag)
$18.00
Information
Shipping & Payment Conditions
Contact Us
Allied Custom Gypsum
Allied Custom Gypsum
Georgia Pacific Alpha Gypsums
Georgia Pacific Alpha Gypsums
Georgia Pacific Beta Gypsums
Georgia Pacific Beta Gypsums
Georgia Pacific Casting
Georgia Pacific Casting
National Gypsum
National Gypsum
Wall Plasters
Wall Plasters
Plaster Additives
Plaster Additives
New Products For July
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'skycon_osc2.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 = '21' 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]