Blame | Last modification | View Log | Download | RSS feed
<?php
/* define(SQL_GET_PACKAGES,
'select client.name,device.name,software.package_name,software_version.version
from client join site on client.client_id = site.client_id
join device on device.site_id = site.site_id
join installed_packages on device.device_id = installed_packages.device_id
join software on installed_packages.software_id = software.software_id
join software_version on installed_packages.software_version_id = software_version.software_version_id
where <whereClause>
order by package_name,version
'
);
*/
?>