---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 97
WHERE cat_id LIKE "%#97#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 98
WHERE cat_id LIKE "%#98#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 99
WHERE cat_id LIKE "%#99#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 100
WHERE cat_id LIKE "%#100#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 101
WHERE cat_id LIKE "%#101#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 102
WHERE cat_id LIKE "%#102#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 103
WHERE cat_id LIKE "%#103#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
---SELECT id,hl1,hl2,hl3,rpt,short_hl2,cat_id,parent_cat_id,prefix_keyword,sum,dtl,hl_color,tmp_photo,video_dis,alt_tag,IFNULL(hierarchy, 99) AS hierarchy,entry_time FROM news AS news
LEFT JOIN mn_hierarchy AS mnh ON mnh.news_id = news.id AND mnh.mid = 104
WHERE cat_id LIKE "%#104#%"
AND publish = 1 GROUP BY id
ORDER BY hierarchy ASC, entry_time DESC
LIMIT 4
লাইভ টিভি
