-

select pm.podcast_master_id, pm.podcast_master_name, pm.podcast_master_desc, pm.podcast_master_image, pm.podcast_master_image1,pm.podcast_master_image2,pm.podcast_master_image3, pm.podcast_master_url,pm.display_order,pm.podcast_date,pm.podcast_location,pm.podcast_master_page_title,pm.podcast_master_page_meta_desc, pm.podcast_master_keywords, (select count(*) from podcast_child where podcast_master_id=pm.podcast_master_id and active='Y') as total_podcast FROM podcast_master pm where pm.active = 'Y' and pm.podcast_master_id=21 order by pm.display_order asc LIMIT 0,10

Error