Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- doc_documents.id doc_id,
- doc_documents.projection_isbd doc_isbd
- FROM
- doc_documents
- LEFT JOIN doc_document_authors ON doc_document_authors.document_id = doc_documents.id
- LEFT JOIN usr_users ON usr_users.id = doc_document_authors.user_id
- WHERE
- doc_documents.status = 'CONFIRMED' AND
- db_type = 'PDB' AND
- deleted = 'f' AND
- usr_users.title ilike $1
- ORDER BY
- doc_documents.publish_date desc
- SELECT
- doc_documents.id doc_id,
- doc_documents.projection_isbd doc_isbd
- FROM
- doc_documents
- LEFT JOIN doc_document_authors ON doc_document_authors.document_id = doc_documents.id
- LEFT JOIN usr_users ON usr_users.id = doc_document_authors.user_id
- WHERE
- doc_documents.status = 'CONFIRMED' AND
- db_type = 'PDB' AND
- deleted = 'f' AND
- (usr_users.title ilike $1 AND
- usr_users.title ilike $2)
- ORDER BY
- doc_documents.publish_date desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement