3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php echo "SELECT dd.folder_id, dd.os, CONCAT_WS('_', dd.os, dd.folder_id) AS uid FROM debug_download AS dd LEFT JOIN 9cms_download_folder AS folder ON dd.folder_id = folder.folder_id LEFT JOIN appstore_category AS apps ON dd.folder_id = apps.category_id WHERE (folder.name > '' OR apps.name > '') AND dd.dataset >= " . date('ym', strtotime('-2 months')) . " AND dd.family = 'softwares' AND dd.geo = 'MY' GROUP BY uid ORDER BY dd.frequency DESC;";
based on IjjQj
Output for 4.3.0 - 7.2.0
SELECT dd.folder_id, dd.os, CONCAT_WS('_', dd.os, dd.folder_id) AS uid FROM debug_download AS dd LEFT JOIN 9cms_download_folder AS folder ON dd.folder_id = folder.folder_id LEFT JOIN appstore_category AS apps ON dd.folder_id = apps.category_id WHERE (folder.name > '' OR apps.name > '') AND dd.dataset >= 1501 AND dd.family = 'softwares' AND dd.geo = 'MY' GROUP BY uid ORDER BY dd.frequency DESC;