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