associated_against - after

query.sql

SELECT     "products".* 
FROM       "products" 
inner join 
           ( 
             SELECT          "products"."id" AS pg_search_id, 
                             GREATEST(
                               pg_search_455a24ed3ca763c7a72181.pg_search_9f77ffbdbddcb603b080a8,
                               (Ts_rank((To_tsvector('simple', Coalesce("products"."name"::text, ''))
                                               || To_tsvector('simple', Coalesce(pg_search_455a24ed3ca763c7a72181.pg_search_9f77ffbdbddcb603b080a8::text, ''))), (To_tsquery('simple', ''' '
                                               || 'QueryString' 
                                               || ' ''' 
                                               || ':*')), 0))
                             ) AS rank 
             FROM            "products" 
             left outer join 
                             ( 
                                SELECT     "products"."id"                 AS id,
                                           MAX(
                                            (Ts_rank((To_tsvector('simple', Coalesce("tags"."name"::text, ''))), (To_tsquery('simple', ''' '
                                               || 'QueryString' 
                                               || ' ''' 
                                               || ':*')), 0))
                                           ) AS pg_search_9f77ffbdbddcb603b080a8
                                FROM       "products" 
                                inner join "products_tags" 
                                ON         "products_tags"."product_id" = "products"."id"
                                inner join "tags" 
                                ON         "tags"."id" = "products_tags"."tag_id"
                                WHERE (To_tsvector('simple', Coalesce("tags"."name"::text, ''))) @@ (To_tsquery('simple', ''' ' || 'QueryString' || ' ''' || ':*'))
                                GROUP BY   "products"."id") pg_search_455a24ed3ca763c7a72181
             ON              pg_search_455a24ed3ca763c7a72181.id = "products"."id"
             WHERE           pg_search_455a24ed3ca763c7a72181.id IS NOT NULL OR ((( 
                                 To_tsvector('simple', Coalesce("products"."name"::text, ''))) @@ (to_tsquery('simple', ''' '
                                 || 'QueryString'
                                 || ' '''
                                 || ':*'))))) AS pg_search_02b78575ff05a3f5042de1
ON         "products"."id" = pg_search_02b78575ff05a3f5042de1.pg_search_id 
ORDER BY   pg_search_02b78575ff05a3f5042de1.rank DESC, "products"."id" ASC limit 50 offset 0