 |
Recommended Products |
|
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bedidobe_bedidobeads.products_description.products_description' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select products.products_id, products_description.products_description, products.products_model, products.products_image, products.products_bimage, products.products_tax_class_id, IF(specials.status, specials.specials_new_products_price, products.products_price) as products_price from (products LEFT JOIN products_description on products.products_id = products_description.products_id) LEFT JOIN specials on products.products_id = specials.products_id where products_description.products_description like '%beads%' or products_description.products_description like '%beads%' and products_status = '1' group by products.products_id order by RAND(), products.products_date_added DESC limit 12
[TEP STOP]
|