SQL error Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a5012.t2.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
with query SELECT
t1.`id`,
t1.`name`,
t1.`model`,
t1.`url`,
t2.`name` as category_name, t2.`url` as category_url,
t2_2.`name` as parent_category_name,
t5.`name` as catalog_name, t5.`multiplayer` as catalog_multiplayer,
(SELECT
IF(
MIN(`price`) = -1,
ROUND(MIN(`price`),2),
ROUND(MIN(`price`)*t5.`multiplayer`,2)
)
FROM `product_prices_ranges` WHERE `product_id` = t1.`id` AND `price` > 0) as minimal_price
FROM
`product` t1
LEFT JOIN `product_category` pc ON t1.`id` = pc.`product_id`
LEFT JOIN `category` t2 ON pc.`category_id` = t2.`id`
LEFT JOIN `category` t2_2 ON t2.`category_id` = t2_2.`id`
LEFT JOIN `catalog` t5 ON t1.`catalog_id` = t5.`id`
LEFT JOIN `product_prices_ranges` t6 ON t1.`id` = t6.`product_id`
WHERE
(t1.`is_active` = "1")
GROUP BY t1.`id`
ORDER BY t1.`is_promote` DESC, t1.`sort` DESC, t1.`name` ASC LIMIT 0,15