SELECTs0_.idASid_0,s0_.titleAStitle_1,s0_.text_1AStext_1_2,s0_.text_2AStext_2_3,s0_.picture_pageASpicture_page_4,s0_.picture_textASpicture_text_5,s0_.picture_presASpicture_pres_6,s0_.picture_pres_hoverASpicture_pres_hover_7,s0_.posASpos_8,s0_.tagAStag_9,s0_.updated_atASupdated_at_10FROMservicess0_INNER JOINsub_servicess1_ONs0_.id=s1_.service_idAND (s1_.service_id=s0_.idANDs1_.allowed_to_appointment=?ANDs1_.package=?) ORDER BYs0_.posASC
SELECTs0_.idASid_0,s0_.titleAStitle_1,s0_.text_1AStext_1_2,s0_.text_2AStext_2_3,s0_.picture_pageASpicture_page_4,s0_.picture_textASpicture_text_5,s0_.picture_presASpicture_pres_6,s0_.picture_pres_hoverASpicture_pres_hover_7,s0_.posASpos_8,s0_.tagAStag_9,s0_.updated_atASupdated_at_10FROMservicess0_INNER JOINsub_servicess1_ONs0_.id=s1_.service_idAND (
s1_.service_id=s0_.idANDs1_.allowed_to_appointment=?ANDs1_.package=?
)
ORDER BYs0_.posASC
SELECTs0_.idASid_0,s0_.titleAStitle_1,s0_.text_1AStext_1_2,s0_.text_2AStext_2_3,s0_.picture_pageASpicture_page_4,s0_.picture_textASpicture_text_5,s0_.picture_presASpicture_pres_6,s0_.picture_pres_hoverASpicture_pres_hover_7,s0_.posASpos_8,s0_.tagAStag_9,s0_.updated_atASupdated_at_10FROMservicess0_INNER JOINsub_servicess1_ONs0_.id=s1_.service_idAND (s1_.service_id=s0_.idANDs1_.allowed_to_appointment=1ANDs1_.package=0) ORDER BYs0_.posASC;