Categories
Products
  Architectural Casting
    Accessories
    Aggregates
    Cement
    Clay
    Fibreglass
    Pigments & Tints
    Plaster Reinforcement
    Plasters
      Allied Custom Gypsum
      Georgia Pacific Alpha Gypsums
      Georgia Pacific Beta Gypsums
      Georgia Pacific Casting
      National Gypsum
      Plaster Additives
      Wall Plasters
    Polyurethanes
    Safety/PPE
    Silicones
    Tapes
    Tools
  Film and Set Design
  Building Products
  Restoration & Eco-Building
  Cement
  Lime
  Aggregates
  Fibreglass
  Plasters
  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 (5kg pail)
Zhermack AL-PR Fast Setting Alginate (5kg pail)
$110.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
Plaster Additives
Plaster Additives
Wall Plasters
Wall Plasters
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 = '61' 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]