SELECT 
  s.title, 
  d.descr 
FROM 
  cscart_unit_price_descr d 
  INNER JOIN cscart_unit_prices s ON s.unit_price_id = d.unit_price_id 
WHERE 
  s.unit_price_id = 0 
  AND d.lang_code = 'en' 
  AND s.status = 'A'