SELECT `jn_editions`.`id` as `edition_id`, `jn_editions`.`city_name`, `jn_editions`.`city_name_urdu`, `jn_editions`.`mainpage_image_name`, `jn_paper_pages`.`paper_date`
FROM `jn_paper_pages`
JOIN `jn_paper_pages_edition_detail` ON `jn_paper_pages_edition_detail`.`paper_pages_id` = `jn_paper_pages`.`id`
JOIN `jn_editions` ON `jn_editions`.`id` = `jn_paper_pages_edition_detail`.`edition_id`
WHERE `jn_paper_pages`.`paper_date` = '2024-12-13'
AND `jn_paper_pages`.`publish_status` = 1
AND `paper_total_pages` >0
ORDER BY `jn_editions`.`id` ASC