Examples:
- Code: Select all
SELECT sintpro_mods.sintpro_core_settings.default_mac_css, sintpro_mods.sintpro_core_settings.default_win_css, sintpro_mods.sintpro_core_settings.default_web_css FROM sintpro_mods.sintpro_core_settings ORDER BY sintpro_mods.sintpro_core_settings.sintpro_core_setting_id ASC -- CSS override
SELECT sintpro_mods.sintpro_users.sintpro_user_id, sintpro_mods.sintpro_users.flag_enabled, sintpro_mods.sintpro_groups.sintpro_group_id, sintpro_mods.sintpro_groups.flag_enabled, sintpro_mods.sintpro_groups.table_filters_switch, sintpro_mods.sintpro_databases.db_connection, sintpro_mods.sintpro_databases.database_name, sintpro_mods.sintpro_groups.id_ext_group, sintpro_mods.sintpro_databases.schema_name FROM sintpro_mods.sintpro_users INNER JOIN sintpro_mods.sintpro_groups ON sintpro_mods.sintpro_users.id_group = sintpro_mods.sintpro_groups.sintpro_group_id INNER JOIN sintpro_mods.sintpro_databases ON sintpro_mods.sintpro_groups.tenant_id = sintpro_mods.sintpro_databases.sintpro_database_id WHERE sintpro_mods.sintpro_users.sintpro_user_id = ? -- Framework init