API tools faq
paste
Advertisement
nop1984

1111

nop1984
Dec 14th, 2022
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 63.79 KB | None | 0 0
raw download clone embed print report
  1. | 111 | transcom | localhost | transcom | Query | 171 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  2. FROM
  3. "node" "base_table"
  4. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  5. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  6. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  7. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  8. 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"
  9. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  10. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  11. 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"
  12. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  13. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  14. 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"
  15. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  16. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  17. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  18. 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"
  19. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  20. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  21. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  22. 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"
  23. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  24. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  25. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  26. 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"
  27. FROM
  28. "node_access" "na"
  29. 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"))))
  30. GROUP BY base_table.vid, base_table.nid
  31. LIMIT 11 OFFSET 0 | 0.000 |
  32. | 112 | transcom | localhost | transcom | Query | 169 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  33. FROM
  34. "node" "base_table"
  35. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  36. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  37. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  38. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  39. 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"
  40. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  41. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  42. 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"
  43. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  44. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  45. 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"
  46. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  47. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  48. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  49. 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"
  50. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  51. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  52. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  53. 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"
  54. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  55. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  56. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  57. 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"
  58. FROM
  59. "node_access" "na"
  60. 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"))))
  61. GROUP BY base_table.vid, base_table.nid
  62. LIMIT 11 OFFSET 0 | 0.000 |
  63. | 113 | transcom | localhost | transcom | Query | 168 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  64. FROM
  65. "node" "base_table"
  66. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  67. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  68. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  69. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  70. 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"
  71. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  72. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  73. 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"
  74. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  75. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  76. 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"
  77. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  78. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  79. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  80. 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"
  81. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  82. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  83. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  84. 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"
  85. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  86. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  87. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  88. 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"
  89. FROM
  90. "node_access" "na"
  91. 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"))))
  92. GROUP BY base_table.vid, base_table.nid
  93. LIMIT 11 OFFSET 0 | 0.000 |
  94. | 114 | transcom | localhost | transcom | Query | 167 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  95. FROM
  96. "node" "base_table"
  97. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  98. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  99. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  100. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  101. 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"
  102. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  103. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  104. 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"
  105. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  106. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  107. 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"
  108. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  109. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  110. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  111. 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"
  112. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  113. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  114. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  115. 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"
  116. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  117. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  118. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  119. 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"
  120. FROM
  121. "node_access" "na"
  122. 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"))))
  123. GROUP BY base_table.vid, base_table.nid
  124. LIMIT 11 OFFSET 0 | 0.000 |
  125. | 120 | transcom | localhost | transcom | Query | 160 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  126. FROM
  127. "node" "base_table"
  128. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  129. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  130. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  131. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  132. 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"
  133. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  134. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  135. 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"
  136. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  137. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  138. 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"
  139. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  140. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  141. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  142. 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"
  143. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  144. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  145. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  146. 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"
  147. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  148. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  149. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  150. 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"
  151. FROM
  152. "node_access" "na"
  153. 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"))))
  154. GROUP BY base_table.vid, base_table.nid
  155. LIMIT 11 OFFSET 10 | 0.000 |
  156. | 121 | transcom | localhost | transcom | Query | 158 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  157. FROM
  158. "node" "base_table"
  159. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  160. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  161. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  162. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  163. 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"
  164. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  165. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  166. 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"
  167. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  168. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  169. 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"
  170. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  171. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  172. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  173. 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"
  174. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  175. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  176. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  177. 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"
  178. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  179. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  180. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  181. 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"
  182. FROM
  183. "node_access" "na"
  184. 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"))))
  185. GROUP BY base_table.vid, base_table.nid
  186. LIMIT 11 OFFSET 20 | 0.000 |
  187. | 122 | transcom | localhost | transcom | Query | 157 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  188. FROM
  189. "node" "base_table"
  190. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  191. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  192. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  193. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  194. 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"
  195. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  196. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  197. 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"
  198. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  199. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  200. 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"
  201. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  202. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  203. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  204. 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"
  205. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  206. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  207. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  208. 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"
  209. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  210. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  211. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  212. 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"
  213. FROM
  214. "node_access" "na"
  215. 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"))))
  216. GROUP BY base_table.vid, base_table.nid
  217. LIMIT 11 OFFSET 30 | 0.000 |
  218. | 134 | transcom | localhost | transcom | Query | 145 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  219. FROM
  220. "node" "base_table"
  221. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  222. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  223. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  224. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  225. 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"
  226. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  227. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  228. 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"
  229. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  230. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  231. 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"
  232. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  233. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  234. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  235. 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"
  236. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  237. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  238. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  239. 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"
  240. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  241. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  242. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  243. 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"
  244. FROM
  245. "node_access" "na"
  246. 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"))))
  247. GROUP BY base_table.vid, base_table.nid
  248. LIMIT 11 OFFSET 0 | 0.000 |
  249. | 136 | transcom | localhost | transcom | Query | 145 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  250. FROM
  251. "node" "base_table"
  252. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  253. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  254. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  255. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  256. 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"
  257. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  258. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  259. 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"
  260. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  261. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  262. 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"
  263. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  264. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  265. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  266. 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"
  267. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  268. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  269. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  270. 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"
  271. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  272. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  273. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  274. 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"
  275. FROM
  276. "node_access" "na"
  277. 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"))))
  278. GROUP BY base_table.vid, base_table.nid
  279. LIMIT 11 OFFSET 0 | 0.000 |
  280. | 137 | transcom | localhost | transcom | Query | 145 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  281. FROM
  282. "node" "base_table"
  283. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  284. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  285. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  286. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  287. 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"
  288. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  289. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  290. 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"
  291. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  292. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  293. 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"
  294. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  295. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  296. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  297. 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"
  298. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  299. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  300. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  301. 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"
  302. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  303. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  304. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  305. 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"
  306. FROM
  307. "node_access" "na"
  308. 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"))))
  309. GROUP BY base_table.vid, base_table.nid
  310. LIMIT 11 OFFSET 0 | 0.000 |
  311. | 138 | transcom | localhost | transcom | Query | 143 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  312. FROM
  313. "node" "base_table"
  314. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  315. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  316. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  317. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  318. 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"
  319. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  320. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  321. 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"
  322. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  323. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  324. 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"
  325. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  326. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  327. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  328. 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"
  329. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  330. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  331. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  332. 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"
  333. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  334. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  335. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  336. 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"
  337. FROM
  338. "node_access" "na"
  339. 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"))))
  340. GROUP BY base_table.vid, base_table.nid
  341. LIMIT 11 OFFSET 30 | 0.000 |
  342. | 139 | transcom | localhost | transcom | Query | 142 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  343. FROM
  344. "node" "base_table"
  345. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  346. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  347. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  348. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  349. 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"
  350. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  351. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  352. 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"
  353. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  354. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  355. 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"
  356. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  357. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  358. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  359. 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"
  360. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  361. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  362. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  363. 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"
  364. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  365. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  366. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  367. 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"
  368. FROM
  369. "node_access" "na"
  370. 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"))))
  371. GROUP BY base_table.vid, base_table.nid
  372. LIMIT 11 OFFSET 30 | 0.000 |
  373. | 162 | transcom | localhost | transcom | Query | 120 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  374. FROM
  375. "node" "base_table"
  376. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  377. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  378. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  379. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  380. 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"
  381. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  382. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  383. 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"
  384. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  385. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  386. 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"
  387. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  388. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  389. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  390. 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"
  391. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  392. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  393. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  394. 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"
  395. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  396. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  397. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  398. 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"
  399. FROM
  400. "node_access" "na"
  401. 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"))))
  402. GROUP BY base_table.vid, base_table.nid
  403. LIMIT 11 OFFSET 30 | 0.000 |
  404. | 163 | transcom | localhost | transcom | Query | 120 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  405. FROM
  406. "node" "base_table"
  407. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  408. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  409. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  410. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  411. 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"
  412. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  413. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  414. 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"
  415. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  416. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  417. 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"
  418. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  419. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  420. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  421. 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"
  422. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  423. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  424. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  425. 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"
  426. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  427. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  428. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  429. 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"
  430. FROM
  431. "node_access" "na"
  432. 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"))))
  433. GROUP BY base_table.vid, base_table.nid
  434. LIMIT 11 OFFSET 30 | 0.000 |
  435. | 164 | transcom | localhost | transcom | Query | 120 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  436. FROM
  437. "node" "base_table"
  438. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  439. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  440. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  441. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  442. 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"
  443. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  444. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  445. 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"
  446. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  447. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  448. 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"
  449. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  450. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  451. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  452. 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"
  453. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  454. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  455. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  456. 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"
  457. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  458. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  459. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  460. 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"
  461. FROM
  462. "node_access" "na"
  463. 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"))))
  464. GROUP BY base_table.vid, base_table.nid
  465. LIMIT 11 OFFSET 30 | 0.000 |
  466. | 165 | transcom | localhost | transcom | Query | 119 | Statistics | SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
  467. FROM
  468. "node" "base_table"
  469. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country" ON "node__field_taxonomy_country"."entity_id" = "base_table"."nid"
  470. LEFT OUTER JOIN "taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_taxonomy_country"."field_taxonomy_country_target_id"
  471. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
  472. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language" ON "node__field_taxonomy_language"."entity_id" = "base_table"."nid"
  473. 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"
  474. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
  475. INNER JOIN "node__field_job_type" "node__field_job_type" ON "node__field_job_type"."entity_id" = "base_table"."nid"
  476. 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"
  477. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_3" ON "taxonomy_term_field_data_3"."tid" = "taxonomy_term_data_3"."tid"
  478. INNER JOIN "node__field_taxonomy_country" "node__field_taxonomy_country_2" ON "node__field_taxonomy_country_2"."entity_id" = "base_table"."nid"
  479. 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"
  480. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_4" ON "taxonomy_term_field_data_4"."tid" = "taxonomy_term_data_4"."tid"
  481. INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
  482. INNER JOIN "node__field_taxonomy_language" "node__field_taxonomy_language_2" ON "node__field_taxonomy_language_2"."entity_id" = "base_table"."nid"
  483. 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"
  484. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_5" ON "taxonomy_term_field_data_5"."tid" = "taxonomy_term_data_5"."tid"
  485. INNER JOIN "node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "base_table"."nid"
  486. INNER JOIN "node__field_job_type" "node__field_job_type_2" ON "node__field_job_type_2"."entity_id" = "base_table"."nid"
  487. 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"
  488. INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_6" ON "taxonomy_term_field_data_6"."tid" = "taxonomy_term_data_6"."tid"
  489. INNER JOIN "node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
  490. INNER JOIN "node_field_data" "node_field_data_4" ON "node_field_data_4"."nid" = "base_table"."nid"
  491. 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"
  492. FROM
  493. "node_access" "na"
  494. 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"))))
  495. GROUP BY base_table.vid, base_table.nid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!