gistfile1.txt

SELECT
pi.nid,
pi.pid pi_pid,
pic.pid pic_pid,
pi.rid pi_rid,
pic.rid pic_rid,
n.title,
n.created,
priority.name priority,
s.name status,
pic.timestamp,
pic.comment_number,
f.filepath

FROM project_issues pi
INNER JOIN node n ON n.nid = pi.nid
INNER JOIN project_issue_priority priority ON pi.priority = priority.priority
INNER JOIN project_issue_state s ON pi.sid = s.sid
LEFT JOIN project_issue_comments pic ON pi.nid = pic.nid
LEFT JOIN upload u ON u.nid = pi.nid
LEFT JOIN comment_upload cu ON cu.nid = pi.nid AND pic.cid = cu.cid
INNER JOIN files f ON u.fid = f.fid OR cu.fid = f.fid

WHERE
pi.pid = 3060
AND pi.rid = 572834
AND n.status = 1
AND pi.sid = 14 OR pi.sid = 8

LIMIT 10;

11950	5737	5737	94848	94846	The tabular View stops displaying contents after Adding an new field to the Content Type	1098487128	critical	needs review	1105503099	1	files/issues/flexinode_1.patch
11950	5737	5737	94848	94848	The tabular View stops displaying contents after Adding an new field to the Content Type	1098487128	critical	needs review	1148309542	4	files/issues/tablefix.diff
11950	5737	5737	94848	94848	The tabular View stops displaying contents after Adding an new field to the Content Type	1098487128	critical	needs review	1148384636	5	files/issues/tablefix46.diff
33406	29789	NULL	95697	NULL	Title input required	1128723356	critical	needs review	NULL	NULL	files/issues/task.module.title.patch
36047	29091	29091	95690	95690	Googlemap: "Operation aborted" error in IE6	1130905946	critical	needs review	1130906122	1	files/issues/geary-2005-11-02.googlemap.module.patch
36047	29091	29091	95690	95690	Googlemap: "Operation aborted" error in IE6	1130905946	critical	needs review	1130906122	1	files/issues/geary-2005-11-02.googlemap.module
36047	29091	29091	95690	95690	Googlemap: "Operation aborted" error in IE6	1130905946	critical	needs review	1132946290	2	files/issues/geary-2005-11-02.googlemap.module.patch
36855	7815	NULL	94893	NULL	Unrestricted upload	1131472922	critical	needs review	NULL	NULL	files/issues/upload-module-unlimited-role-restriction.patch
38834	36756	36756	95843	95843	hook_settings update for forms API	1132923839	critical	needs review	1132959010	1	files/issues/xtracker.module_formsapi.patch
38834	36756	36756	95843	95843	hook_settings update for forms API	1132923839	critical	needs review	1133807367	2	files/issues/xtracker.module_formsapi.patch