gistfile1.sql

SELECT DISTINCT field_data_field_referring_domain0.entity_type AS entity_type, field_data_field_referring_domain0.entity_id AS entity_id, field_data_field_referring_domain0.revision_id AS revision_id, field_data_field_referring_domain0.bundle AS bundle
FROM 
{field_data_field_referring_domain} field_data_field_referring_domain0
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain1 ON field_data_field_referring_domain1.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain1.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain2 ON field_data_field_referring_domain2.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain2.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain3 ON field_data_field_referring_domain3.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain3.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain4 ON field_data_field_referring_domain4.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain4.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain5 ON field_data_field_referring_domain5.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain5.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain6 ON field_data_field_referring_domain6.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain6.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain7 ON field_data_field_referring_domain7.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain7.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain8 ON field_data_field_referring_domain8.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain8.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain9 ON field_data_field_referring_domain9.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain9.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain10 ON field_data_field_referring_domain10.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain10.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain11 ON field_data_field_referring_domain11.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain11.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain12 ON field_data_field_referring_domain12.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain12.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain13 ON field_data_field_referring_domain13.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain13.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain14 ON field_data_field_referring_domain14.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain14.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain15 ON field_data_field_referring_domain15.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain15.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain16 ON field_data_field_referring_domain16.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain16.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain17 ON field_data_field_referring_domain17.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain17.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain18 ON field_data_field_referring_domain18.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain18.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain19 ON field_data_field_referring_domain19.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain19.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {field_data_field_referring_domain} field_data_field_referring_domain20 ON field_data_field_referring_domain20.entity_type = field_data_field_referring_domain0.entity_type AND field_data_field_referring_domain20.entity_id = field_data_field_referring_domain0.entity_id
INNER JOIN {telus_entity} telus_entity ON telus_entity.id = field_data_field_referring_domain0.entity_id
WHERE  (field_data_field_referring_domain0.field_referring_domain_value LIKE '%example.com%' ESCAPE '\\') OR (field_data_field_referring_domain1.field_referring_domain_value LIKE '%prom\\_page%' ESCAPE '\\') OR (field_data_field_referring_domain2.field_referring_domain_value LIKE '%workperks%' ESCAPE '\\') OR (field_data_field_referring_domain3.field_referring_domain_value LIKE '%company%' ESCAPE '\\') OR (field_data_field_referring_domain4.field_referring_domain_value LIKE '%acro%' ESCAPE '\\') OR (field_data_field_referring_domain5.field_referring_domain_value LIKE '%RBC%' ESCAPE '\\') OR (field_data_field_referring_domain6.field_referring_domain_value LIKE '%foo%' ESCAPE '\\') OR (field_data_field_referring_domain7.field_referring_domain_value LIKE '%that%' ESCAPE '\\') OR (field_data_field_referring_domain8.field_referring_domain_value LIKE '%somethingelse%' ESCAPE '\\') OR (field_data_field_referring_domain9.field_referring_domain_value LIKE '%ba  r%' ESCAPE '\\') OR (field_data_field_referring_domain10.field_referring_domain_value LIKE '%baz%' ESCAPE '\\') OR (field_data_field_referring_domain11.field_referring_domain_value LIKE '%bar%' ESCAPE '\\') OR (field_data_field_referring_domain12.field_referring_domain_value LIKE '%baz%' ESCAPE '\\') OR (field_data_field_referring_domain13.field_referring_domain_value LIKE '%key%' ESCAPE '\\') OR (field_data_field_referring_domain14.field_referring_domain_value LIKE '%another%' ESCAPE '\\') OR (field_data_field_referring_domain15.field_referring_domain_value LIKE '%this%' ESCAPE '\\') OR (field_data_field_referring_domain16.field_referring_domain_value LIKE '%whatever%' ESCAPE '\\') OR (field_data_field_referring_domain17.field_referring_domain_value LIKE '%fo\\%20o[0]%' ESCAPE '\\') OR (field_data_field_referring_domain18.field_referring_domain_value LIKE '%fo\\%20o[1]%' ESCAPE '\\') OR (field_data_field_referring_domain19.field_referring_domain_value LIKE '%ejemplo[foo][0]%' ESCAPE '\\') OR (field_data_field_referring_domain20.field_referring_domain_value LIKE '%ejemplo[foo][1]%' ESCAPE '\\') OR (field_data_field_referring_domain0.deleted = '0') OR (telus_entity.status = '1') OR (field_data_field_referring_domain0.entity_type = 'telus_entity') OR (field_data_field_referring_domain0.bundle = 'organization')