Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.77 KB | None | 0 0
  1. SELECT "adverts_advert"."id", "adverts_advert"."title", "adverts_advert"."rubric_id", "adverts_advert"."description", "adverts_advert"."city_id", "adverts_advert"."user_id", "adverts_advert"."slug", "adverts_advert"."created", "adverts_advert"."published", "adverts_advert"."updated", "adverts_advert"."price", "adverts_advert"."currency_id", "adverts_advert"."exchange", "adverts_advert"."negotiable_price", "adverts_advert"."attrs", "adverts_advert"."archived", "adverts_advert"."allowed", "adverts_advert"."declined", "adverts_advert"."skipped", "adverts_advert"."is_blocked", "adverts_advert"."hit_count", "adverts_advert"."moderator_check", "adverts_advert"."phone_hitcount", "adverts_advert"."phone_hide", "adverts_advert"."phone_verify", "adverts_advert"."changed", "adverts_advert"."changed_date", "adverts_advert"."user_info", "adverts_advert"."geometry", "adverts_advert"."top_start_date", "adverts_advert"."top_end_date", "adverts_advert"."top_pause_remain", "adverts_advert"."zoom", "adverts_advert"."phone", to_tsvector(english::regconfig, COALESCE("adverts_advert"."title", )) AS "search" FROM "adverts_advert" WHERE ("adverts_advert"."archived" = False AND "adverts_advert"."allowed" = True AND "adverts_advert"."declined" = False AND to_tsvector(english::regconfig, COALESCE("adverts_advert"."title", )) @@ (plainto_tsquery(english::regconfig, ytuty)) = true) ORDER BY "adverts_advert"."created" DESC
  2.  
  3.  
  4. SELECT "adverts_advert"."id", "adverts_advert"."title", "adverts_advert"."rubric_id", "adverts_advert"."description", "adverts_advert"."city_id", "adverts_advert"."user_id", "adverts_advert"."slug", "adverts_advert"."created", "adverts_advert"."published", "adverts_advert"."updated", "adverts_advert"."price", "adverts_advert"."currency_id", "adverts_advert"."exchange", "adverts_advert"."negotiable_price", "adverts_advert"."attrs", "adverts_advert"."archived", "adverts_advert"."allowed", "adverts_advert"."declined", "adverts_advert"."skipped", "adverts_advert"."is_blocked", "adverts_advert"."hit_count", "adverts_advert"."moderator_check", "adverts_advert"."phone_hitcount", "adverts_advert"."phone_hide", "adverts_advert"."phone_verify", "adverts_advert"."changed", "adverts_advert"."changed_date", "adverts_advert"."user_info", "adverts_advert"."geometry", "adverts_advert"."top_start_date", "adverts_advert"."top_end_date", "adverts_advert"."top_pause_remain", "adverts_advert"."zoom", "adverts_advert"."phone", to_tsvector(english::regconfig, COALESCE("adverts_advert"."title", )) AS "search" FROM "adverts_advert" WHERE ("adverts_advert"."archived" = False AND "adverts_advert"."allowed" = True AND "adverts_advert"."declined" = False AND to_tsvector(english::regconfig, COALESCE("adverts_advert"."title", )) @@ (plainto_tsquery(english::regconfig, ytutyu)) = true) ORDER BY "adverts_advert"."created" DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement