Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- | 195 | transcom | localhost | transcom | Query | 36 | 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 |
- | 221 | transcom | localhost | transcom | Query | 24 | 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 ('Italy')) and ("taxonomy_term_field_data_2"."name" IN ('Italian')) and ("taxonomy_term_field_data_3"."name" IN ('Marketing', 'Operations'))) 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 ('2259943')) 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 |
- | 234 | transcom | localhost | transcom | Query | 16 | 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 ('Greek')) 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 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement