SELECT
o.ID,
o.name,
o.model,
o.picture,
o.param,
params.all_params_props
FROM
wp_offers o
LEFT JOIN (
SELECT
offer_id,
COUNT(id_param) AS param_count,
GROUP_CONCAT(CONCAT(id_param, ':', id_prop) ORDER BY id_param ASC SEPARATOR ',') AS all_params_props
FROM
wp_goods_pp
WHERE
good_id = '595612'
GROUP BY
offer_id
) AS params ON o.ID = params.offer_id
WHERE
o.good_id = '595612'
ORDER BY
params.param_count DESC
LIMIT 24;
Купить Смеситель для ванны AM.PM F9U1000, хром в Шуе от 7990 руб
Контакты
