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 (Texture LIKE '%Cement texture%' OR Texture LIKE '%Ceramic texture%')
ORDER BY p.productDefinition ASC
limit 1450, 50
