search_cop2.sql

SELECT "jobs"."id" AS t0_r0,
       "jobs"."ro_number" AS t0_r1,
       "jobs"."ro_value" AS t0_r2,
       "jobs"."upsell_value" AS t0_r3,
       "jobs"."technician_id" AS t0_r4,
       "jobs"."customer_id" AS t0_r5,
       "jobs"."end_behaviour" AS t0_r6,
       "jobs"."status" AS t0_r7,
       "jobs"."created_at" AS t0_r8,
       "jobs"."updated_at" AS t0_r9,
       "jobs"."dealership_id" AS t0_r10,
       "jobs"."author_id" AS t0_r11,
       "jobs"."closed_at" AS t0_r12,
       "jobs"."videos_count" AS t0_r13,
       "jobs"."watches_count" AS t0_r14,
       "jobs"."final_ro_value" AS t0_r15,
       "jobs"."guid" AS t0_r16,
       "jobs"."callback_requested_at" AS t0_r17,
       "jobs"."send_reminder_at" AS t0_r18,
       "jobs"."reminder_sent_at" AS t0_r19,
       "jobs"."upsell_percentage" AS t0_r20,
       "users"."id" AS t1_r0,
       "users"."email" AS t1_r1,
       "users"."encrypted_password" AS t1_r2,
       "users"."reset_password_token" AS t1_r3,
       "users"."reset_password_sent_at" AS t1_r4,
       "users"."remember_created_at" AS t1_r5,
       "users"."sign_in_count" AS t1_r6,
       "users"."current_sign_in_at" AS t1_r7,
       "users"."last_sign_in_at" AS t1_r8,
       "users"."current_sign_in_ip" AS t1_r9,
       "users"."last_sign_in_ip" AS t1_r10,
       "users"."confirmation_token" AS t1_r11,
       "users"."confirmed_at" AS t1_r12,
       "users"."confirmation_sent_at" AS t1_r13,
       "users"."unconfirmed_email" AS t1_r14,
       "users"."failed_attempts" AS t1_r15,
       "users"."unlock_token" AS t1_r16,
       "users"."locked_at" AS t1_r17,
       "users"."authentication_token" AS t1_r18,
       "users"."name" AS t1_r19,
       "users"."phone" AS t1_r20,
       "users"."role" AS t1_r21,
       "users"."dealership_id" AS t1_r22,
       "users"."jobs_count" AS t1_r23,
       "users"."videos_count" AS t1_r24,
       "users"."is_admin" AS t1_r25,
       "users"."created_at" AS t1_r26,
       "users"."updated_at" AS t1_r27
FROM "jobs"
LEFT OUTER JOIN "users" ON "users"."id" = "jobs"."customer_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 "technicians_jobs"."name" ILIKE '%email@email.com%'
        OR "technicians_jobs"."email" ILIKE '%email@email.com%'
        OR "technicians_jobs"."phone" ILIKE '%email@email.com%'
        OR "authors_jobs"."name" ILIKE '%email@email.com%'
        OR "authors_jobs"."email" ILIKE '%email@email.com%'
        OR "authors_jobs"."phone" ILIKE '%email@email.com%'))