select id from languages where prefix='es' limit 1

select json_config, messageatstartup_ar, start_date,end_date,messageatstartup,time_zone from application where appid = 6081

select cp.type, cw.*
from cms_widget as cw
join cms_page as cp on cw.cms_page_id=cp.id
where cp.campaign_id=6081 and cw.language_id='5' and cw.is_active=1 and (cp.type='public page header' or cp.type='public page footer' or cp.type='home page scripts' or cp.type='homepage head tag' or cp.type='registration page top' or cp.type='registration page bottom')
order by cw.sequence asc

select cw.`name`,cp.slug,cp.meta_data, cw.content,cp.is_login_required as loginrequired from cms_widget as cw
join cms_page as cp on cw.cms_page_id=cp.id
where cp.campaign_id=6081 and cw.language_id='5' and cp.is_home=0 and cw.is_active=1 and cp.slug='registration';

select *
from (`form`)
where `type` =  'registration_form'
and `app_id` =  6081

select id from languages where prefix='es' limit 1

select json_config, messageatstartup_ar, start_date,end_date,messageatstartup,time_zone from application where appid = 6081

select cp.type, cw.*
from cms_widget as cw
join cms_page as cp on cw.cms_page_id=cp.id
where cp.campaign_id=6081 and cw.language_id='5' and cw.is_active=1 and (cp.type='public page header' or cp.type='public page footer' or cp.type='home page scripts' or cp.type='homepage head tag' or cp.type='registration page top' or cp.type='registration page bottom')
order by cw.sequence asc

select cw.`name`,cp.slug,cp.meta_data, cw.content,cp.is_login_required as loginrequired from cms_widget as cw
join cms_page as cp on cw.cms_page_id=cp.id
where cp.campaign_id=6081 and cw.language_id='5' and cp.is_home=0 and cw.is_active=1 and cp.slug='registration';

select `t`.*
from (`translation` t)
join `languages` l on `l`.`id` = `t`.`lang`
where `t`.`app_id` =  6081
and `t`.`type` =  'static'
and `l`.`prefix` =  'es'

select *
from (`form`)
where `id` =  '50044'
and `app_id` =  6081

select *
from (`form_field`)
where `form_id` =  '50044'
order by `sequence` asc

select *
from (`package`)
where `user_type` in (1, 5) 
and `app_id` =  '6081'
and `is_active` =  '1'
order by `sequence`

select *
from (`discount_code`)
where `package_id` =  '773163'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773164'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773165'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773213'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773214'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773222'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773224'
and `is_active` =  1

select *
from (`discount_code`)
where `package_id` =  '773370'
and `is_active` =  1

select *
from (`payment_methods`)
where `name` =  'stripe'
and `type` =  'stripe'

select *
from (`payment_method_details`)
where `payment_method_id` =  '1'
and `app_id` =  6081

select *
from (`payment_methods`)
where `name` =  'stripe connect'
and `type` =  'stripe connect'

select *
from (`payment_method_details`)
where `payment_method_id` =  '13'
and `app_id` =  6081

select *
from (`utm_referral_code`)
where `app_id` =  6081
and `status` =  1

select `id`, `package_ids`
from (`seating_plan_templates`)
where `app_id` =  6081
and `status` =  1
and `enable_for_attendee_registration` =  0
and `enable_for_group_registration` =  1
and `template_json_published` is not null
order by `id` asc

select * from payment_method_details where app_id=6081 and payment_method_id=1 limit 1;

select *
from (`form_field`)
where `form_id` =  '50044'
and `field_type` =  'page-break'
order by `sequence`

select *
from (`application`)
where `appid` =  6081

select `organization_id`
from (`organization_events`)
where `app_id` =  '6081'

select `payment_methods`.`id` as paymentmethodid, `payment_method_details`.`id` as paymentdtlid, `payment_methods`.`name`, `payment_methods`.`type`, `payment_method_details`.`currency`, `payment_method_details`.`currency_symbol`, `payment_method_details`.`bussines_email`, `payment_method_details`.`public_key`, `payment_method_details`.`is_sandbox`, `payment_method_details`.`payment_image`, `payment_method_details`.`hold_on_card`, `payment_method_details`.`booking_fee`, `payment_method_details`.`stripe_element`
from (`payment_method_details`)
left join `payment_methods` on `payment_methods`.`id` = `payment_method_details`.`payment_method_id`
where `app_id` =  '6081'

select *
from (`package`)
where `app_id` =  6081

select `payment_methods`.`id` as paymentmethodid, `payment_method_details`.`id` as paymentdtlid, `payment_methods`.`name`, `payment_methods`.`type`, `payment_method_details`.`currency`, `payment_method_details`.`currency_symbol`, `payment_method_details`.`bussines_email`, `payment_method_details`.`public_key`, `payment_method_details`.`is_sandbox`, `payment_method_details`.`payment_image`, `payment_method_details`.`hold_on_card`, `payment_method_details`.`booking_fee`, `payment_method_details`.`stripe_element`
from (`payment_method_details`)
left join `payment_methods` on `payment_methods`.`id` = `payment_method_details`.`payment_method_id`
where `app_id` =  6081

select `variable_payment`.`id`, `variable_payment`.`name`, `variable_payment`.`limitation`, `variable_payment`.`avail_count`, `variable_payment`.`show_description`, `variable_payment`.`price`, `variable_payment`.`description`, `variable_payment`.`translations`, `package_variable_payment`.`package_id`, `variable_payment`.`purchase_limit_type`, `variable_payment`.`max_addons_per_ticket`, `variable_payment`.`max_addons_overall`, `variable_payment`.`apply_discount`
from (`variable_payment`)
left join `package_variable_payment` on `package_variable_payment`.`variable_payment_id` = `variable_payment`.`id`
left join `webinar` on `webinar`.`id` = `variable_payment`.`webinar_id`
where `variable_payment`.`app_id` =  6081
and `variable_payment`.`avail_count` < variable_payment.limitation
and `variable_payment`.`is_active` =  '1'
order by `variable_payment`.`sequence`

select group_concat(distinct webinar.title) as title
from (`variable_payment`)
left join `webinar_variable_payment` on `webinar_variable_payment`.`variable_payment_id` = `variable_payment`.`id`
left join `webinar` on `webinar`.`id` = `webinar_variable_payment`.`webinar_id`
where `variable_payment`.`app_id` =  6081
and `webinar_variable_payment`.`variable_payment_id` =  '2727'
group by `variable_payment`.`id`

select group_concat(distinct webinar.title) as title
from (`variable_payment`)
left join `webinar_variable_payment` on `webinar_variable_payment`.`variable_payment_id` = `variable_payment`.`id`
left join `webinar` on `webinar`.`id` = `webinar_variable_payment`.`webinar_id`
where `variable_payment`.`app_id` =  6081
and `webinar_variable_payment`.`variable_payment_id` =  '2728'
group by `variable_payment`.`id`

select `payment_methods`.`id` as paymentmethodid, `payment_method_details`.`id` as paymentdtlid, `payment_methods`.`name`, `payment_methods`.`type`, `payment_method_details`.`currency`, `payment_method_details`.`currency_symbol`, `payment_method_details`.`bussines_email`, `payment_method_details`.`public_key`, `payment_method_details`.`is_sandbox`, `payment_method_details`.`payment_image`, `payment_method_details`.`hold_on_card`, `payment_method_details`.`booking_fee`, `payment_method_details`.`stripe_element`
from (`payment_method_details`)
left join `payment_methods` on `payment_methods`.`id` = `payment_method_details`.`payment_method_id`
where `app_id` =  6081

select customer_profile_id as id,email from authorize_net_profiles where app_id=6081