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

Shows result from various feature-branches currently under review from the php developers. Contact me to have additional branches featured.

Output for Typed properties v2
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;
Output for Array change keys
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;
Output for Lexical anon
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;

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page