SELECT p.*, title as title, description as description, content as content, metadesc as metadesc 
FROM product p
LEFT JOIN product_stock ps ON ps.id_product=p.id
WHERE (p.status=1 or id_damito>0 ) and `rewrite` =
'rychloviazac-pp-s-eurodierovanim-matny-sivy-ec412113' 
GROUP BY p.id