| 10143500 | xxx     | xx.xx.xx.xx:56571 | xxxxx | Query   |     29 | statistics                                                            |(SELECT DISTINCT(C.id),C.content_type_id,S.version_id,"greatescape" AS selector_group FROM content C INNER JOIN stories S ON C.staging_version_id = S.version_id INNER JOIN content_relationships R1 ON C.id=R1.content_id  AND S.version_id=R1.content_version_id  AND R1.related_content_id=779 AND R1.relationship_id = 3 INNER JOIN content_relationships CRLOC16 ON C.id=CRLOC16.content_id  AND S.version_id=CRLOC16.content_version_id AND CRLOC16.relationship_id = 4 INNER JOIN content_relationships CRLOC17 ON C.id=CRLOC17.content_id  AND S.version_id=CRLOC17.content_version_id AND CRLOC17.relationship_id = 4 INNER JOIN content_relationships CRLOC18 ON C.id=CRLOC18.content_id  AND S.version_id=CRLOC18.content_version_id AND CRLOC18.relationship_id = 4 INNER JOIN content_relationships CRLOC19 ON C.id=CRLOC19.content_id  AND S.version_id=CRLOC19.content_version_id AND CRLOC19.relationship_id = 4 INNER JOIN content_relationships CRLOC20 ON C.id=CRLOC20.content_id  AND S.version_id=CRLOC20.content_version_id AND CRLOC20.relationship_id = 4 INNER JOIN content_relationships CRLOC21 ON C.id=CRLOC21.content_id  AND S.version_id=CRLOC21.content_version_id AND CRLOC21.relationship_id = 4 INNER JOIN content_relationships CRLOC22 ON C.id=CRLOC22.content_id  AND S.version_id=CRLOC22.content_version_id AND CRLOC22.relationship_id = 4 INNER JOIN content_relationships CRLOC23 ON C.id=CRLOC23.content_id  AND S.version_id=CRLOC23.content_version_id AND CRLOC23.relationship_id = 4 INNER JOIN content_relationships CRLOC48 ON C.id=CRLOC48.content_id  AND S.version_id=CRLOC48.content_version_id AND CRLOC48.relationship_id = 4 INNER JOIN content_relationships CRLOC49 ON C.id=CRLOC49.content_id  AND S.version_id=CRLOC49.content_version_id AND CRLOC49.relationship_id = 4 INNER JOIN content_relationships CRLOC50 ON C.id=CRLOC50.content_id  AND S.version_id=CRLOC50.content_version_id AND CRLOC50.relationship_id = 4 INNER JOIN content_relationships CRLOC51 ON C.id=CRLOC51.content_id  AND S.version_id=CRLOC51.content_version_id AND CRLOC51.relationship_id = 4 INNER JOIN content_relationships CRLOC52 ON C.id=CRLOC52.content_id  AND S.version_id=CRLOC52.content_version_id AND CRLOC52.relationship_id = 4 INNER JOIN content_relationships CRLOC53 ON C.id=CRLOC53.content_id  AND S.version_id=CRLOC53.content_version_id AND CRLOC53.relationship_id = 4 INNER JOIN content_relationships CRLOC54 ON C.id=CRLOC54.content_id  AND S.version_id=CRLOC54.content_version_id AND CRLOC54.relationship_id = 4 INNER JOIN content_relationships CRLOC55 ON C.id=CRLOC55.content_id  AND S.version_id=CRLOC55.content_version_id AND CRLOC55.relationship_id = 4 WHERE (C.status  IN ("live","hidden") AND C.content_type_id IN (71,20) AND C.site_id IN (3, 0)) AND ((CRLOC16.related_content_id =3) OR (CRLOC17.related_content_id =286) OR (CRLOC17.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 286)) OR (CRLOC17.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 286)) OR (CRLOC17.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 286)) OR (CRLOC17.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 286)) OR (CRLOC18.related_content_id =287) OR (CRLOC18.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 287)) OR (CRLOC18.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 287)) OR (CRLOC18.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 287)) OR (CRLOC18.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 287)) OR (CRLOC19.related_content_id =290) OR (CRLOC19.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 290)) OR (CRLOC19.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 290)) OR (CRLOC19.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 290)) OR (CRLOC19.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 290)) OR (CRLOC20.related_content_id =291) OR (CRLOC20.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 291)) OR (CRLOC20.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 291)) OR (CRLOC20.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 291)) OR (CRLOC20.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 291)) OR (CRLOC21.related_content_id =294) OR (CRLOC21.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 294)) OR (CRLOC21.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 294)) OR (CRLOC21.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 294)) OR (CRLOC21.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 294)) OR (CRLOC22.related_content_id =300) OR (CRLOC22.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 300)) OR (CRLOC22.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 300)) OR (CRLOC22.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 300)) OR (CRLOC22.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 300)) OR (CRLOC23.related_content_id =303) OR (CRLOC23.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 303)) OR (CRLOC23.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 303)) OR (CRLOC23.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 303)) OR (CRLOC23.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 303))) AND ((CRLOC48.related_content_id =3) OR (CRLOC49.related_content_id =286) OR (CRLOC49.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 286)) OR (CRLOC49.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 286)) OR (CRLOC49.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 286)) OR (CRLOC49.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 286)) OR (CRLOC50.related_content_id =287) OR (CRLOC50.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 287)) OR (CRLOC50.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 287)) OR (CRLOC50.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 287)) OR (CRLOC50.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 287)) OR (CRLOC51.related_content_id =290) OR (CRLOC51.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 290)) OR (CRLOC51.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 290)) OR (CRLOC51.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 290)) OR (CRLOC51.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 290)) OR (CRLOC52.related_content_id =291) OR (CRLOC52.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 291)) OR (CRLOC52.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 291)) OR (CRLOC52.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 291)) OR (CRLOC52.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 291)) OR (CRLOC53.related_content_id =294) OR (CRLOC53.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 294)) OR (CRLOC53.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 294)) OR (CRLOC53.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 294)) OR (CRLOC53.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 294)) OR (CRLOC54.related_content_id =300) OR (CRLOC54.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 300)) OR (CRLOC54.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 300)) OR (CRLOC54.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 300)) OR (CRLOC54.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 300)) OR (CRLOC55.related_content_id =303) OR (CRLOC55.related_content_id = ANY (SELECT LEVEL1004.content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.related_content_id = 303)) OR (CRLOC55.related_content_id = ANY (SELECT LEVEL1004.related_content_id FROM content_relationships LEVEL1004 WHERE LEVEL1004.relationship_id=12 AND LEVEL1004.content_id = 303)) OR (CRLOC55.related_content_id = ANY (SELECT LEVEL1003.related_content_id FROM content_relationships LEVEL1003 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1003.relationship_id=14 AND LEVEL1004.content_id = 303)) OR (CRLOC55.related_content_id = ANY (SELECT LEVEL1002.related_content_id FROM content_relationships LEVEL1002 INNER JOIN content_relationships LEVEL1003  ON LEVEL1003.related_content_id = LEVEL1002.content_id   AND LEVEL1003.relationship_id = 14 INNER JOIN content_relationships LEVEL1004  ON LEVEL1004.related_content_id = LEVEL1003.content_id   AND LEVEL1004.relationship_id = 12 WHERE LEVEL1002.relationship_id=17 AND LEVEL1004.content_id = 303))) ORDER BY C.create_time ASC) |