1055. Query Error 1055: Expression #53 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ceramhouzz1.pi.ext' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT p.*,
p.count as product_count,
ps.id,
ps.available,
ps.count as `count`,
ps.price as price,
ps.compare_price as compare_price,
ps.purchase_price as purchase_price,
ps.compare_price as original_compare_price,
ps.primary_price,
ps.sku,
ps.name as sku_name,
ps.product_id,
pi.ext as image_ext,
pi.filename as sku_image_filename,
ps.image_id as sku_image_id
FROM shop_product_skus ps
LEFT JOIN shop_product p ON p.id = ps.product_id
LEFT JOIN shop_product_images pi ON (ps.image_id IS NOT NULL AND ps.image_id = pi.id) OR (ps.image_id IS NULL AND ps.product_id = pi.product_id)
WHERE ps.id IN ('247424') GROUP BY ps.id
Ceramhouzz