SELECTs0_.idASid_0,s0_.nameASname_1,s0_.name_translationsASname_translations_2,s0_.priceASprice_3,s0_.sale_priceASsale_price_4,s0_.in_menuASin_menu_5,s0_.deleted_atASdeleted_at_6,s0_.is_activeASis_active_7,s0_.created_atAScreated_at_8,s0_.updated_atASupdated_at_9,count(s0_.id) ASsclr_10,s0_.product_group_idASproduct_group_id_11,s0_.store_idASstore_id_12,s0_.currencyAScurrency_13FROMstore_products0_WHERE (s0_.store_id=?ANDs0_.product_group_id=?) AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.name_translationsASname_translations_2,s0_.priceASprice_3,s0_.sale_priceASsale_price_4,s0_.in_menuASin_menu_5,s0_.deleted_atASdeleted_at_6,s0_.is_activeASis_active_7,s0_.created_atAScreated_at_8,s0_.updated_atASupdated_at_9,count(s0_.id) ASsclr_10,s0_.product_group_idASproduct_group_id_11,s0_.store_idASstore_id_12,s0_.currencyAScurrency_13FROMstore_products0_WHERE
(
s0_.store_id=?ANDs0_.product_group_id=?
)
AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.name_translationsASname_translations_2,s0_.priceASprice_3,s0_.sale_priceASsale_price_4,s0_.in_menuASin_menu_5,s0_.deleted_atASdeleted_at_6,s0_.is_activeASis_active_7,s0_.created_atAScreated_at_8,s0_.updated_atASupdated_at_9,count(s0_.id) ASsclr_10,s0_.product_group_idASproduct_group_id_11,s0_.store_idASstore_id_12,s0_.currencyAScurrency_13FROMstore_products0_WHERE (s0_.store_id=6ANDs0_.product_group_id=2) AND (s0_.deleted_atISNULL);
SELECTDISTINCTs0_.table_idASsclr_0FROMstore_bill_tables0_INNER JOINstore_bills1_ONs0_.bill_id=s1_.idAND (s1_.deleted_atISNULL) WHERE (s1_.store_id=?ANDs1_.is_closed=?) AND (s0_.deleted_atISNULL)
SELECTDISTINCTs0_.table_idASsclr_0FROMstore_bill_tables0_INNER JOINstore_bills1_ONs0_.bill_id=s1_.idAND (s1_.deleted_atISNULL)
WHERE
(
s1_.store_id=?ANDs1_.is_closed=?
)
AND (s0_.deleted_atISNULL)
SELECTDISTINCTs0_.table_idASsclr_0FROMstore_bill_tables0_INNER JOINstore_bills1_ONs0_.bill_id=s1_.idAND (s1_.deleted_atISNULL) WHERE (s1_.store_id=6ANDs1_.is_closed=0) AND (s0_.deleted_atISNULL);
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.name_translationsASname_translations_2,s0_.image_file_nameASimage_file_name_3,s0_.deleted_atASdeleted_at_4,s0_.is_activeASis_active_5,s0_.created_atAScreated_at_6,s0_.updated_atASupdated_at_7,s0_.store_idASstore_id_8,s0_.income_department_idASincome_department_id_9,s0_.station_idASstation_id_10FROMstore_product_groups0_WHERE (s0_.store_id=?) AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.name_translationsASname_translations_2,s0_.image_file_nameASimage_file_name_3,s0_.deleted_atASdeleted_at_4,s0_.is_activeASis_active_5,s0_.created_atAScreated_at_6,s0_.updated_atASupdated_at_7,s0_.store_idASstore_id_8,s0_.income_department_idASincome_department_id_9,s0_.station_idASstation_id_10FROMstore_product_groups0_WHERE
(s0_.store_id=?)
AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.name_translationsASname_translations_2,s0_.image_file_nameASimage_file_name_3,s0_.deleted_atASdeleted_at_4,s0_.is_activeASis_active_5,s0_.created_atAScreated_at_6,s0_.updated_atASupdated_at_7,s0_.store_idASstore_id_8,s0_.income_department_idASincome_department_id_9,s0_.station_idASstation_id_10FROMstore_product_groups0_WHERE (s0_.store_id=6) AND (s0_.deleted_atISNULL);
SELECTs0_.idASid_0,s0_.table_numberAStable_number_1,s0_.max_capacityASmax_capacity_2,s0_.accepts_ordersASaccepts_orders_3,s0_.deleted_atASdeleted_at_4,s0_.is_activeASis_active_5,s0_.created_atAScreated_at_6,s0_.updated_atASupdated_at_7,s0_.store_idASstore_id_8,s0_.table_location_idAStable_location_id_9,s0_.shapeASshape_10FROMstore_tables0_WHERE (s0_.store_id=?ANDs0_.is_active=?) AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.table_numberAStable_number_1,s0_.max_capacityASmax_capacity_2,s0_.accepts_ordersASaccepts_orders_3,s0_.deleted_atASdeleted_at_4,s0_.is_activeASis_active_5,s0_.created_atAScreated_at_6,s0_.updated_atASupdated_at_7,s0_.store_idASstore_id_8,s0_.table_location_idAStable_location_id_9,s0_.shapeASshape_10FROMstore_tables0_WHERE
(
s0_.store_id=?ANDs0_.is_active=?
)
AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.table_numberAStable_number_1,s0_.max_capacityASmax_capacity_2,s0_.accepts_ordersASaccepts_orders_3,s0_.deleted_atASdeleted_at_4,s0_.is_activeASis_active_5,s0_.created_atAScreated_at_6,s0_.updated_atASupdated_at_7,s0_.store_idASstore_id_8,s0_.table_location_idAStable_location_id_9,s0_.shapeASshape_10FROMstore_tables0_WHERE (s0_.store_id=6ANDs0_.is_active=1) AND (s0_.deleted_atISNULL);
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.deleted_atASdeleted_at_2,s0_.is_activeASis_active_3,s0_.created_atAScreated_at_4,s0_.updated_atASupdated_at_5,s0_.store_idASstore_id_6FROMstore_table_locations0_WHERE (s0_.store_id=?) AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.deleted_atASdeleted_at_2,s0_.is_activeASis_active_3,s0_.created_atAScreated_at_4,s0_.updated_atASupdated_at_5,s0_.store_idASstore_id_6FROMstore_table_locations0_WHERE
(s0_.store_id=?)
AND (s0_.deleted_atISNULL)
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.deleted_atASdeleted_at_2,s0_.is_activeASis_active_3,s0_.created_atAScreated_at_4,s0_.updated_atASupdated_at_5,s0_.store_idASstore_id_6FROMstore_table_locations0_WHERE (s0_.store_id=6) AND (s0_.deleted_atISNULL);
SELECTt0.codeAScode_1,t0.nameASname_2,t0.display_nameASdisplay_name_3,t0.is_defaultASis_default_4,t0.deleted_atASdeleted_at_5,t0.is_activeASis_active_6,t0.created_atAScreated_at_7,t0.updated_atASupdated_at_8FROMsta_languaget0WHEREt0.is_active=?AND ((t0.deleted_atISNULL)) ORDER BYt0.codeASC
SELECTt0.codeAScode_1,t0.nameASname_2,t0.display_nameASdisplay_name_3,t0.is_defaultASis_default_4,t0.deleted_atASdeleted_at_5,t0.is_activeASis_active_6,t0.created_atAScreated_at_7,t0.updated_atASupdated_at_8FROMsta_languaget0WHEREt0.is_active=?AND (
(t0.deleted_atISNULL)
)
ORDER BYt0.codeASC
SELECTt0.codeAScode_1,t0.nameASname_2,t0.display_nameASdisplay_name_3,t0.is_defaultASis_default_4,t0.deleted_atASdeleted_at_5,t0.is_activeASis_active_6,t0.created_atAScreated_at_7,t0.updated_atASupdated_at_8FROMsta_languaget0WHEREt0.is_active=1AND ((t0.deleted_atISNULL)) ORDER BYt0.codeASC;