Film pour serre agricole= ?>
SELECT
pfr.name,
pfr.ref_name,
pfr.descc,
pfr.descd,
aa.category AS adv_cat,
(p.as_estimate + aa.as_estimate) AS product_as_estimate,
IFNULL(rc.price + rc.ecotax, p.price) AS price,
(IFNULL(rc.price, p.price) REGEXP '^[1-9]{1}[0-9]*((\.|,)[0-9]+){0,1}$') AS hasPrice
FROM products p
INNER JOIN products_fr pfr ON p.id = pfr.id
INNER JOIN advertisers aa ON pfr.idAdvertiser = aa.id
LEFT JOIN references_content rc ON p.id = rc.idProduct
AND rc.classement = 1
AND rc.vpc = 1
AND rc.deleted = 0
WHERE pfr.id = '4454963'