SELECT 
  b.*, 
  d.*, 
  c.* 
FROM 
  cscart_bm_blocks as b 
  LEFT JOIN cscart_bm_blocks_descriptions as d ON b.block_id = d.block_id 
  LEFT JOIN cscart_bm_blocks_content as c ON b.block_id = c.block_id 
  AND d.lang_code = c.lang_code 
WHERE 
  b.block_id = 289 
  AND d.lang_code = 'en' 
  AND b.company_id = 1 
  AND (
    (
      c.object_id = 672 
      AND c.object_type like 'products'
    ) 
    OR (
      c.object_id = 0 
      AND c.object_type like ''
    )
  ) 
ORDER BY 
  snapping_id DESC 
LIMIT 
  1