User:Kad

Jump to: navigation, search

SQL = SELECT DISTINCT bugs.bug_id as id, alias, components.name as component, quickflag.flagdate as flagdate, priority, products.name as product, bug_severity as severity, bug_status as status, short_desc as summary, profiles.realname as assignedto, version FROM `meego_bugzilla`.bugs LEFT JOIN `meego_bugzilla`.components on bugs.component_id=components.id LEFT JOIN (SELECT bug_id as quickflagbugid, MAX(creation_date) as flagdate from `meego_bugzilla`.flags where status='?' group by quickflagbugid) as quickflag on quickflag.quickflagbugid=bugs.bug_id LEFT JOIN `meego_bugzilla`.products on bugs.product_id=products.id LEFT JOIN `meego_bugzilla`.profiles on bugs.assigned_to=profiles.userid where 1=1 and products.name='MeeGo Core OS Features' and bug_status<>'CLOSED' and version='1.1' order by components.name ASC,priority,bug_status ASC;