Home   -   About   -   Wholesale   -   Contact Us   -   FAQ
  Top » Catalog » Printable Catalog My Account  |  Cart Contents  |  Checkout   
Everything Glows!
37/148 Chesterville Road
Moorabbin, Vic, 3189
Australia
PH: 03 9553 0972
FAX: 03 9553 0973
Email: sales@everythingglows.com.au
Note: All prices are subject to change without notice. All products will be billed in our Currency only.
          The Currency feature is just for your convenience. This catalogue is current on the day of printing.
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and cd.language_id = '1' order by cd.categories_name, pd.products_name

[TEP STOP]

Sort Asending
Sort Desending		 Name
Sort Asending
Sort Desending		 Description
Sort Asending
Sort Desending		 Price Inc.GST