Categories
Products
  Architectural Casting
  Film and Set Design
    Accessories
    Aggregates
    Cement
    Clay
    Fibreglass
    Pigments & Tints
    Plaster Reinforcement
    Plasters
    Polyurethanes
    Prosthetic/Orthotic Bandages
    Safety/PPE
    Silicones
    Tapes
    Tools
      Brushes
      Containers
      Cutting Tools
      Fastener
      Mixers
      Sandpaper
      Shaping Tools
      Smoothing Tools
      Smoothing Tools
      Weight & Measure
    Ultraboard
  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?
Chemionics Latex 60CX21440 (1 gal)
Chemionics Latex 60CX21440 (1 gal)
$40.00
Information
Shipping & Payment Conditions
Contact Us
Brushes
Brushes
Containers
Containers
Cutting Tools
Cutting Tools
Fastener
Fastener
Mixers
Mixers
Sandpaper
Sandpaper
Shaping Tools
Shaping Tools
Smoothing Tools
Smoothing Tools
Smoothing Tools
Smoothing Tools
Weight & Measure
Weight & Measure
New Products For September
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 = '90' 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]