| 111 | transcom    | localhost | transcom | Query   |  171 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Danish')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 112 | transcom    | localhost | transcom | Query   |  169 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 113 | transcom    | localhost | transcom | Query   |  168 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 114 | transcom    | localhost | transcom | Query   |  167 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 120 | transcom    | localhost | transcom | Query   |  160 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 10 |    0.000 |
| 121 | transcom    | localhost | transcom | Query   |  158 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 20 |    0.000 |
| 122 | transcom    | localhost | transcom | Query   |  157 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 30 |    0.000 |
| 134 | transcom    | localhost | transcom | Query   |  145 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 136 | transcom    | localhost | transcom | Query   |  145 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 137 | transcom    | localhost | transcom | Query   |  145 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan', 'Bosnian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 0 |    0.000 |
| 138 | transcom    | localhost | transcom | Query   |  143 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian', 'Catalan')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 30 |    0.000 |
| 139 | transcom    | localhost | transcom | Query   |  142 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 30 |    0.000 |
| 162 | transcom    | localhost | transcom | Query   |  120 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 30 |    0.000 |
| 163 | transcom    | localhost | transcom | Query   |  120 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 30 |    0.000 |
| 164 | transcom    | localhost | transcom | Query   |  120 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid
LIMIT 11 OFFSET 30 |    0.000 |
| 165 | transcom    | localhost | transcom | Query   |  119 | Statistics               | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_taxonomy_language"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_3" ON "taxonomy_term_data_3"."tid" = "node__field_job_type"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_4" ON "taxonomy_term_data_4"."tid" = "node__field_taxonomy_country_2"."field_taxonomy_country_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_5" ON "taxonomy_term_data_5"."tid" = "node__field_taxonomy_language_2"."field_taxonomy_language_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data_6" ON "taxonomy_term_data_6"."tid" = "node__field_job_type_2"."field_job_type_target_id"
INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
WHERE (("taxonomy_term_field_data"."name" IN ('Serbia')) and ("taxonomy_term_field_data_2"."name" IN ('Croatian')) and ("taxonomy_term_field_data_3"."name" IN ('Customer Service Representative (CSR)'))) AND ("taxonomy_term_field_data_4"."status" = '1') AND ("node_field_data"."status" = '1') AND ("taxonomy_term_field_data_5"."status" = '1') AND ("node_field_data_2"."status" = '1') AND ("taxonomy_term_field_data_6"."status" = '1') AND ("node_field_data_3"."status" = '1') AND ("node_field_data_4"."type" = 'job_offering') AND (EXISTS (SELECT "na"."nid" AS "nid"
FROM
"node_access" "na"
WHERE ((("gid" IN ('0')) AND ("realm" = 'all')) OR (("gid" IN ('13165632')) AND ("realm" = 'domain_id')) OR (("gid" IN ('0')) AND ("realm" = 'domain_site'))) AND ("na"."grant_view" >= '1') AND ("na"."fallback" = '1') AND (("base_table"."nid" = "na"."nid"))))
GROUP BY base_table.vid, base_table.nid