SELECT CONCAT(a.f44430, '_' ,a.f43200) row_id, a.f44430 id_service, (SELECT f31070 FROM cb_data1990 WHERE id=(SELECT f42900 FROM cb_data2230 WHERE id=a.f44430)) service_name, a.f43200 id_product, IF(a.f43200=0,'',(SELECT f6511 FROM cb_data501 WHERE id=a.f43200)) goods_name, IF(a.f43200=0, '46240', '41530') image_from, IF(ISNULL(IF(a.f43200=0,(SELECT f46240 FROM cb_data2230 WHERE id=a.f44430), (SELECT f41530 FROM cb_data501 WHERE id=a.f43200))),'',IF(a.f43200=0,(SELECT f46240 FROM cb_data2230 WHERE id=a.f44430), (SELECT f41530 FROM cb_data501 WHERE id=a.f43200))) image, (SELECT MIN(b.f36750) FROM cb_data2130 b WHERE b.status=0 AND b.f35030=19 AND (SELECT f43200 FROM cb_data1370 WHERE id=b.f41440)=a.f43200) min_price, (SELECT MAX(c.f36750) FROM cb_data2130 c WHERE c.status=0 AND c.f35030=19 AND (SELECT f43200 FROM cb_data1370 WHERE id=c.f41440)=a.f43200) max_price, (SELECT f36340 FROM cb_data2130 WHERE status=0 AND f35030=19 AND f41440=a.id) id_category, (SELECT f31070 FROM cb_data1990 WHERE status=0 AND id=(SELECT f36340 FROM cb_data2130 WHERE status=0 AND f35030=19 AND f41440=a.id)) AS category_name FROM cb_data1370 a WHERE status = 0 AND a.id IN (SELECT DISTINCT f41440 FROM cb_data2130 WHERE status=0 AND f35030=19) GROUP BY row_id