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 ProductBodyType like '%wall%'
AND (Size LIKE '%40X80%')
ORDER BY p.productDefinition ASC
limit 0, 50
