207:
Full query:
SELECT product.model,product.prodnumber,product.description,product.meta_title,product.meta_description, product.price_max,product.price_min,product.offers_total, product.price_from,product.units,product.status, product.fk_supplier,product.image_url, product.fk_category,category.alias as category_alias, product.meta_alt,product.meta_keywords,product.alias,product.id,product.published,used, company.name as manufacturer_name, company.country as manufacturer_country, company.alias as manufacturer_alias, product.name FROM product LEFT JOIN company ON (company.id = product.fk_manufacturer AND company.published=1) LEFT JOIN category ON (category.id = product.fk_category) WHERE product.id='contacts' AND product.deleted=0 AND product.published!=0