SELECT 
  p.page_id, 
  d.page 
FROM 
  cscart_pages AS p 
  LEFT JOIN cscart_page_descriptions AS d ON p.page_id = d.page_id 
  AND d.lang_code = 'ja' 
WHERE 
  p.parent_id = 98 
  AND p.page_type = 'B' 
  AND p.status = 'A' 
  AND p.page_id < 242 
ORDER BY 
  p.page_id DESC 
LIMIT 
  1