Database

SELECT * FROM `cwh_config_contents` WHERE `cwh_config_contents`.`deleted_at` IS NULL

SELECT `data` FROM `session` WHERE `expire`>1775229128 AND `id`='bua56h84oniom5eadrj8ikul5m'

SELECT COUNT(*) FROM `translation_conf` WHERE (`translation_conf`.`deleted_at` IS NULL) AND (`model_generated`=0)

SELECT * FROM `sim_comprensorio` WHERE (`sim_comprensorio`.`deleted_at` IS NULL) AND (`id`='41')

SELECT * FROM `sim_stazione` WHERE `comprensorio_id`='41'

SHOW FULL COLUMNS FROM `sim_stazione`

SHOW CREATE TABLE `sim_stazione`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_stazione' AND `kcu`.`TABLE_NAME` = 'sim_stazione'

SELECT `sim_piste_anagrafica`.`id` FROM `sim_piste_anagrafica` LEFT JOIN `sim_piste_punti` ON sim_piste_anagrafica.id = sim_piste_punti.id_pista WHERE (`sim_piste_anagrafica`.`stazione_id`=48) AND (`sim_piste_punti`.`id_pista` IS NULL)

SHOW FULL COLUMNS FROM `sim_piste_anagrafica`

SHOW CREATE TABLE `sim_piste_anagrafica`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_piste_anagrafica' AND `kcu`.`TABLE_NAME` = 'sim_piste_anagrafica'

SHOW FULL COLUMNS FROM `sim_stazione_multimedia`

SHOW CREATE TABLE `sim_stazione_multimedia`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_stazione_multimedia' AND `kcu`.`TABLE_NAME` = 'sim_stazione_multimedia'

SELECT * FROM `sim_stazione_multimedia` WHERE (`sim_stazione_multimedia`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SHOW FULL COLUMNS FROM `sim_stazione_video`

SHOW CREATE TABLE `sim_stazione_video`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_stazione_video' AND `kcu`.`TABLE_NAME` = 'sim_stazione_video'

SELECT * FROM `sim_stazione_video` WHERE (`sim_stazione_video`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SHOW FULL COLUMNS FROM `sim_stazione_webcam`

SHOW CREATE TABLE `sim_stazione_webcam`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_stazione_webcam' AND `kcu`.`TABLE_NAME` = 'sim_stazione_webcam'

SELECT * FROM `sim_stazione_webcam` WHERE (`sim_stazione_webcam`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SHOW FULL COLUMNS FROM `sim_stazione_noleggio`

SHOW CREATE TABLE `sim_stazione_noleggio`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_stazione_noleggio' AND `kcu`.`TABLE_NAME` = 'sim_stazione_noleggio'

SELECT * FROM `sim_stazione_noleggio` WHERE (`sim_stazione_noleggio`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SHOW FULL COLUMNS FROM `sim_impianti_risalita_anagrafica`

SHOW CREATE TABLE `sim_impianti_risalita_anagrafica`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_impianti_risalita_anagrafica' AND `kcu`.`TABLE_NAME` = 'sim_impianti_risalita_anagrafica'

SELECT COUNT(*) FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SELECT * FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SELECT * FROM `language_source` WHERE (`category`='amoscore') AND (`message`='Sim Comprensorio')

SELECT * FROM `sim_comprensorio` WHERE (`sim_comprensorio`.`deleted_at` IS NULL) AND (`id`=41)

SELECT * FROM `sim_stazione` WHERE (`comprensorio_id`=41) AND (`sim_stazione`.`deleted_at` IS NULL)

SELECT * FROM `sim_piste_anagrafica` WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`stazione_id`=48) AND (`sim_piste_anagrafica`.`deleted_at` IS NULL)

SHOW FULL COLUMNS FROM `sim_piste_punti`

SHOW CREATE TABLE `sim_piste_punti`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_piste_punti' AND `kcu`.`TABLE_NAME` = 'sim_piste_punti'

SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=135) ORDER BY `ordine_punti`

SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=137) ORDER BY `ordine_punti`

SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=140) ORDER BY `ordine_punti`

SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=141) ORDER BY `ordine_punti`

SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=142) ORDER BY `ordine_punti`

SELECT * FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SHOW FULL COLUMNS FROM `sim_impianti_risalita_punti`

SHOW CREATE TABLE `sim_impianti_risalita_punti`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_impianti_risalita_punti' AND `kcu`.`TABLE_NAME` = 'sim_impianti_risalita_punti'

SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=47) ORDER BY `ordine_punti`

SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=48) ORDER BY `ordine_punti`

SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=49) ORDER BY `ordine_punti`

SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=50) ORDER BY `ordine_punti`

SHOW FULL COLUMNS FROM `sim_scuola_scii`

SHOW CREATE TABLE `sim_scuola_scii`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sim_scuola_scii' AND `kcu`.`TABLE_NAME` = 'sim_scuola_scii'

SELECT * FROM `sim_scuola_scii` WHERE (`sim_scuola_scii`.`deleted_at` IS NULL) AND (`stazione_id`=48)

SELECT * FROM `language_source` WHERE (`category`='amoscore') AND (`message`='Piste da sci')

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `language_source` `t1`, `language_translate` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='operations') AND (`t2`.`language`='it-IT')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `language_source` `t1`, `language_translate` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='operations') AND (`t2`.`language`='it')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `language_translate` WHERE `language`='it-IT')) )

SELECT COUNT(*) FROM `sim_piste_anagrafica` INNER JOIN `sim_stazione` ON sim_stazione.id = sim_piste_anagrafica.stazione_id AND sim_stazione.deleted_at IS NULL INNER JOIN `sim_comprensorio` ON sim_comprensorio.id = sim_stazione.comprensorio_id and sim_comprensorio.deleted_at IS NULL WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`sim_comprensorio`.`id`='41')

SELECT `sim_piste_anagrafica`.* FROM `sim_piste_anagrafica` INNER JOIN `sim_stazione` ON sim_stazione.id = sim_piste_anagrafica.stazione_id AND sim_stazione.deleted_at IS NULL INNER JOIN `sim_comprensorio` ON sim_comprensorio.id = sim_stazione.comprensorio_id and sim_comprensorio.deleted_at IS NULL WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`sim_comprensorio`.`id`='41') LIMIT 18

SELECT * FROM `sim_stazione` WHERE `id`=48

SELECT * FROM `sim_stazione` WHERE `id`=48

SELECT * FROM `sim_stazione` WHERE `id`=48

SELECT * FROM `sim_stazione` WHERE `id`=48

SELECT * FROM `sim_stazione` WHERE `id`=48

SELECT id FROM admin_lang where is_default=1

SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='myopen') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index`

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='USERPROFILE_UPDATE')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='AMMINISTRATORE_NEWS')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='ATTACH_DATABANK_FILE_ADMINISTRATOR')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='ATTACH_GALLERY_ADMINISTRATOR')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='BASIC_USER')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='CAPOREDATTORECMS')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='CMS_PAGE_EDITOR')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTIDESTINATARI_ADMIN')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTIFINALITA_ADMIN')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTISERVIZI_ADMIN')

SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTISOLUZIONI_ADMIN')

SELECT id FROM admin_lang where is_default=1

SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='default') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index`

SELECT * FROM `admin_lang` WHERE (`admin_lang`.`is_deleted`=FALSE) AND (`short_code`='it')

SELECT * FROM `slideshow_route` WHERE (`slideshow_route`.`deleted_at` IS NULL) AND (`route`='/mountain_sports/sim-comprensorio/view') AND (`role`='TUTTI')

SELECT * FROM `language_source` WHERE (`category`='amosapp') AND (`message`='Mountain_sports')

SELECT * FROM `language_source` WHERE (`category`='amosapp') AND (`message`='mountain_sports')

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `language_source` `t1`, `language_translate` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='ski_truks') AND (`t2`.`language`='it-IT')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `language_source` `t1`, `language_translate` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='ski_truks') AND (`t2`.`language`='it')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `language_translate` WHERE `language`='it-IT')) )

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `language_source` `t1`, `language_translate` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='sim_comprensorio') AND (`t2`.`language`='it-IT')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `language_source` `t1`, `language_translate` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='sim_comprensorio') AND (`t2`.`language`='it')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `language_translate` WHERE `language`='it-IT')) )

SELECT id FROM admin_lang where is_default=1

SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='default') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index`

SELECT id FROM admin_lang where is_default=1

SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='footer') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index`

SELECT * FROM `admin_lang` WHERE (`admin_lang`.`is_deleted`=FALSE) AND (`short_code`='it')

SELECT * FROM `cms_nav_container` WHERE (`cms_nav_container`.`is_deleted`=FALSE) AND (`alias`='footercms')

INSERT INTO `session` (`data`, `id`, `expire`) VALUES ('__flash|a:0:{}isMobile|b:1;krajeeTreeConfigSalt|s:32:\"�D�B
6�hZ�Xrǽ���j��Gm�e�;s|\";', 'bua56h84oniom5eadrj8ikul5m', 1775232729) ON DUPLICATE KEY UPDATE `data`=VALUES(`data`), `expire`=VALUES(`expire`)