Symfony Profiler

SELECT
  i0_.init_company_id AS init_company_id_0,
  i0_.init_company_follow_id AS init_company_follow_id_1,
  i0_.init_company_no AS init_company_no_2,
  i0_.init_company_name AS init_company_name_3,
  i0_.init_company_address AS init_company_address_4,
  i0_.init_company_local AS init_company_local_5,
  i0_.init_company_city AS init_company_city_6,
  i0_.init_company_province AS init_company_province_7,
  i0_.init_company_postalcode AS init_company_postalcode_8,
  i0_.init_company_region AS init_company_region_9,
  i0_.init_company_country AS init_company_country_10,
  i0_.init_company_phone AS init_company_phone_11,
  i0_.init_company_email AS init_company_email_12,
  i0_.init_company_email_commercial AS init_company_email_commercial_13,
  i0_.init_company_email_accounting AS init_company_email_accounting_14,
  i0_.init_company_logo AS init_company_logo_15,
  i0_.init_company_qrcode_logo AS init_company_qrcode_logo_16,
  i0_.init_company_add_by AS init_company_add_by_17,
  i0_.init_company_update_by AS init_company_update_by_18,
  i0_.init_company_enabled AS init_company_enabled_19,
  i0_.init_company_date_add AS init_company_date_add_20,
  i0_.init_company_date_update AS init_company_date_update_21
FROM
  init_company i0_
WHERE
  i0_.init_company_no = ?

SELECT i0_.init_company_id AS init_company_id_0, i0_.init_company_follow_id AS init_company_follow_id_1, i0_.init_company_no AS init_company_no_2, i0_.init_company_name AS init_company_name_3, i0_.init_company_address AS init_company_address_4, i0_.init_company_local AS init_company_local_5, i0_.init_company_city AS init_company_city_6, i0_.init_company_province AS init_company_province_7, i0_.init_company_postalcode AS init_company_postalcode_8, i0_.init_company_region AS init_company_region_9, i0_.init_company_country AS init_company_country_10, i0_.init_company_phone AS init_company_phone_11, i0_.init_company_email AS init_company_email_12, i0_.init_company_email_commercial AS init_company_email_commercial_13, i0_.init_company_email_accounting AS init_company_email_accounting_14, i0_.init_company_logo AS init_company_logo_15, i0_.init_company_qrcode_logo AS init_company_qrcode_logo_16, i0_.init_company_add_by AS init_company_add_by_17, i0_.init_company_update_by AS init_company_update_by_18, i0_.init_company_enabled AS init_company_enabled_19, i0_.init_company_date_add AS init_company_date_add_20, i0_.init_company_date_update AS init_company_date_update_21 FROM init_company i0_ WHERE i0_.init_company_no = '29717632';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'PAYMENT_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'PAYMENT_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'PAYMENT_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'PAYMENT_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'PAYMENT_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'PAYMENT_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'LANGUAGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'LANGUAGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'LANGUAGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'BOOKING_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'BOOKING_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'BOOKING_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'BOOKING_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'BOOKING_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'BOOKING_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'CHILD_AGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'CHILD_AGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'CHILD_AGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'CHILD_AGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'CHILD_AGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'CHILD_AGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTEL'
  AND lcKeyName = 'DAY_PLATEFORMS_START'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTEL' AND lcKeyName = 'DAY_PLATEFORMS_START';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTEL'
  AND lcKeyName = 'REPORTS_QUANTITY_MONTHS_AFTER_CURRENT_MONTH'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTEL' AND lcKeyName = 'REPORTS_QUANTITY_MONTHS_AFTER_CURRENT_MONTH';

SELECT
  m0_.hotel_channel_number AS hotel_channel_number_0,
  m0_.hotel_channel_follow_id AS hotel_channel_follow_id_1,
  m0_.hotel_channel_name AS hotel_channel_name_2
FROM
  modulo_hotel_channels m0_

SELECT m0_.hotel_channel_number AS hotel_channel_number_0, m0_.hotel_channel_follow_id AS hotel_channel_follow_id_1, m0_.hotel_channel_name AS hotel_channel_name_2 FROM modulo_hotel_channels m0_;

SELECT
  m0_.hotel_channel_number AS hotel_channel_number_0,
  m0_.hotel_channel_follow_id AS hotel_channel_follow_id_1,
  m0_.hotel_channel_name AS hotel_channel_name_2,
  m0_.hotel_channel_color AS hotel_channel_color_3,
  m0_.hotel_channel_background_color AS hotel_channel_background_color_4,
  m0_.hotel_channel_border_color AS hotel_channel_border_color_5
FROM
  modulo_hotel_channels m0_

SELECT m0_.hotel_channel_number AS hotel_channel_number_0, m0_.hotel_channel_follow_id AS hotel_channel_follow_id_1, m0_.hotel_channel_name AS hotel_channel_name_2, m0_.hotel_channel_color AS hotel_channel_color_3, m0_.hotel_channel_background_color AS hotel_channel_background_color_4, m0_.hotel_channel_border_color AS hotel_channel_border_color_5 FROM modulo_hotel_channels m0_;

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_EXPEDIA'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_EXPEDIA';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_BOOKING'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_BOOKING';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CASH'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CASH';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CREDIT_CARD'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CREDIT_CARD';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_PROMOTION'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_PROMOTION';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_COLLECT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_COLLECT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'CHANNELS_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'CHANNELS_TYPES';

SELECT
  m0_.hotel_rooms_type_number AS hotel_rooms_type_number_0,
  m0_.hotel_rooms_type_follow_id AS hotel_rooms_type_follow_id_1,
  m0_.hotel_rooms_type_name AS hotel_rooms_type_name_2
FROM
  modulo_hotel_rooms_types m0_

SELECT m0_.hotel_rooms_type_number AS hotel_rooms_type_number_0, m0_.hotel_rooms_type_follow_id AS hotel_rooms_type_follow_id_1, m0_.hotel_rooms_type_name AS hotel_rooms_type_name_2 FROM modulo_hotel_rooms_types m0_;

SELECT
  m0_.hotel_rooms_type_number AS hotel_rooms_type_number_0,
  m0_.hotel_rooms_type_follow_id AS hotel_rooms_type_follow_id_1,
  m0_.hotel_rooms_type_name AS hotel_rooms_type_name_2,
  m0_.hotel_rooms_type_color AS hotel_rooms_type_color_3,
  m0_.hotel_rooms_type_background_color AS hotel_rooms_type_background_color_4,
  m0_.hotel_rooms_type_border_color AS hotel_rooms_type_border_color_5,
  m0_.hotel_rooms_type_alternative_room_if_room_occupied AS hotel_rooms_type_alternative_room_if_room_occupied_6,
  m0_.hotel_rooms_type_maximum_bookings_to_consider_alert AS hotel_rooms_type_maximum_bookings_to_consider_alert_7,
  m0_.hotel_rooms_type_maximum_bookings_to_consider_critical AS hotel_rooms_type_maximum_bookings_to_consider_critical_8
FROM
  modulo_hotel_rooms_types m0_

SELECT m0_.hotel_rooms_type_number AS hotel_rooms_type_number_0, m0_.hotel_rooms_type_follow_id AS hotel_rooms_type_follow_id_1, m0_.hotel_rooms_type_name AS hotel_rooms_type_name_2, m0_.hotel_rooms_type_color AS hotel_rooms_type_color_3, m0_.hotel_rooms_type_background_color AS hotel_rooms_type_background_color_4, m0_.hotel_rooms_type_border_color AS hotel_rooms_type_border_color_5, m0_.hotel_rooms_type_alternative_room_if_room_occupied AS hotel_rooms_type_alternative_room_if_room_occupied_6, m0_.hotel_rooms_type_maximum_bookings_to_consider_alert AS hotel_rooms_type_maximum_bookings_to_consider_alert_7, m0_.hotel_rooms_type_maximum_bookings_to_consider_critical AS hotel_rooms_type_maximum_bookings_to_consider_critical_8 FROM modulo_hotel_rooms_types m0_;

SELECT
  m0_.hotel_room_number AS hotel_room_number_0,
  m0_.hotel_room_follow_id AS hotel_room_follow_id_1,
  m0_.hotel_room_name AS hotel_room_name_2
FROM
  modulo_hotel_rooms m0_

SELECT m0_.hotel_room_number AS hotel_room_number_0, m0_.hotel_room_follow_id AS hotel_room_follow_id_1, m0_.hotel_room_name AS hotel_room_name_2 FROM modulo_hotel_rooms m0_;

SELECT
  m0_.hotel_room_number AS hotel_room_number_0,
  m0_.hotel_room_follow_id AS hotel_room_follow_id_1,
  m0_.hotel_room_name AS hotel_room_name_2,
  m0_.hotel_room_door_number AS hotel_room_door_number_3,
  m0_.hotel_room_color AS hotel_room_color_4,
  m0_.hotel_room_background_color AS hotel_room_background_color_5,
  m0_.hotel_room_border_color AS hotel_room_border_color_6,
  m0_.hotel_room_alternative_room_if_room_occupied AS hotel_room_alternative_room_if_room_occupied_7,
  m0_.hotel_room_maximum_bookings_to_consider_alert AS hotel_room_maximum_bookings_to_consider_alert_8,
  m0_.hotel_room_maximum_bookings_to_consider_critical AS hotel_room_maximum_bookings_to_consider_critical_9
FROM
  modulo_hotel_rooms m0_

SELECT m0_.hotel_room_number AS hotel_room_number_0, m0_.hotel_room_follow_id AS hotel_room_follow_id_1, m0_.hotel_room_name AS hotel_room_name_2, m0_.hotel_room_door_number AS hotel_room_door_number_3, m0_.hotel_room_color AS hotel_room_color_4, m0_.hotel_room_background_color AS hotel_room_background_color_5, m0_.hotel_room_border_color AS hotel_room_border_color_6, m0_.hotel_room_alternative_room_if_room_occupied AS hotel_room_alternative_room_if_room_occupied_7, m0_.hotel_room_maximum_bookings_to_consider_alert AS hotel_room_maximum_bookings_to_consider_alert_8, m0_.hotel_room_maximum_bookings_to_consider_critical AS hotel_room_maximum_bookings_to_consider_critical_9 FROM modulo_hotel_rooms m0_;

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'PAYMENT_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'PAYMENT_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'LANGUAGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'BOOKING_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'BOOKING_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'CHILD_AGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'CHILD_AGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'GUEST_GENDER'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'GUEST_GENDER';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'MEDIA_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MEDIA_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'MINIMUM_DAYS_BOOKING_COUNTS_IN_OVERBOOKING'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MINIMUM_DAYS_BOOKING_COUNTS_IN_OVERBOOKING';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'MEDIA_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MEDIA_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'MODULOEMAILTEMPLATE'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'MODULOEMAILTEMPLATE' AND lcKeyName = 'LANGUAGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'MODULOEMAILTEMPLATE'
  AND lcKeyName = 'EMAIL_TEMPLATE_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'MODULOEMAILTEMPLATE' AND lcKeyName = 'EMAIL_TEMPLATE_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'ACCOUNTSMOVEMENTS_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'ACCOUNTSMOVEMENTS_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_AMOUNT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_AMOUNT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_DATE'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_DATE';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_CASH_AMOUNT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_CASH_AMOUNT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_CASH_DATE'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_CASH_DATE';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'ACCOUNTSMOVEMENTS_ACCOUNTS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'ACCOUNTSMOVEMENTS_ACCOUNTS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_CASH_AMOUNT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_CASH_AMOUNT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_CASH_DATE'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_CASH_DATE';

SELECT
  m0_.device_id AS device_id_0,
  m0_.device_follow_id AS device_follow_id_1,
  m0_.device_no AS device_no_2,
  m0_.device_number AS device_number_3,
  m0_.user_id AS user_id_4,
  m0_.device_name AS device_name_5,
  m0_.device_reference AS device_reference_6,
  m0_.device_remarks AS device_remarks_7,
  m0_.device_enabled AS device_enabled_8,
  m0_.device_date_add AS device_date_add_9,
  m0_.device_add_by AS device_add_by_10,
  m0_.device_date_update AS device_date_update_11,
  m0_.device_update_by AS device_update_by_12,
  m0_.device_ip AS device_ip_13,
  m0_.device_md5 AS device_md5_14,
  m0_.device_useragent AS device_useragent_15,
  m0_.device_useragentname AS device_useragentname_16,
  m0_.device_version AS device_version_17,
  m0_.device_platform AS device_platform_18,
  m0_.device_pattern AS device_pattern_19,
  u1_.id AS id_20,
  u1_.user_follow_id AS user_follow_id_21,
  u1_.user_no AS user_no_22,
  u1_.email AS email_23,
  u1_.roles AS roles_24,
  u1_.password AS password_25,
  u1_.enabled AS enabled_26,
  u1_.confirmation_token AS confirmation_token_27,
  u1_.firstname AS firstname_28,
  u1_.lastname AS lastname_29,
  u1_.mobile AS mobile_30,
  u1_.position AS position_31,
  u1_.location AS location_32,
  u1_.picture AS picture_33,
  u1_.personal_information AS personal_information_34,
  u1_.remarks AS remarks_35,
  u1_.last_login_at AS last_login_at_36,
  u1_.created_at AS created_at_37,
  u1_.updated_at AS updated_at_38,
  u1_.user_add_by AS user_add_by_39,
  u1_.user_update_by AS user_update_by_40
FROM
  modulo_devices m0_
  LEFT JOIN user u1_ ON (u1_.id = m0_.user_id)
WHERE
  m0_.device_md5 = ?
GROUP BY
  m0_.device_id

SELECT m0_.device_id AS device_id_0, m0_.device_follow_id AS device_follow_id_1, m0_.device_no AS device_no_2, m0_.device_number AS device_number_3, m0_.user_id AS user_id_4, m0_.device_name AS device_name_5, m0_.device_reference AS device_reference_6, m0_.device_remarks AS device_remarks_7, m0_.device_enabled AS device_enabled_8, m0_.device_date_add AS device_date_add_9, m0_.device_add_by AS device_add_by_10, m0_.device_date_update AS device_date_update_11, m0_.device_update_by AS device_update_by_12, m0_.device_ip AS device_ip_13, m0_.device_md5 AS device_md5_14, m0_.device_useragent AS device_useragent_15, m0_.device_useragentname AS device_useragentname_16, m0_.device_version AS device_version_17, m0_.device_platform AS device_platform_18, m0_.device_pattern AS device_pattern_19, u1_.id AS id_20, u1_.user_follow_id AS user_follow_id_21, u1_.user_no AS user_no_22, u1_.email AS email_23, u1_.roles AS roles_24, u1_.password AS password_25, u1_.enabled AS enabled_26, u1_.confirmation_token AS confirmation_token_27, u1_.firstname AS firstname_28, u1_.lastname AS lastname_29, u1_.mobile AS mobile_30, u1_.position AS position_31, u1_.location AS location_32, u1_.picture AS picture_33, u1_.personal_information AS personal_information_34, u1_.remarks AS remarks_35, u1_.last_login_at AS last_login_at_36, u1_.created_at AS created_at_37, u1_.updated_at AS updated_at_38, u1_.user_add_by AS user_add_by_39, u1_.user_update_by AS user_update_by_40 FROM modulo_devices m0_ LEFT JOIN user u1_ ON (u1_.id = m0_.user_id) WHERE m0_.device_md5 = '009fbce9714476ddaf598e4ad205c3ce' GROUP BY m0_.device_id;