- date: documentation ( source)
- strtotime: documentation ( source)
<?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;";