Created
August 15, 2016 23:17
-
-
Save jeffleeismyhero/3e3abd329f125aa55f0a31f684c2e279 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT events.* FROM "events" INNER JOIN "operating_schedule_events" ON "operating_schedule_events"."event_id" = "events"."id" INNER JOIN "operating_schedules" ON "operating_schedules"."id" = "operating_schedule_events"."operating_schedule_id" INNER JOIN (SELECT "events"."id" AS pg_search_id, (ts_rank((setweight(to_tsvector('english', unaccent(coalesce(pg_search_2e71682eeb42285accc2d8.pg_search_8cef9fe4cc3d76103d145d::text, ''))), 'B') || setweight(to_tsvector('english', unaccent(coalesce(pg_search_b229fd995799cea4ca76c4.pg_search_93f916f001b6b057ee2922::text, ''))), 'C') || "events"."tsv"), (to_tsquery('english', ''' ' || unaccent('Pizza') || ' ''' || ':*')), 0)) AS rank FROM "events" LEFT OUTER JOIN (SELECT "events"."id" AS id, string_agg("tags"."name"::text, ' ') AS pg_search_8cef9fe4cc3d76103d145d FROM "events" INNER JOIN "taggings" ON "taggings"."taggable_id" = "events"."id" AND "taggings"."context" = 'aliases' AND "taggings"."taggable_type" = 'Event' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" GROUP BY "events"."id") pg_search_2e71682eeb42285accc2d8 ON pg_search_2e71682eeb42285accc2d8.id = "events"."id" LEFT OUTER JOIN (SELECT "events"."id" AS id, string_agg("tags"."name"::text, ' ') AS pg_search_93f916f001b6b057ee2922 FROM "events" INNER JOIN "taggings" ON "taggings"."taggable_id" = "events"."id" AND "taggings"."context" = 'tags' AND "taggings"."taggable_type" = 'Event' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" GROUP BY "events"."id") pg_search_b229fd995799cea4ca76c4 ON pg_search_b229fd995799cea4ca76c4.id = "events"."id" WHERE (((setweight(to_tsvector('english', unaccent(coalesce(pg_search_2e71682eeb42285accc2d8.pg_search_8cef9fe4cc3d76103d145d::text, ''))), 'B') || setweight(to_tsvector('english', unaccent(coalesce(pg_search_b229fd995799cea4ca76c4.pg_search_93f916f001b6b057ee2922::text, ''))), 'C') || "events"."tsv") @@ (to_tsquery('english', ''' ' || unaccent('Pizza') || ' ''' || ':*'))))) AS pg_search_862417b9e7c3720bcb3263 ON "events"."id" = pg_search_862417b9e7c3720bcb3263.pg_search_id WHERE "events"."active" = TRUE AND "events"."active" = TRUE AND "events"."published" = TRUE AND (operating_schedules.ends_at IS NULL OR operating_schedules.ends_at >= '2016-08-15') GROUP BY events.id HAVING events.id > 0 ORDER BY events.name ASC LIMIT 10 OFFSET 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment