SELECT oc_product.product_id, oc_product.sku, oc_product.image, oc_product.price, oc_product_description.description, oc_product_description.name, oc_manufacturer.name, oc_product_to_category.category_id, oc_category_description.name, oc_product_filter.filter_id, oc_filter_description.name, oc_product_image.image
FROM `oc_product`
LEFT JOIN oc_product_description ON oc_product_description.product_id = oc_product.product_id
LEFT JOIN oc_manufacturer ON oc_manufacturer.manufacturer_id = oc_product.manufacturer_id
LEFT JOIN oc_product_to_category ON oc_product_to_category.product_id = oc_product.product_id
LEFT JOIN oc_category_description ON oc_category_description.category_id = oc_product_to_category.category_id
LEFT JOIN oc_product_filter ON oc_product_filter.product_id = oc_product.product_id
LEFT JOIN oc_filter_description ON oc_filter_description.filter_id = oc_product_filter.filter_id
LEFT JOIN oc_product_image ON oc_product_image.product_id = oc_product.product_id
WHERE oc_filter_description.language_id = 1 AND oc_product_description.language_id = 1 AND oc_category_description.language_id = 1
AND oc_product_filter.filter_id NOT IN (8)