Skip to content

Instantly share code, notes, and snippets.

@mbajur

mbajur/search_cop3.sql Secret

Created September 10, 2014 19:33
Show Gist options
  • Save mbajur/bbd560f4a1713bf68b37 to your computer and use it in GitHub Desktop.
Save mbajur/bbd560f4a1713bf68b37 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
search_cop3.sql
SELECT "jobs".*
FROM "jobs"
LEFT OUTER JOIN users customer ON customer.id = jobs.customer_id
LEFT OUTER JOIN users technician ON technician.id = jobs.technician_id
LEFT OUTER JOIN users author ON author.id = jobs.author_id
WHERE (("jobs"."status" ILIKE '%email@email.com%'
OR "jobs"."ro_number" ILIKE '%email@email.com%'
OR "jobs"."end_behaviour" ILIKE '%email@email.com%'
OR "users"."name" ILIKE '%email@email.com%'
OR "users"."email" ILIKE '%email@email.com%'
OR "users"."phone" ILIKE '%email@email.com%'
OR "users"."name" ILIKE '%email@email.com%'
OR "users"."email" ILIKE '%email@email.com%'
OR "users"."phone" ILIKE '%email@email.com%'
OR "users"."name" ILIKE '%email@email.com%'
OR "users"."email" ILIKE '%email@email.com%'
OR "users"."phone" ILIKE '%email@email.com%'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment