SELECT 
  pd.product_id 
FROM 
  cscart_product_descriptions AS pd 
WHERE 
  pd.lang_code = 'en' 
  AND (
    pd.product LIKE '%roof%' 
    OR pd.full_description LIKE '%roof%' 
    OR pd.meta_keywords LIKE '%roof%'
  ) 
LIMIT 
  5