select
SQL_CALC_FOUND_ROWS
*
from wp_vitra_products p
left join wp_vitra_products_hex_code hex on p.colouren = hex.colouren
left join wp_posts wp on p.productID = wp.ID
where
lang = 'en' AND productID != 0
AND (main LIKE '%Greige%' OR main LIKE '%White%' OR main LIKE '%Mink%')
ORDER BY p.productDefinition ASC
limit 1700, 50
