Advertisement
Guest User

Untitled

a guest
Oct 24th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. SELECT
  2. doc_documents.id doc_id,
  3. doc_documents.projection_isbd doc_isbd
  4. FROM
  5. doc_documents
  6. LEFT JOIN doc_document_authors ON doc_document_authors.document_id = doc_documents.id
  7. LEFT JOIN usr_users ON usr_users.id = doc_document_authors.user_id
  8. WHERE
  9. doc_documents.status = 'CONFIRMED' AND
  10. db_type = 'PDB' AND
  11. deleted = 'f' AND
  12. usr_users.title ilike $1
  13. ORDER BY
  14. doc_documents.publish_date desc
  15.  
  16. SELECT
  17. doc_documents.id doc_id,
  18. doc_documents.projection_isbd doc_isbd
  19. FROM
  20. doc_documents
  21. LEFT JOIN doc_document_authors ON doc_document_authors.document_id = doc_documents.id
  22. LEFT JOIN usr_users ON usr_users.id = doc_document_authors.user_id
  23. WHERE
  24. doc_documents.status = 'CONFIRMED' AND
  25. db_type = 'PDB' AND
  26. deleted = 'f' AND
  27. (usr_users.title ilike $1 AND
  28. usr_users.title ilike $2)
  29. ORDER BY
  30. doc_documents.publish_date desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement