pgFouine: PostgreSQL log analysis report

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'report%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'report%') GROUP BY ai.assetid];

SELECT DISTINCT ai.assetid, 1 AS weight FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000M%') AND a.STATUS >= '16' AND a.type_code IN ('page_standard') INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('43','46560','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid)];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'book%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'house%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'week%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'control%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'bush%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE ((t.treeid LIKE '000=0000000B0001%') OR (t.treeid LIKE '000=0000000B0008%') OR (t.treeid LIKE '000=0000000B0009%') OR (t.treeid LIKE '000=0000000B000B%') OR (t.treeid LIKE '000=0000000B0002%') OR (t.treeid LIKE '000=0000000B0003%') OR (t.treeid LIKE '000=0000000B0004%') OR (t.treeid LIKE '000=0000000B0005%') OR (t.treeid LIKE '000=0000000B0006%') OR (t.treeid LIKE '000=0000000B0007%') OR (t.treeid LIKE '000=0000000B000=%') OR (t.treeid LIKE '000=0000000B%')) AND a.STATUS IN ('2', '16') AND a.type_code IN ('pdf_file', 'page_standard') INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'report%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'house%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'mayor%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'walk%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'requirement%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'room%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'requirement%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'tree%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'town%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'tree%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'standard%') GROUP BY ai.assetid];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'tree%') GROUP BY ai.assetid];

(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('', '') OR type_code IN ('', '', '', '', '') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE '') GROUP BY ai.assetid];

COMMIT;

SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 ORDER BY l.sort_order, l.type_code];

SELECT DISTINCT ai.assetid, 0 AS weight FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ('') INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid)];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE ((t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '')) AND a.STATUS IN ('', '') AND a.type_code IN ('', '') INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE '') GROUP BY ai.assetid];

SELECT DISTINCT ai.assetid, 0 AS weight FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE ((t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '') OR (t.treeid LIKE '')) AND a.STATUS IN ('', '') AND a.type_code IN ('', '') INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid)];

SELECT l.assetid, l.url, CASE WHEN l.http = '' THEN '' ELSE '' END AS protocol, ( (CASE WHEN l.http = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) ) AS weighting FROM sq_ast_lookup l WHERE l.assetid IN ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') ORDER BY weighting DESC, LENGTH(l.url) ASC];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ('') INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.type = '') AND (ai.component = '') AND (ai.value = '') GROUP BY ai.assetid];

UPDATE sq_ast_lnk SET sort_order = sort_order - 0 WHERE majorid = $1 AND sort_order > $2];

SELECT atr.name, atr.attrid, atr.type, COALESCE(v.custom_val, atr.default_val) AS value FROM sq_ast_attr atr LEFT OUTER JOIN sq_ast_attr_val v ON (atr.attrid = v.attrid AND v.assetid = $1) WHERE atr.type_code = $2];

SELECT sq_cache.expires, sq_cache.path FROM sq_cache WHERE ( sq_cache.cache_key = ($1) AND sq_cache.perm_key = ($2) AND sq_cache.url = ($3) ) ];

UPDATE sq_cache SET expires = TO_TIMESTAMP($1, 'YYYY-MM-DD HH24:MI:SS') WHERE ( sq_cache.assetid IN ($2,$3) ) ];

SELECT sq_cache.assetid, sq_cache.path FROM sq_cache WHERE ( ( sq_cache.url = ($1) OR sq_cache.url = ($2) OR sq_cache.url LIKE $3 OR sq_cache.url LIKE $4 ) ) ];

SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 AND l.is_exclusive = $3 AND l.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code = $4 ) ORDER BY l.sort_order, l.type_code];

SELECT l.assetid, l.short_name, l.name, l.type_code, l.STATUS, l.linkid, l.link_type, l.sort_order, ap.path, u.url, (CASE u.http WHEN '1' THEN $1 WHEN '0' THEN $2 END) AS protocol, p.permission AS accessible FROM sq_vw_ast_lnk_minor l LEFT JOIN (SELECT p.assetid, p.permission FROM sq_vw_ast_lnk_minor l2 INNER JOIN sq_ast_perm p ON l2.assetid = p.assetid WHERE l2.majorid = $3 AND (( (p.permission = $4 AND ( p.userid <> $5 OR (p.userid = $6 AND p.granted = '1') ) ) OR ( p.permission > $7 AND p.granted = '1' ) ) AND (p.userid IN ('13568','7','30394'))) GROUP BY p.assetid, p.permission HAVING MIN(p.granted) <> '0') p ON (l.assetid = p.assetid) LEFT JOIN sq_ast_url u ON l.assetid = u.assetid LEFT JOIN sq_ast_path ap ON l.assetid = ap.assetid WHERE l.majorid = $8 AND l.link_type <= $9 ORDER BY sort_order];

(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];

SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('', '') OR type_code IN ('', '', '', '', '') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE '') GROUP BY ai.assetid];