Online PHP editor | output for 2AfUZ

@ 2015-03-18T11:10:00Z

<?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;";

Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.19, 8.3.0 - 8.3.7: 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;

preferences:dark modelive preview