Advertisement
Guest User

Distinct DBIC query

a guest
Apr 9th, 2012
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.75 KB | None | 0 0
  1. SELECT DISTINCT ON(me.thread) me.thread, "me"."id", "me"."source", "me"."target", "me"."date", "me"."title", "me"."text", "me"."car", "me"."transaction", "me"."payment", "me"."is_read", "source_linked"."id", "source_linked"."email", "source_linked"."fullname", "source_linked"."password", "source_linked"."salt", "source_linked"."activated", "source_linked"."activation_code", "source_linked"."date", "source_linked"."recovery_code", "source_linked"."can_login", "target_linked"."id", "target_linked"."email", "target_linked"."fullname", "target_linked"."password", "target_linked"."salt", "target_linked"."activated", "target_linked"."activation_code", "target_linked"."date", "target_linked"."recovery_code", "target_linked"."can_login", "car_linked"."id", "car_linked"."location", "car_linked"."price_hourly", "car_linked"."price_daily", "car_linked"."manufacturer", "car_linked"."model", "car_linked"."gearbox", "car_linked"."fuel", "car_linked"."year", "car_linked"."capacity", "car_linked"."description", "car_linked"."seller_will_drive", "car_linked"."body", "car_linked"."date", "car_linked"."user", "car_linked"."is_available", "car_linked"."deleted", "payment_linked"."id", "payment_linked"."source", "payment_linked"."target", "payment_linked"."source_document", "payment_linked"."target_document", "payment_linked"."date", "payment_linked"."user", "payment_linked"."type", "payment_linked"."money_amount_brutto", "payment_linked"."money_currency", "payment_linked"."credits_amount_brutto", "payment_linked"."status", "payment_linked"."fee_credits", "payment_linked"."fee_money", "payment_linked"."fee_type", "payment_linked"."fee_for_source", "payment_linked"."money_amount_netto", "payment_linked"."credits_amount_netto", "payment_linked"."transaction", "transaction_linked"."id", "transaction_linked"."car", "transaction_linked"."date_start", "transaction_linked"."date_end", "transaction_linked"."buyer", "transaction_linked"."seller", "transaction_linked"."buyer_request_date", "transaction_linked"."seller_request_date", "transaction_linked"."seller_request_status", "transaction_linked"."buyer_request_status", "transaction_linked"."time_start", "transaction_linked"."time_end", "transaction_linked"."feedback", "transaction_linked"."price" FROM "messages" "me"  JOIN "users" "source_linked" ON "source_linked"."id" = "me"."source"  JOIN "users" "target_linked" ON "target_linked"."id" = "me"."target" LEFT JOIN "cars" "car_linked" ON "car_linked"."id" = "me"."car" LEFT JOIN "payments" "payment_linked" ON "payment_linked"."id" = "me"."payment" LEFT JOIN "transactions" "transaction_linked" ON "transaction_linked"."id" = "me"."transaction" WHERE ( ( ( "me"."source" = ? AND ( "me"."is_system" = ? OR "me"."is_system" IS NULL ) ) OR "me"."target" = ? ) ) LIMIT ? OFFSET ?: '1', '0', '1', '10', '10'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement