SELECT

rs_catalog_product.* ,

rs_catalog_product_text.*,

sum(temp.quality) AS quality_summ

FROM rs_catalog_product

 

LEFT JOIN rs_catalog_product AS temp ON temp.parent = rs_catalog_product.id

 

LEFT JOIN rs_catalog_product_text ON rs_catalog_product_text.product_id = rs_catalog_product.id

 

WHERE

 

rs_catalog_product.id=5490 AND

rs_catalog_product.visible=1 AND

rs_catalog_product.parent=0 AND

 

quality_summ>0

 

GROUP BY rs_catalog_product.id

LIMIT 1