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 '%Grey%' OR main LIKE '%Pink%' OR main LIKE '%Brown%')
ORDER BY p.productDefinition ASC
limit 1050, 50
