<?php
 
      $stmt = $con->prepare("SELECT n.id_news_sport,
                                   n.url,
                                   n.cover_page,
                                   n.mini_title,
                                   n.mini_description,
                                   n.date_post
                            FROM
                                (SELECT main_cover FROM news_sport n GROUP BY main_cover) categories 
                                Cross Apply (
                                    SELECT
                                        n1.id_news_sport as id,
                                        n1.url as url,
                                        n1.cover_page as cover_page,
                                        n1.mini_title as mini_title,
                                        n1.mini_description as mini_description,
                                        n1.date_post as date_post
                                   FROM news_sport n1
                                   WHERE
                                        n1.main_cover = categories.main_cover
                                    LIMIT 10
                                ) n
                            ORDER BY n.id_news_sport DESC LIMIT 10");

PD9waHAKCiAgICAgICRzdG10ID0gJGNvbi0+cHJlcGFyZSgiU0VMRUNUIG4uaWRfbmV3c19zcG9ydCwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBuLnVybCwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBuLmNvdmVyX3BhZ2UsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbi5taW5pX3RpdGxlLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG4ubWluaV9kZXNjcmlwdGlvbiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBuLmRhdGVfcG9zdAogICAgICAgICAgICAgICAgICAgICAgICAgICAgRlJPTQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIChTRUxFQ1QgbWFpbl9jb3ZlciBGUk9NIG5ld3Nfc3BvcnQgbiBHUk9VUCBCWSBtYWluX2NvdmVyKSBjYXRlZ29yaWVzIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIENyb3NzIEFwcGx5ICgKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgU0VMRUNUCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBuMS5pZF9uZXdzX3Nwb3J0IGFzIGlkLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbjEudXJsIGFzIHVybCwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG4xLmNvdmVyX3BhZ2UgYXMgY292ZXJfcGFnZSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG4xLm1pbmlfdGl0bGUgYXMgbWluaV90aXRsZSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG4xLm1pbmlfZGVzY3JpcHRpb24gYXMgbWluaV9kZXNjcmlwdGlvbiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG4xLmRhdGVfcG9zdCBhcyBkYXRlX3Bvc3QKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGUk9NIG5ld3Nfc3BvcnQgbjEKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBXSEVSRQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbjEubWFpbl9jb3ZlciA9IGNhdGVnb3JpZXMubWFpbl9jb3ZlcgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBMSU1JVCAxMAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICkgbgogICAgICAgICAgICAgICAgICAgICAgICAgICAgT1JERVIgQlkgbi5pZF9uZXdzX3Nwb3J0IERFU0MgTElNSVQgMTAiKTs=