You have no items in your shopping cart.
+1 212-352-9535
Welcome to Solar Time!
Login
/
Register
My Account
My Account
Specials
Checkout
Login
Email Us
Language:
Select...
English
Currency:
Select...
($) U.S. Dollar
(€) Euro
You have no items in your shopping cart.
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'soltime_newsite.m.manufacturers_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT m.manufacturers_name, m.manufacturers_id FROM sub_categories sc LEFT JOIN products_to_sub_categories p2sc on (p2sc.sub_categories_id = sc.sub_categories_id) LEFT JOIN products p on (p.products_id = p2sc.products_id) LEFT JOIN manufacturers m on (m.manufacturers_id = p.manufacturers_id) WHERE sc.sub_categories_id = '16' AND m.manufacturers_name != '' and p.products_status = '1' and p.include_in_solar = '1' GROUP BY m.manufacturers_name ORDER BY m.manufacturers_name
[TEP STOP]
