logo
  • ঢাকা বৃহস্পতিবার, ১৪ নভেম্বর ২০১৯, ৩০ কার্তিক ১৪২৬
  • সর্বশেষ
  • পাঠক প্রিয়
---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 = 9 WHERE cat_id LIKE "%#9#%" AND publish = 1 GROUP BY id ORDER BY hierarchy ASC, entry_time DESC LIMIT 2
---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 = 8 WHERE cat_id LIKE "%#8#%" AND publish = 1 GROUP BY id ORDER BY hierarchy ASC, entry_time DESC LIMIT 2
---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 = 4 WHERE cat_id LIKE "%#4#%" AND publish = 1 GROUP BY id ORDER BY hierarchy ASC, entry_time DESC LIMIT 2