select id from languages where prefix='en' 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='1' 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='1' and cp.is_home=0 and cw.is_active=1 and cp.slug=0;

select * from short_code where app_id=6081 and is_active=1;

select * from cms_widget as w
join cms_page as p on w.cms_page_id=p.id and p.campaign_id=6081
where w.language_id='1' and is_home=1 and w.is_active=1 order by w.sequence asc;