-- full_query -- select receipt1_.id as col_0_0_, coalesce(organizati16_.SHORT_NAME, organizati16_.FULL_NAME) as col_1_0_, receipttyp17_.name as col_2_0_, receipt1_.issue_dt as col_3_0_, patient10_.id as col_4_0_, individual11_.name as col_5_0_, individual11_.surname as col_6_0_, individual11_.patr_name as col_7_0_, individual11_.birth_dt as col_8_0_, fundingsou2_.name as col_9_0_, receiptper3_.name as col_10_0_, receipt1_.series as col_11_0_, receipt1_.number as col_12_0_, diagnosis4_.name as col_13_0_, diagnosis4_.code as col_14_0_, medicalroo6_1_.name as col_15_0_, receipt1_.canceled as col_16_0_, coalesce(organizati5_.SHORT_NAME, organizati5_.FULL_NAME) as col_17_0_, individual9_.id as col_18_0_, individual9_.name as col_19_0_, individual9_.surname as col_20_0_, individual9_.patr_name as col_21_0_, receiptimp0_.id as col_22_0_, receiptimp0_.begin_date as col_23_0_, receiptimp0_.is_deferred as col_24_0_, receiptimp0_.deferred_date as col_25_0_, (select md_receipt__get_medicines(receipt1_.id)) as col_26_0_, benefittyp13_.name as col_27_0_, benefitdef14_.name as col_28_0_, receipttyp17_.code as col_29_0_ from md_receipt_implementation_info receiptimp0_ right outer join md_receipt receipt1_ on receiptimp0_.receipt_id=receipt1_.id left outer join fin_funding_source_type fundingsou2_ on receipt1_.funding_source_type_id=fundingsou2_.id left outer join md_receipt_percent_payment receiptper3_ on receipt1_.percent_payment_id=receiptper3_.id left outer join md_diagnosis diagnosis4_ on receipt1_.diagnosis_id=diagnosis4_.id left outer join pim_organization organizati5_ on receipt1_.pharmacy_id=organizati5_.id left outer join pim_party organizati5_1_ on organizati5_.id=organizati5_1_.id left outer join md_room medicalroo6_ on receipt1_.room_id=medicalroo6_.id left outer join pim_room medicalroo6_1_ on medicalroo6_.id=medicalroo6_1_.id left outer join pim_employee_position employeeto7_ on receipt1_.employee_position_id=employeeto7_.id left outer join pim_employee employee8_ on employeeto7_.employee_id=employee8_.id left outer join pim_individual individual9_ on employee8_.individual_id=individual9_.id left outer join pim_party individual9_1_ on individual9_.id=individual9_1_.id left outer join pci_patient patient10_ on receipt1_.patient_id=patient10_.id left outer join pim_individual individual11_ on patient10_.id=individual11_.id left outer join pim_party individual11_1_ on individual11_.id=individual11_1_.id left outer join pci_benefit benefit12_ on receipt1_.benefit_id=benefit12_.id left outer join pci_benefit_type benefittyp13_ on benefit12_.benefit_type_id=benefittyp13_.id left outer join pci_benefit_definition benefitdef14_ on benefit12_.benefit_def_id=benefitdef14_.id, md_clinic clinic15_, pim_organization organizati16_ inner join pim_party organizati16_1_ on organizati16_.id=organizati16_1_.id, md_receipt_type receipttyp17_ where receipt1_.clinic_id=clinic15_.id and clinic15_.id=organizati16_.id and receipt1_.type_id=receipttyp17_.id and (true=true and (receipt1_.clinic_id not in ($1)) or true=true and (receipt1_.clinic_id in ($2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38 , $39 , $40 , $41 , $42 , $43 , $44 , $45 , $46 , $47 , $48 , $49 , $50 , $51 , $52 , $53 , $54 , $55 , $56 , $57 , $58 , $59 , $60 , $61 , $62 , $63 , $64 , $65 , $66 , $67 , $68 , $69 , $70 , $71 , $72 , $73 , $74 , $75 , $76 , $77 , $78 , $79 , $80 , $81 , $82 , $83 , $84 , $85 , $86 , $87 , $88 , $89 , $90 , $91 , $92 , $93 , $94 , $95 , $96 , $97 , $98 , $99 , $100 , $101 , $102 , $103 , $104 , $105 , $106 , $107 , $108 , $109 , $110 , $111 , $112 , $113 , $114 , $115 , $116 , $117 , $118 , $119 , $120 , $121 , $122 , $123 , $124 , $125 , $126 , $127 , $128 , $129 , $130 , $131 , $132 , $133 , $134 , $135 , $136 , $137 , $138 , $139 , $140 , $141 , $142 , $143 , $144 , $145 , $146 , $147 , $148 , $149 , $150 , $151 , $152 , $153 , $154 , $155 , $156 , $157 , $158 , $159 , $160 , $161 , $162 , $163 , $164 , $165 , $166 , $167 , $168 , $169 , $170 , $171 , $172 , $173 , $174 , $175 , $176 , $177 , $178 , $179 , $180 , $181 , $182 , $183 , $184 , $185 , $186 , $187 , $188 , $189 , $190 , $191 , $192 , $193 , $194 , $195 , $196 , $197 , $198 , $199 , $200 , $201 , $202 , $203 , $204 , $205 , $206 , $207 , $208 , $209 , $210 , $211 , $212 , $213 , $214 , $215 , $216 , $217 , $218 , $219 , $220 , $221 , $222 , $223 , $224 , $225 , $226 , $227 , $228 , $229 , $230 , $231 , $232 , $233 , $234 , $235 , $236)) or true=true and (receipt1_.clinic_id not in ($237))) order by 4 desc, receipt1_.id limit $238 -- parsed -- SELECT receipt1_.id AS col__, coalesce(organizati16_.SHORT_NAME, organizati16_.FULL_NAME) AS col__, receipttyp17_.name AS col__, receipt1_.issue_dt AS col__, patient10_.id AS col__, individual11_.name AS col__, individual11_.surname AS col__, individual11_.patr_name AS col__, individual11_.birth_dt AS col__, fundingsou2_.name AS col__, receiptper3_.name AS col__, receipt1_.series AS col__, receipt1_.number AS col__, diagnosis4_.name AS col__, diagnosis4_.code AS col__, medicalroo6_1_.name AS col__, receipt1_.canceled AS col__, coalesce(organizati5_.SHORT_NAME, organizati5_.FULL_NAME) AS col__, individual9_.id AS col__, individual9_.name AS col__, individual9_.surname AS col__, individual9_.patr_name AS col__, receiptimp0_.id AS col__, receiptimp0_.begin_date AS col__, receiptimp0_.is_deferred AS col__, receiptimp0_.deferred_date AS col__, (SELECT md_receipt__get_medicines(receipt1_.id)) AS col__, benefittyp13_.name AS col__, benefitdef14_.name AS col__, receipttyp17_.code AS col__ FROM md_receipt_implementation_info receiptimp0_ RIGHT OUTER JOIN md_receipt receipt1_ ON receiptimp0_.receipt_id=receipt1_.id LEFT OUTER JOIN fin_funding_source_type fundingsou2_ ON receipt1_.funding_source_type_id=fundingsou2_.id LEFT OUTER JOIN md_receipt_percent_payment receiptper3_ ON receipt1_.percent_payment_id=receiptper3_.id LEFT OUTER JOIN md_diagnosis diagnosis4_ ON receipt1_.diagnosis_id=diagnosis4_.id LEFT OUTER JOIN pim_organization organizati5_ ON receipt1_.pharmacy_id=organizati5_.id LEFT OUTER JOIN pim_party organizati5_1_ ON organizati5_.id=organizati5_1_.id LEFT OUTER JOIN md_room medicalroo6_ ON receipt1_.room_id=medicalroo6_.id LEFT OUTER JOIN pim_room medicalroo6_1_ ON medicalroo6_.id=medicalroo6_1_.id LEFT OUTER JOIN pim_employee_position employeeto7_ ON receipt1_.employee_position_id=employeeto7_.id LEFT OUTER JOIN pim_employee employee8_ ON employeeto7_.employee_id=employee8_.id LEFT OUTER JOIN pim_individual individual9_ ON employee8_.individual_id=individual9_.id LEFT OUTER JOIN pim_party individual9_1_ ON individual9_.id=individual9_1_.id LEFT OUTER JOIN pci_patient patient10_ ON receipt1_.patient_id=patient10_.id LEFT OUTER JOIN pim_individual individual11_ ON patient10_.id=individual11_.id LEFT OUTER JOIN pim_party individual11_1_ ON individual11_.id=individual11_1_.id LEFT OUTER JOIN pci_benefit benefit12_ ON receipt1_.benefit_id=benefit12_.id LEFT OUTER JOIN pci_benefit_type benefittyp13_ ON benefit12_.benefit_type_id=benefittyp13_.id LEFT OUTER JOIN pci_benefit_definition benefitdef14_ ON benefit12_.benefit_def_id=benefitdef14_.id, md_clinic clinic15_, pim_organization organizati16_ INNER JOIN pim_party organizati16_1_ ON organizati16_.id=organizati16_1_.id, md_receipt_type receipttyp17_ WHERE receipt1_.clinic_id=clinic15_.id AND clinic15_.id=organizati16_.id AND receipt1_.type_id=receipttyp17_.id AND (TRUE=TRUE AND (receipt1_.clinic_id NOT IN (?)) OR TRUE=TRUE AND (receipt1_.clinic_id IN (?)) OR TRUE=TRUE AND (receipt1_.clinic_id NOT IN (?))) ORDER BY 4 DESC, receipt1_.id LIMIT ? -- prior_to_where -- SELECT receipt1_.id AS col__, coalesce(organizati16_.SHORT_NAME, organizati16_.FULL_NAME) AS col__, receipttyp17_.name AS col__, receipt1_.issue_dt AS col__, patient10_.id AS col__, individual11_.name AS col__, individual11_.surname AS col__, individual11_.patr_name AS col__, individual11_.birth_dt AS col__, fundingsou2_.name AS col__, receiptper3_.name AS col__, receipt1_.series AS col__, receipt1_.number AS col__, diagnosis4_.name AS col__, diagnosis4_.code AS col__, medicalroo6_1_.name AS col__, receipt1_.canceled AS col__, coalesce(organizati5_.SHORT_NAME, organizati5_.FULL_NAME) AS col__, individual9_.id AS col__, individual9_.name AS col__, individual9_.surname AS col__, individual9_.patr_name AS col__, receiptimp0_.id AS col__, receiptimp0_.begin_date AS col__, receiptimp0_.is_deferred AS col__, receiptimp0_.deferred_date AS col__, (SELECT md_receipt__get_medicines(receipt1_.id)) AS col__, benefittyp13_.name AS col__, benefitdef14_.name AS col__, receipttyp17_.code AS col__ FROM md_receipt_implementation_info receiptimp0_ RIGHT OUTER JOIN md_receipt receipt1_ ON receiptimp0_.receipt_id=receipt1_.id LEFT OUTER JOIN fin_funding_source_type fundingsou2_ ON receipt1_.funding_source_type_id=fundingsou2_.id LEFT OUTER JOIN md_receipt_percent_payment receiptper3_ ON receipt1_.percent_payment_id=receiptper3_.id LEFT OUTER JOIN md_diagnosis diagnosis4_ ON receipt1_.diagnosis_id=diagnosis4_.id LEFT OUTER JOIN pim_organization organizati5_ ON receipt1_.pharmacy_id=organizati5_.id LEFT OUTER JOIN pim_party organizati5_1_ ON organizati5_.id=organizati5_1_.id LEFT OUTER JOIN md_room medicalroo6_ ON receipt1_.room_id=medicalroo6_.id LEFT OUTER JOIN pim_room medicalroo6_1_ ON medicalroo6_.id=medicalroo6_1_.id LEFT OUTER JOIN pim_employee_position employeeto7_ ON receipt1_.employee_position_id=employeeto7_.id LEFT OUTER JOIN pim_employee employee8_ ON employeeto7_.employee_id=employee8_.id LEFT OUTER JOIN pim_individual individual9_ ON employee8_.individual_id=individual9_.id LEFT OUTER JOIN pim_party individual9_1_ ON individual9_.id=individual9_1_.id LEFT OUTER JOIN pci_patient patient10_ ON receipt1_.patient_id=patient10_.id LEFT OUTER JOIN pim_individual individual11_ ON patient10_.id=individual11_.id LEFT OUTER JOIN pim_party individual11_1_ ON individual11_.id=individual11_1_.id LEFT OUTER JOIN pci_benefit benefit12_ ON receipt1_.benefit_id=benefit12_.id LEFT OUTER JOIN pci_benefit_type benefittyp13_ ON benefit12_.benefit_type_id=benefittyp13_.id LEFT OUTER JOIN pci_benefit_definition benefitdef14_ ON benefit12_.benefit_def_id=benefitdef14_.id, md_clinic clinic15_, pim_organization organizati16_ INNER JOIN pim_party organizati16_1_ ON organizati16_.id=organizati16_1_.id, md_receipt_type receipttyp17_ -- where -- WHERE receipt1_.clinic_id=clinic15_.id AND clinic15_.id=organizati16_.id AND receipt1_.type_id=receipttyp17_.id AND (TRUE=TRUE AND (receipt1_.clinic_id NOT IN (?)) OR TRUE=TRUE AND (receipt1_.clinic_id IN (?)) OR TRUE=TRUE AND (receipt1_.clinic_id NOT IN (?))) -- excluding_where -- SELECT receipt1_.id AS col__, coalesce(organizati16_.SHORT_NAME, organizati16_.FULL_NAME) AS col__, receipttyp17_.name AS col__, receipt1_.issue_dt AS col__, patient10_.id AS col__, individual11_.name AS col__, individual11_.surname AS col__, individual11_.patr_name AS col__, individual11_.birth_dt AS col__, fundingsou2_.name AS col__, receiptper3_.name AS col__, receipt1_.series AS col__, receipt1_.number AS col__, diagnosis4_.name AS col__, diagnosis4_.code AS col__, medicalroo6_1_.name AS col__, receipt1_.canceled AS col__, coalesce(organizati5_.SHORT_NAME, organizati5_.FULL_NAME) AS col__, individual9_.id AS col__, individual9_.name AS col__, individual9_.surname AS col__, individual9_.patr_name AS col__, receiptimp0_.id AS col__, receiptimp0_.begin_date AS col__, receiptimp0_.is_deferred AS col__, receiptimp0_.deferred_date AS col__, (SELECT md_receipt__get_medicines(receipt1_.id)) AS col__, benefittyp13_.name AS col__, benefitdef14_.name AS col__, receipttyp17_.code AS col__ FROM md_receipt_implementation_info receiptimp0_ RIGHT OUTER JOIN md_receipt receipt1_ ON receiptimp0_.receipt_id=receipt1_.id LEFT OUTER JOIN fin_funding_source_type fundingsou2_ ON receipt1_.funding_source_type_id=fundingsou2_.id LEFT OUTER JOIN md_receipt_percent_payment receiptper3_ ON receipt1_.percent_payment_id=receiptper3_.id LEFT OUTER JOIN md_diagnosis diagnosis4_ ON receipt1_.diagnosis_id=diagnosis4_.id LEFT OUTER JOIN pim_organization organizati5_ ON receipt1_.pharmacy_id=organizati5_.id LEFT OUTER JOIN pim_party organizati5_1_ ON organizati5_.id=organizati5_1_.id LEFT OUTER JOIN md_room medicalroo6_ ON receipt1_.room_id=medicalroo6_.id LEFT OUTER JOIN pim_room medicalroo6_1_ ON medicalroo6_.id=medicalroo6_1_.id LEFT OUTER JOIN pim_employee_position employeeto7_ ON receipt1_.employee_position_id=employeeto7_.id LEFT OUTER JOIN pim_employee employee8_ ON employeeto7_.employee_id=employee8_.id LEFT OUTER JOIN pim_individual individual9_ ON employee8_.individual_id=individual9_.id LEFT OUTER JOIN pim_party individual9_1_ ON individual9_.id=individual9_1_.id LEFT OUTER JOIN pci_patient patient10_ ON receipt1_.patient_id=patient10_.id LEFT OUTER JOIN pim_individual individual11_ ON patient10_.id=individual11_.id LEFT OUTER JOIN pim_party individual11_1_ ON individual11_.id=individual11_1_.id LEFT OUTER JOIN pci_benefit benefit12_ ON receipt1_.benefit_id=benefit12_.id LEFT OUTER JOIN pci_benefit_type benefittyp13_ ON benefit12_.benefit_type_id=benefittyp13_.id LEFT OUTER JOIN pci_benefit_definition benefitdef14_ ON benefit12_.benefit_def_id=benefitdef14_.id, md_clinic clinic15_, pim_organization organizati16_ INNER JOIN pim_party organizati16_1_ ON organizati16_.id=organizati16_1_.id, md_receipt_type receipttyp17_ ORDER BY 4 DESC, receipt1_.id LIMIT ? -- including_where -- SELECT receipt1_.id AS col__, coalesce(organizati16_.SHORT_NAME, organizati16_.FULL_NAME) AS col__, receipttyp17_.name AS col__, receipt1_.issue_dt AS col__, patient10_.id AS col__, individual11_.name AS col__, individual11_.surname AS col__, individual11_.patr_name AS col__, individual11_.birth_dt AS col__, fundingsou2_.name AS col__, receiptper3_.name AS col__, receipt1_.series AS col__, receipt1_.number AS col__, diagnosis4_.name AS col__, diagnosis4_.code AS col__, medicalroo6_1_.name AS col__, receipt1_.canceled AS col__, coalesce(organizati5_.SHORT_NAME, organizati5_.FULL_NAME) AS col__, individual9_.id AS col__, individual9_.name AS col__, individual9_.surname AS col__, individual9_.patr_name AS col__, receiptimp0_.id AS col__, receiptimp0_.begin_date AS col__, receiptimp0_.is_deferred AS col__, receiptimp0_.deferred_date AS col__, (SELECT md_receipt__get_medicines(receipt1_.id)) AS col__, benefittyp13_.name AS col__, benefitdef14_.name AS col__, receipttyp17_.code AS col__ FROM md_receipt_implementation_info receiptimp0_ RIGHT OUTER JOIN md_receipt receipt1_ ON receiptimp0_.receipt_id=receipt1_.id LEFT OUTER JOIN fin_funding_source_type fundingsou2_ ON receipt1_.funding_source_type_id=fundingsou2_.id LEFT OUTER JOIN md_receipt_percent_payment receiptper3_ ON receipt1_.percent_payment_id=receiptper3_.id LEFT OUTER JOIN md_diagnosis diagnosis4_ ON receipt1_.diagnosis_id=diagnosis4_.id LEFT OUTER JOIN pim_organization organizati5_ ON receipt1_.pharmacy_id=organizati5_.id LEFT OUTER JOIN pim_party organizati5_1_ ON organizati5_.id=organizati5_1_.id LEFT OUTER JOIN md_room medicalroo6_ ON receipt1_.room_id=medicalroo6_.id LEFT OUTER JOIN pim_room medicalroo6_1_ ON medicalroo6_.id=medicalroo6_1_.id LEFT OUTER JOIN pim_employee_position employeeto7_ ON receipt1_.employee_position_id=employeeto7_.id LEFT OUTER JOIN pim_employee employee8_ ON employeeto7_.employee_id=employee8_.id LEFT OUTER JOIN pim_individual individual9_ ON employee8_.individual_id=individual9_.id LEFT OUTER JOIN pim_party individual9_1_ ON individual9_.id=individual9_1_.id LEFT OUTER JOIN pci_patient patient10_ ON receipt1_.patient_id=patient10_.id LEFT OUTER JOIN pim_individual individual11_ ON patient10_.id=individual11_.id LEFT OUTER JOIN pim_party individual11_1_ ON individual11_.id=individual11_1_.id LEFT OUTER JOIN pci_benefit benefit12_ ON receipt1_.benefit_id=benefit12_.id LEFT OUTER JOIN pci_benefit_type benefittyp13_ ON benefit12_.benefit_type_id=benefittyp13_.id LEFT OUTER JOIN pci_benefit_definition benefitdef14_ ON benefit12_.benefit_def_id=benefitdef14_.id, md_clinic clinic15_, pim_organization organizati16_ INNER JOIN pim_party organizati16_1_ ON organizati16_.id=organizati16_1_.id, md_receipt_type receipttyp17_ WHERE receipt1_.clinic_id=clinic15_.id AND clinic15_.id=organizati16_.id AND receipt1_.type_id=receipttyp17_.id AND (TRUE=TRUE AND (receipt1_.clinic_id NOT IN (?)) OR TRUE=TRUE AND (receipt1_.clinic_id IN (?)) OR TRUE=TRUE AND (receipt1_.clinic_id NOT IN (?)))