| 1 |
0.18 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.general AS general_3 FROM Sidebar t0 WHERE t0.general = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.general AS general_3 FROM Sidebar t0 WHERE t0.general = 1;
|
| 2 |
0.32 ms |
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0
SELECT
t0.gen_id AS gen_id_1,
t0.gen_masella_cm AS gen_masella_cm_2,
t0.gen_masella_estat_ca AS gen_masella_estat_ca_3,
t0.gen_masella_estat_es AS gen_masella_estat_es_4,
t0.gen_masella_estat_en AS gen_masella_estat_en_5,
t0.gen_masella_estat_fr AS gen_masella_estat_fr_6,
t0.gen_masella_estat_pt AS gen_masella_estat_pt_7,
t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8,
t0.gen_masella_estat2_es AS gen_masella_estat2_es_9,
t0.gen_masella_estat2_en AS gen_masella_estat2_en_10,
t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11,
t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12,
t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13,
t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14,
t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15,
t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16,
t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17,
t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18,
t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19,
t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20,
t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21,
t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22,
t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23,
t0.gen_bosc_cm AS gen_bosc_cm_24,
t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25,
t0.gen_bosc_estat_es AS gen_bosc_estat_es_26,
t0.gen_bosc_estat_en AS gen_bosc_estat_en_27,
t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28,
t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29,
t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30,
t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31,
t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32,
t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33,
t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34,
t0.gen_la_pleta_cm AS gen_la_pleta_cm_35,
t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36,
t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37,
t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38,
t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39,
t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40,
t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41,
t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42,
t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43,
t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44,
t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45,
t0.gen_tosa_cm AS gen_tosa_cm_46,
t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47,
t0.gen_tosa_estat_es AS gen_tosa_estat_es_48,
t0.gen_tosa_estat_en AS gen_tosa_estat_en_49,
t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50,
t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51,
t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52,
t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53,
t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54,
t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55,
t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56,
t0.gen_data_fi_oferta AS gen_data_fi_oferta_57,
t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58,
t0.gen_text_moviment_ca AS gen_text_moviment_ca_59,
t0.gen_text_moviment_es AS gen_text_moviment_es_60,
t0.gen_text_moviment_en AS gen_text_moviment_en_61,
t0.gen_text_moviment_fr AS gen_text_moviment_fr_62,
t0.gen_text_moviment_pt AS gen_text_moviment_pt_63,
t0.gen_text_estatic_ca AS gen_text_estatic_ca_64,
t0.gen_text_estatic_es AS gen_text_estatic_es_65,
t0.gen_text_estatic_en AS gen_text_estatic_en_66,
t0.gen_text_estatic_fr AS gen_text_estatic_fr_67,
t0.gen_text_estatic_pt AS gen_text_estatic_pt_68,
t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69,
t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70,
t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71,
t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72,
t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73,
t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74,
t0.gen_logo_ca AS gen_logo_ca_75,
t0.gen_logo_es AS gen_logo_es_76,
t0.gen_logo_en AS gen_logo_en_77,
t0.gen_logo_fr AS gen_logo_fr_78,
t0.gen_logo_pt AS gen_logo_pt_79,
t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80,
t0.gen_idioma_es_visible AS gen_idioma_es_visible_81,
t0.gen_idioma_en_visible AS gen_idioma_en_visible_82,
t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83,
t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84,
t0.gen_webcam_visible AS gen_webcam_visible_85,
t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86,
t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87,
t0.gen_prediccio_visible AS gen_prediccio_visible_88,
t0.gen_meteo_visible AS gen_meteo_visible_89,
t0.gen_pistes_visible AS gen_pistes_visible_90,
t0.gen_remuntadors_visible AS gen_remuntadors_visible_91,
t0.gen_desnivell_visible AS gen_desnivell_visible_92,
t0.gen_gruix_visible AS gen_gruix_visible_93,
t0.gen_qualitat_visible AS gen_qualitat_visible_94,
t0.gen_km_esquiables AS gen_km_esquiables_95,
t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96,
t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97,
t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98,
t0.gen_facebook_visible AS gen_facebook_visible_99,
t0.gen_twitter_visible AS gen_twitter_visible_100,
t0.gen_youtube_visible AS gen_youtube_visible_101,
t0.gen_instagram_visible AS gen_instagram_visible_102,
t0.gen_app_visible AS gen_app_visible_103,
t0.gen_blog_visible AS gen_blog_visible_104,
t0.gen_area_privada_visible AS gen_area_privada_visible_105,
t0.gen_comprar_visible AS gen_comprar_visible_106,
t0.gen_contacte_visible AS gen_contacte_visible_107,
t0.gen_masella_informa_ca AS gen_masella_informa_ca_108,
t0.gen_masella_informa_es AS gen_masella_informa_es_109,
t0.gen_masella_informa_en AS gen_masella_informa_en_110,
t0.gen_masella_informa_fr AS gen_masella_informa_fr_111,
t0.gen_masella_informa_pt AS gen_masella_informa_pt_112,
t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113,
t0.gen_instagram_informa_es AS gen_instagram_informa_es_114,
t0.gen_instagram_informa_en AS gen_instagram_informa_en_115,
t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116,
t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117,
t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118,
t0.gen_infonit_informa_es AS gen_infonit_informa_es_119,
t0.gen_infonit_informa_en AS gen_infonit_informa_en_120,
t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121,
t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122,
t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123,
t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124,
t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125,
t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126,
t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127,
t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128,
t0.gen_snowpark_dia AS gen_snowpark_dia_129,
t0.gen_snowpark_nit AS gen_snowpark_nit_130,
t0.gen_alp2500 AS gen_alp2500_131,
t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132,
t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133,
t0.gen_imatge_infoneu AS gen_imatge_infoneu_134,
t0.gen_imatge_infonit AS gen_imatge_infonit_135,
t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136,
t0.gen_previsio_nit_es AS gen_previsio_nit_es_137,
t0.gen_previsio_nit_en AS gen_previsio_nit_en_138,
t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139,
t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140,
t0.gen_infoneu_visible AS gen_infoneu_visible_141,
t0.gen_infonit_visible AS gen_infonit_visible_142,
t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143,
t0.gen_titol_video_central_es AS gen_titol_video_central_es_144,
t0.gen_titol_video_central_en AS gen_titol_video_central_en_145,
t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146,
t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147,
t0.gen_video_central_visible AS gen_video_central_visible_148,
t0.gen_numero_video_home AS gen_numero_video_home_149,
t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150,
t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151,
t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152,
t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153,
t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154,
t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155,
t0.gen_codi_descompte AS gen_codi_descompte_156,
t0.gen_masella_tv AS gen_masella_tv_157,
t0.gen_promocio_visible AS gen_promocio_visible_158,
t0.gen_horaris_ca AS gen_horaris_ca_159,
t0.gen_horaris_es AS gen_horaris_es_160,
t0.gen_horaris_en AS gen_horaris_en_161,
t0.gen_horaris_fr AS gen_horaris_fr_162,
t0.gen_horaris_pt AS gen_horaris_pt_163,
t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164,
t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165,
t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166,
t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167,
t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168,
t0.gen_botiga_abonament AS gen_botiga_abonament_169,
t0.gen_botiga_forfets AS gen_botiga_forfets_170,
t0.gen_botiga_promocions AS gen_botiga_promocions_171,
t0.gen_botiga_recarrega AS gen_botiga_recarrega_172,
t0.gen_botiga_classes AS gen_botiga_classes_173,
t0.gen_botiga_lloguer AS gen_botiga_lloguer_174,
t0.gen_video_slider_home AS gen_video_slider_home_175,
t0.gen_des_id AS gen_des_id_176
FROM
General t0
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0;
|
| 3 |
0.15 ms |
SELECT t0.spo_id AS spo_id_1, t0.spo_nom_es AS spo_nom_es_2, t0.spo_nom_en AS spo_nom_en_3, t0.spo_nom_ca AS spo_nom_ca_4, t0.spo_nom_fr AS spo_nom_fr_5, t0.spo_nom_pt AS spo_nom_pt_6, t0.spo_slug_es AS spo_slug_es_7, t0.spo_slug_en AS spo_slug_en_8, t0.spo_slug_ca AS spo_slug_ca_9, t0.spo_slug_fr AS spo_slug_fr_10, t0.spo_slug_pt AS spo_slug_pt_11, t0.spo_url AS spo_url_12, t0.spo_imatge AS spo_imatge_13, t0.spo_ordre AS spo_ordre_14, t0.spo_visible AS spo_visible_15 FROM Sponsors t0 WHERE t0.spo_visible = ? ORDER BY t0.spo_ordre ASC
SELECT t0.spo_id AS spo_id_1, t0.spo_nom_es AS spo_nom_es_2, t0.spo_nom_en AS spo_nom_en_3, t0.spo_nom_ca AS spo_nom_ca_4, t0.spo_nom_fr AS spo_nom_fr_5, t0.spo_nom_pt AS spo_nom_pt_6, t0.spo_slug_es AS spo_slug_es_7, t0.spo_slug_en AS spo_slug_en_8, t0.spo_slug_ca AS spo_slug_ca_9, t0.spo_slug_fr AS spo_slug_fr_10, t0.spo_slug_pt AS spo_slug_pt_11, t0.spo_url AS spo_url_12, t0.spo_imatge AS spo_imatge_13, t0.spo_ordre AS spo_ordre_14, t0.spo_visible AS spo_visible_15 FROM Sponsors t0 WHERE t0.spo_visible = 1 ORDER BY t0.spo_ordre ASC;
|
| 4 |
0.17 ms |
SELECT t0.col_id AS col_id_1, t0.col_data_alta AS col_data_alta_2, t0.col_quantitat AS col_quantitat_3, t0.col_preu AS col_preu_4, t0.col_total AS col_total_5, t0.col_detall AS col_detall_6, t0.col_nom AS col_nom_7, t0.col_cognom1 AS col_cognom1_8, t0.col_cognom2 AS col_cognom2_9, t0.col_taquilla AS col_taquilla_10, t0.col_foto AS col_foto_11, t0.col_document AS col_document_12, t0.col_resident AS col_resident_13, t0.col_familia_nombrosa AS col_familia_nombrosa_14, t0.col_abonaments_tipus AS col_abonaments_tipus_15, t0.col_suplement AS col_suplement_16, t0.col_nocturn AS col_nocturn_17, t0.col_id_aux AS col_id_aux_18, t0.col_data_naixement AS col_data_naixement_19, t0.col_data_modificacio AS col_data_modificacio_20, t0.col_xip AS col_xip_21, t0.col_proj_no AS col_proj_no_22, t0.col_pos_no AS col_pos_no_23, t0.col_serial_no AS col_serial_no_24, t0.col_journal_no AS col_journal_no_25, t0.col_estat AS col_estat_26, t0.col_resposta_enviat AS col_resposta_enviat_27, t0.col_resposta_error AS col_resposta_error_28, t0.col_data_comunicacio AS col_data_comunicacio_29, t0.col_pagament_targeta AS col_pagament_targeta_30, t0.col_pagament_efectiu AS col_pagament_efectiu_31, t0.col_descompte AS col_descompte_32, t0.col_anulada AS col_anulada_33, t0.col_xip_introduit_client AS col_xip_introduit_client_34, t0.col_tipus_descompte AS col_tipus_descompte_35, t0.col_linia_id AS col_linia_id_36, t0.col_com_id AS col_com_id_37, t0.col_con_id AS col_con_id_38, t0.col_abo_id AS col_abo_id_39, t0.col_col_id AS col_col_id_40, t0.col_usu_id_modificacio AS col_usu_id_modificacio_41 FROM ComandesLinies t0 WHERE t0.col_com_id = ? AND t0.col_suplement = ?
Parameters: [
"63701"
0
]
SELECT
t0.col_id AS col_id_1,
t0.col_data_alta AS col_data_alta_2,
t0.col_quantitat AS col_quantitat_3,
t0.col_preu AS col_preu_4,
t0.col_total AS col_total_5,
t0.col_detall AS col_detall_6,
t0.col_nom AS col_nom_7,
t0.col_cognom1 AS col_cognom1_8,
t0.col_cognom2 AS col_cognom2_9,
t0.col_taquilla AS col_taquilla_10,
t0.col_foto AS col_foto_11,
t0.col_document AS col_document_12,
t0.col_resident AS col_resident_13,
t0.col_familia_nombrosa AS col_familia_nombrosa_14,
t0.col_abonaments_tipus AS col_abonaments_tipus_15,
t0.col_suplement AS col_suplement_16,
t0.col_nocturn AS col_nocturn_17,
t0.col_id_aux AS col_id_aux_18,
t0.col_data_naixement AS col_data_naixement_19,
t0.col_data_modificacio AS col_data_modificacio_20,
t0.col_xip AS col_xip_21,
t0.col_proj_no AS col_proj_no_22,
t0.col_pos_no AS col_pos_no_23,
t0.col_serial_no AS col_serial_no_24,
t0.col_journal_no AS col_journal_no_25,
t0.col_estat AS col_estat_26,
t0.col_resposta_enviat AS col_resposta_enviat_27,
t0.col_resposta_error AS col_resposta_error_28,
t0.col_data_comunicacio AS col_data_comunicacio_29,
t0.col_pagament_targeta AS col_pagament_targeta_30,
t0.col_pagament_efectiu AS col_pagament_efectiu_31,
t0.col_descompte AS col_descompte_32,
t0.col_anulada AS col_anulada_33,
t0.col_xip_introduit_client AS col_xip_introduit_client_34,
t0.col_tipus_descompte AS col_tipus_descompte_35,
t0.col_linia_id AS col_linia_id_36,
t0.col_com_id AS col_com_id_37,
t0.col_con_id AS col_con_id_38,
t0.col_abo_id AS col_abo_id_39,
t0.col_col_id AS col_col_id_40,
t0.col_usu_id_modificacio AS col_usu_id_modificacio_41
FROM
ComandesLinies t0
WHERE
t0.col_com_id = ?
AND t0.col_suplement = ?
SELECT t0.col_id AS col_id_1, t0.col_data_alta AS col_data_alta_2, t0.col_quantitat AS col_quantitat_3, t0.col_preu AS col_preu_4, t0.col_total AS col_total_5, t0.col_detall AS col_detall_6, t0.col_nom AS col_nom_7, t0.col_cognom1 AS col_cognom1_8, t0.col_cognom2 AS col_cognom2_9, t0.col_taquilla AS col_taquilla_10, t0.col_foto AS col_foto_11, t0.col_document AS col_document_12, t0.col_resident AS col_resident_13, t0.col_familia_nombrosa AS col_familia_nombrosa_14, t0.col_abonaments_tipus AS col_abonaments_tipus_15, t0.col_suplement AS col_suplement_16, t0.col_nocturn AS col_nocturn_17, t0.col_id_aux AS col_id_aux_18, t0.col_data_naixement AS col_data_naixement_19, t0.col_data_modificacio AS col_data_modificacio_20, t0.col_xip AS col_xip_21, t0.col_proj_no AS col_proj_no_22, t0.col_pos_no AS col_pos_no_23, t0.col_serial_no AS col_serial_no_24, t0.col_journal_no AS col_journal_no_25, t0.col_estat AS col_estat_26, t0.col_resposta_enviat AS col_resposta_enviat_27, t0.col_resposta_error AS col_resposta_error_28, t0.col_data_comunicacio AS col_data_comunicacio_29, t0.col_pagament_targeta AS col_pagament_targeta_30, t0.col_pagament_efectiu AS col_pagament_efectiu_31, t0.col_descompte AS col_descompte_32, t0.col_anulada AS col_anulada_33, t0.col_xip_introduit_client AS col_xip_introduit_client_34, t0.col_tipus_descompte AS col_tipus_descompte_35, t0.col_linia_id AS col_linia_id_36, t0.col_com_id AS col_com_id_37, t0.col_con_id AS col_con_id_38, t0.col_abo_id AS col_abo_id_39, t0.col_col_id AS col_col_id_40, t0.col_usu_id_modificacio AS col_usu_id_modificacio_41 FROM ComandesLinies t0 WHERE t0.col_com_id = '63701' AND t0.col_suplement = 0;
|
| 5 |
0.15 ms |
SELECT t0.col_id AS col_id_1, t0.col_data_alta AS col_data_alta_2, t0.col_quantitat AS col_quantitat_3, t0.col_preu AS col_preu_4, t0.col_total AS col_total_5, t0.col_detall AS col_detall_6, t0.col_nom AS col_nom_7, t0.col_cognom1 AS col_cognom1_8, t0.col_cognom2 AS col_cognom2_9, t0.col_taquilla AS col_taquilla_10, t0.col_foto AS col_foto_11, t0.col_document AS col_document_12, t0.col_resident AS col_resident_13, t0.col_familia_nombrosa AS col_familia_nombrosa_14, t0.col_abonaments_tipus AS col_abonaments_tipus_15, t0.col_suplement AS col_suplement_16, t0.col_nocturn AS col_nocturn_17, t0.col_id_aux AS col_id_aux_18, t0.col_data_naixement AS col_data_naixement_19, t0.col_data_modificacio AS col_data_modificacio_20, t0.col_xip AS col_xip_21, t0.col_proj_no AS col_proj_no_22, t0.col_pos_no AS col_pos_no_23, t0.col_serial_no AS col_serial_no_24, t0.col_journal_no AS col_journal_no_25, t0.col_estat AS col_estat_26, t0.col_resposta_enviat AS col_resposta_enviat_27, t0.col_resposta_error AS col_resposta_error_28, t0.col_data_comunicacio AS col_data_comunicacio_29, t0.col_pagament_targeta AS col_pagament_targeta_30, t0.col_pagament_efectiu AS col_pagament_efectiu_31, t0.col_descompte AS col_descompte_32, t0.col_anulada AS col_anulada_33, t0.col_xip_introduit_client AS col_xip_introduit_client_34, t0.col_tipus_descompte AS col_tipus_descompte_35, t0.col_linia_id AS col_linia_id_36, t0.col_com_id AS col_com_id_37, t0.col_con_id AS col_con_id_38, t0.col_abo_id AS col_abo_id_39, t0.col_col_id AS col_col_id_40, t0.col_usu_id_modificacio AS col_usu_id_modificacio_41 FROM ComandesLinies t0 WHERE t0.col_com_id = ? AND t0.col_suplement = ?
Parameters: [
"63701"
1
]
SELECT
t0.col_id AS col_id_1,
t0.col_data_alta AS col_data_alta_2,
t0.col_quantitat AS col_quantitat_3,
t0.col_preu AS col_preu_4,
t0.col_total AS col_total_5,
t0.col_detall AS col_detall_6,
t0.col_nom AS col_nom_7,
t0.col_cognom1 AS col_cognom1_8,
t0.col_cognom2 AS col_cognom2_9,
t0.col_taquilla AS col_taquilla_10,
t0.col_foto AS col_foto_11,
t0.col_document AS col_document_12,
t0.col_resident AS col_resident_13,
t0.col_familia_nombrosa AS col_familia_nombrosa_14,
t0.col_abonaments_tipus AS col_abonaments_tipus_15,
t0.col_suplement AS col_suplement_16,
t0.col_nocturn AS col_nocturn_17,
t0.col_id_aux AS col_id_aux_18,
t0.col_data_naixement AS col_data_naixement_19,
t0.col_data_modificacio AS col_data_modificacio_20,
t0.col_xip AS col_xip_21,
t0.col_proj_no AS col_proj_no_22,
t0.col_pos_no AS col_pos_no_23,
t0.col_serial_no AS col_serial_no_24,
t0.col_journal_no AS col_journal_no_25,
t0.col_estat AS col_estat_26,
t0.col_resposta_enviat AS col_resposta_enviat_27,
t0.col_resposta_error AS col_resposta_error_28,
t0.col_data_comunicacio AS col_data_comunicacio_29,
t0.col_pagament_targeta AS col_pagament_targeta_30,
t0.col_pagament_efectiu AS col_pagament_efectiu_31,
t0.col_descompte AS col_descompte_32,
t0.col_anulada AS col_anulada_33,
t0.col_xip_introduit_client AS col_xip_introduit_client_34,
t0.col_tipus_descompte AS col_tipus_descompte_35,
t0.col_linia_id AS col_linia_id_36,
t0.col_com_id AS col_com_id_37,
t0.col_con_id AS col_con_id_38,
t0.col_abo_id AS col_abo_id_39,
t0.col_col_id AS col_col_id_40,
t0.col_usu_id_modificacio AS col_usu_id_modificacio_41
FROM
ComandesLinies t0
WHERE
t0.col_com_id = ?
AND t0.col_suplement = ?
SELECT t0.col_id AS col_id_1, t0.col_data_alta AS col_data_alta_2, t0.col_quantitat AS col_quantitat_3, t0.col_preu AS col_preu_4, t0.col_total AS col_total_5, t0.col_detall AS col_detall_6, t0.col_nom AS col_nom_7, t0.col_cognom1 AS col_cognom1_8, t0.col_cognom2 AS col_cognom2_9, t0.col_taquilla AS col_taquilla_10, t0.col_foto AS col_foto_11, t0.col_document AS col_document_12, t0.col_resident AS col_resident_13, t0.col_familia_nombrosa AS col_familia_nombrosa_14, t0.col_abonaments_tipus AS col_abonaments_tipus_15, t0.col_suplement AS col_suplement_16, t0.col_nocturn AS col_nocturn_17, t0.col_id_aux AS col_id_aux_18, t0.col_data_naixement AS col_data_naixement_19, t0.col_data_modificacio AS col_data_modificacio_20, t0.col_xip AS col_xip_21, t0.col_proj_no AS col_proj_no_22, t0.col_pos_no AS col_pos_no_23, t0.col_serial_no AS col_serial_no_24, t0.col_journal_no AS col_journal_no_25, t0.col_estat AS col_estat_26, t0.col_resposta_enviat AS col_resposta_enviat_27, t0.col_resposta_error AS col_resposta_error_28, t0.col_data_comunicacio AS col_data_comunicacio_29, t0.col_pagament_targeta AS col_pagament_targeta_30, t0.col_pagament_efectiu AS col_pagament_efectiu_31, t0.col_descompte AS col_descompte_32, t0.col_anulada AS col_anulada_33, t0.col_xip_introduit_client AS col_xip_introduit_client_34, t0.col_tipus_descompte AS col_tipus_descompte_35, t0.col_linia_id AS col_linia_id_36, t0.col_com_id AS col_com_id_37, t0.col_con_id AS col_con_id_38, t0.col_abo_id AS col_abo_id_39, t0.col_col_id AS col_col_id_40, t0.col_usu_id_modificacio AS col_usu_id_modificacio_41 FROM ComandesLinies t0 WHERE t0.col_com_id = '63701' AND t0.col_suplement = 1;
|
| 6 |
0.30 ms |
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0 WHERE t0.gen_id = ?
SELECT
t0.gen_id AS gen_id_1,
t0.gen_masella_cm AS gen_masella_cm_2,
t0.gen_masella_estat_ca AS gen_masella_estat_ca_3,
t0.gen_masella_estat_es AS gen_masella_estat_es_4,
t0.gen_masella_estat_en AS gen_masella_estat_en_5,
t0.gen_masella_estat_fr AS gen_masella_estat_fr_6,
t0.gen_masella_estat_pt AS gen_masella_estat_pt_7,
t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8,
t0.gen_masella_estat2_es AS gen_masella_estat2_es_9,
t0.gen_masella_estat2_en AS gen_masella_estat2_en_10,
t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11,
t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12,
t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13,
t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14,
t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15,
t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16,
t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17,
t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18,
t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19,
t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20,
t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21,
t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22,
t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23,
t0.gen_bosc_cm AS gen_bosc_cm_24,
t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25,
t0.gen_bosc_estat_es AS gen_bosc_estat_es_26,
t0.gen_bosc_estat_en AS gen_bosc_estat_en_27,
t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28,
t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29,
t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30,
t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31,
t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32,
t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33,
t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34,
t0.gen_la_pleta_cm AS gen_la_pleta_cm_35,
t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36,
t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37,
t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38,
t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39,
t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40,
t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41,
t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42,
t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43,
t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44,
t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45,
t0.gen_tosa_cm AS gen_tosa_cm_46,
t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47,
t0.gen_tosa_estat_es AS gen_tosa_estat_es_48,
t0.gen_tosa_estat_en AS gen_tosa_estat_en_49,
t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50,
t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51,
t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52,
t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53,
t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54,
t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55,
t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56,
t0.gen_data_fi_oferta AS gen_data_fi_oferta_57,
t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58,
t0.gen_text_moviment_ca AS gen_text_moviment_ca_59,
t0.gen_text_moviment_es AS gen_text_moviment_es_60,
t0.gen_text_moviment_en AS gen_text_moviment_en_61,
t0.gen_text_moviment_fr AS gen_text_moviment_fr_62,
t0.gen_text_moviment_pt AS gen_text_moviment_pt_63,
t0.gen_text_estatic_ca AS gen_text_estatic_ca_64,
t0.gen_text_estatic_es AS gen_text_estatic_es_65,
t0.gen_text_estatic_en AS gen_text_estatic_en_66,
t0.gen_text_estatic_fr AS gen_text_estatic_fr_67,
t0.gen_text_estatic_pt AS gen_text_estatic_pt_68,
t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69,
t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70,
t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71,
t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72,
t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73,
t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74,
t0.gen_logo_ca AS gen_logo_ca_75,
t0.gen_logo_es AS gen_logo_es_76,
t0.gen_logo_en AS gen_logo_en_77,
t0.gen_logo_fr AS gen_logo_fr_78,
t0.gen_logo_pt AS gen_logo_pt_79,
t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80,
t0.gen_idioma_es_visible AS gen_idioma_es_visible_81,
t0.gen_idioma_en_visible AS gen_idioma_en_visible_82,
t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83,
t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84,
t0.gen_webcam_visible AS gen_webcam_visible_85,
t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86,
t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87,
t0.gen_prediccio_visible AS gen_prediccio_visible_88,
t0.gen_meteo_visible AS gen_meteo_visible_89,
t0.gen_pistes_visible AS gen_pistes_visible_90,
t0.gen_remuntadors_visible AS gen_remuntadors_visible_91,
t0.gen_desnivell_visible AS gen_desnivell_visible_92,
t0.gen_gruix_visible AS gen_gruix_visible_93,
t0.gen_qualitat_visible AS gen_qualitat_visible_94,
t0.gen_km_esquiables AS gen_km_esquiables_95,
t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96,
t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97,
t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98,
t0.gen_facebook_visible AS gen_facebook_visible_99,
t0.gen_twitter_visible AS gen_twitter_visible_100,
t0.gen_youtube_visible AS gen_youtube_visible_101,
t0.gen_instagram_visible AS gen_instagram_visible_102,
t0.gen_app_visible AS gen_app_visible_103,
t0.gen_blog_visible AS gen_blog_visible_104,
t0.gen_area_privada_visible AS gen_area_privada_visible_105,
t0.gen_comprar_visible AS gen_comprar_visible_106,
t0.gen_contacte_visible AS gen_contacte_visible_107,
t0.gen_masella_informa_ca AS gen_masella_informa_ca_108,
t0.gen_masella_informa_es AS gen_masella_informa_es_109,
t0.gen_masella_informa_en AS gen_masella_informa_en_110,
t0.gen_masella_informa_fr AS gen_masella_informa_fr_111,
t0.gen_masella_informa_pt AS gen_masella_informa_pt_112,
t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113,
t0.gen_instagram_informa_es AS gen_instagram_informa_es_114,
t0.gen_instagram_informa_en AS gen_instagram_informa_en_115,
t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116,
t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117,
t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118,
t0.gen_infonit_informa_es AS gen_infonit_informa_es_119,
t0.gen_infonit_informa_en AS gen_infonit_informa_en_120,
t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121,
t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122,
t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123,
t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124,
t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125,
t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126,
t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127,
t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128,
t0.gen_snowpark_dia AS gen_snowpark_dia_129,
t0.gen_snowpark_nit AS gen_snowpark_nit_130,
t0.gen_alp2500 AS gen_alp2500_131,
t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132,
t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133,
t0.gen_imatge_infoneu AS gen_imatge_infoneu_134,
t0.gen_imatge_infonit AS gen_imatge_infonit_135,
t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136,
t0.gen_previsio_nit_es AS gen_previsio_nit_es_137,
t0.gen_previsio_nit_en AS gen_previsio_nit_en_138,
t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139,
t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140,
t0.gen_infoneu_visible AS gen_infoneu_visible_141,
t0.gen_infonit_visible AS gen_infonit_visible_142,
t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143,
t0.gen_titol_video_central_es AS gen_titol_video_central_es_144,
t0.gen_titol_video_central_en AS gen_titol_video_central_en_145,
t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146,
t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147,
t0.gen_video_central_visible AS gen_video_central_visible_148,
t0.gen_numero_video_home AS gen_numero_video_home_149,
t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150,
t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151,
t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152,
t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153,
t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154,
t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155,
t0.gen_codi_descompte AS gen_codi_descompte_156,
t0.gen_masella_tv AS gen_masella_tv_157,
t0.gen_promocio_visible AS gen_promocio_visible_158,
t0.gen_horaris_ca AS gen_horaris_ca_159,
t0.gen_horaris_es AS gen_horaris_es_160,
t0.gen_horaris_en AS gen_horaris_en_161,
t0.gen_horaris_fr AS gen_horaris_fr_162,
t0.gen_horaris_pt AS gen_horaris_pt_163,
t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164,
t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165,
t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166,
t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167,
t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168,
t0.gen_botiga_abonament AS gen_botiga_abonament_169,
t0.gen_botiga_forfets AS gen_botiga_forfets_170,
t0.gen_botiga_promocions AS gen_botiga_promocions_171,
t0.gen_botiga_recarrega AS gen_botiga_recarrega_172,
t0.gen_botiga_classes AS gen_botiga_classes_173,
t0.gen_botiga_lloguer AS gen_botiga_lloguer_174,
t0.gen_video_slider_home AS gen_video_slider_home_175,
t0.gen_des_id AS gen_des_id_176
FROM
General t0
WHERE
t0.gen_id = ?
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0 WHERE t0.gen_id = 1;
|
| 7 |
0.19 ms |
SELECT t0.com_id AS com_id_1, t0.com_data AS com_data_2, t0.com_estat AS com_estat_3, t0.com_observacions AS com_observacions_4, t0.com_localitzador AS com_localitzador_5, t0.com_id_aux AS com_id_aux_6, t0.com_factura AS com_factura_7, t0.com_nom_empresa AS com_nom_empresa_8, t0.com_nif_empresa AS com_nif_empresa_9, t0.com_direccio_empresa AS com_direccio_empresa_10, t0.com_cp_empresa AS com_cp_empresa_11, t0.com_poblacio_empresa AS com_poblacio_empresa_12, t0.com_provincia_empresa AS com_provincia_empresa_13, t0.com_company_proj_no AS com_company_proj_no_14, t0.com_company_pos_no AS com_company_pos_no_15, t0.com_company_num AS com_company_num_16, t0.com_lloc_venda AS com_lloc_venda_17, t0.com_forma_pagament AS com_forma_pagament_18, t0.com_observacions_pagament AS com_observacions_pagament_19, t0.com_pagament_targeta AS com_pagament_targeta_20, t0.com_pagament_efectiu AS com_pagament_efectiu_21, t0.com_pagament_credit AS com_pagament_credit_22, t0.com_codi_descompte AS com_codi_descompte_23, t0.com_descompte AS com_descompte_24, t0.com_observacions_internas AS com_observacions_internas_25, t0.com_firma_codi AS com_firma_codi_26, t0.com_data_modificacio AS com_data_modificacio_27, t0.com_nom_promocio AS com_nom_promocio_28, t0.com_cognom1_promocio AS com_cognom1_promocio_29, t0.com_cognom2_promocio AS com_cognom2_promocio_30, t0.com_email_promocio AS com_email_promocio_31, t0.com_enviat AS com_enviat_32, t0.com_resposta_enviat AS com_resposta_enviat_33, t0.com_tipus_client AS com_tipus_client_34, t0.com_replica AS com_replica_35, t0.com_devolucio AS com_devolucio_36, t0.com_col_id AS com_col_id_37, t0.com_proj_no AS com_proj_no_38, t0.com_pos_no AS com_pos_no_39, t0.com_trans_no AS com_trans_no_40, t0.com_resposta_error AS com_resposta_error_41, t0.com_proces_estadistic AS com_proces_estadistic_42, t0.com_con_id AS com_con_id_43, t0.com_pai_id_empresa AS com_pai_id_empresa_44, t0.com_usu_id AS com_usu_id_45, t0.com_usu_id_modificacio AS com_usu_id_modificacio_46, t0.com_pro_id AS com_pro_id_47 FROM Comandes t0 WHERE t0.com_id = ?
SELECT
t0.com_id AS com_id_1,
t0.com_data AS com_data_2,
t0.com_estat AS com_estat_3,
t0.com_observacions AS com_observacions_4,
t0.com_localitzador AS com_localitzador_5,
t0.com_id_aux AS com_id_aux_6,
t0.com_factura AS com_factura_7,
t0.com_nom_empresa AS com_nom_empresa_8,
t0.com_nif_empresa AS com_nif_empresa_9,
t0.com_direccio_empresa AS com_direccio_empresa_10,
t0.com_cp_empresa AS com_cp_empresa_11,
t0.com_poblacio_empresa AS com_poblacio_empresa_12,
t0.com_provincia_empresa AS com_provincia_empresa_13,
t0.com_company_proj_no AS com_company_proj_no_14,
t0.com_company_pos_no AS com_company_pos_no_15,
t0.com_company_num AS com_company_num_16,
t0.com_lloc_venda AS com_lloc_venda_17,
t0.com_forma_pagament AS com_forma_pagament_18,
t0.com_observacions_pagament AS com_observacions_pagament_19,
t0.com_pagament_targeta AS com_pagament_targeta_20,
t0.com_pagament_efectiu AS com_pagament_efectiu_21,
t0.com_pagament_credit AS com_pagament_credit_22,
t0.com_codi_descompte AS com_codi_descompte_23,
t0.com_descompte AS com_descompte_24,
t0.com_observacions_internas AS com_observacions_internas_25,
t0.com_firma_codi AS com_firma_codi_26,
t0.com_data_modificacio AS com_data_modificacio_27,
t0.com_nom_promocio AS com_nom_promocio_28,
t0.com_cognom1_promocio AS com_cognom1_promocio_29,
t0.com_cognom2_promocio AS com_cognom2_promocio_30,
t0.com_email_promocio AS com_email_promocio_31,
t0.com_enviat AS com_enviat_32,
t0.com_resposta_enviat AS com_resposta_enviat_33,
t0.com_tipus_client AS com_tipus_client_34,
t0.com_replica AS com_replica_35,
t0.com_devolucio AS com_devolucio_36,
t0.com_col_id AS com_col_id_37,
t0.com_proj_no AS com_proj_no_38,
t0.com_pos_no AS com_pos_no_39,
t0.com_trans_no AS com_trans_no_40,
t0.com_resposta_error AS com_resposta_error_41,
t0.com_proces_estadistic AS com_proces_estadistic_42,
t0.com_con_id AS com_con_id_43,
t0.com_pai_id_empresa AS com_pai_id_empresa_44,
t0.com_usu_id AS com_usu_id_45,
t0.com_usu_id_modificacio AS com_usu_id_modificacio_46,
t0.com_pro_id AS com_pro_id_47
FROM
Comandes t0
WHERE
t0.com_id = ?
SELECT t0.com_id AS com_id_1, t0.com_data AS com_data_2, t0.com_estat AS com_estat_3, t0.com_observacions AS com_observacions_4, t0.com_localitzador AS com_localitzador_5, t0.com_id_aux AS com_id_aux_6, t0.com_factura AS com_factura_7, t0.com_nom_empresa AS com_nom_empresa_8, t0.com_nif_empresa AS com_nif_empresa_9, t0.com_direccio_empresa AS com_direccio_empresa_10, t0.com_cp_empresa AS com_cp_empresa_11, t0.com_poblacio_empresa AS com_poblacio_empresa_12, t0.com_provincia_empresa AS com_provincia_empresa_13, t0.com_company_proj_no AS com_company_proj_no_14, t0.com_company_pos_no AS com_company_pos_no_15, t0.com_company_num AS com_company_num_16, t0.com_lloc_venda AS com_lloc_venda_17, t0.com_forma_pagament AS com_forma_pagament_18, t0.com_observacions_pagament AS com_observacions_pagament_19, t0.com_pagament_targeta AS com_pagament_targeta_20, t0.com_pagament_efectiu AS com_pagament_efectiu_21, t0.com_pagament_credit AS com_pagament_credit_22, t0.com_codi_descompte AS com_codi_descompte_23, t0.com_descompte AS com_descompte_24, t0.com_observacions_internas AS com_observacions_internas_25, t0.com_firma_codi AS com_firma_codi_26, t0.com_data_modificacio AS com_data_modificacio_27, t0.com_nom_promocio AS com_nom_promocio_28, t0.com_cognom1_promocio AS com_cognom1_promocio_29, t0.com_cognom2_promocio AS com_cognom2_promocio_30, t0.com_email_promocio AS com_email_promocio_31, t0.com_enviat AS com_enviat_32, t0.com_resposta_enviat AS com_resposta_enviat_33, t0.com_tipus_client AS com_tipus_client_34, t0.com_replica AS com_replica_35, t0.com_devolucio AS com_devolucio_36, t0.com_col_id AS com_col_id_37, t0.com_proj_no AS com_proj_no_38, t0.com_pos_no AS com_pos_no_39, t0.com_trans_no AS com_trans_no_40, t0.com_resposta_error AS com_resposta_error_41, t0.com_proces_estadistic AS com_proces_estadistic_42, t0.com_con_id AS com_con_id_43, t0.com_pai_id_empresa AS com_pai_id_empresa_44, t0.com_usu_id AS com_usu_id_45, t0.com_usu_id_modificacio AS com_usu_id_modificacio_46, t0.com_pro_id AS com_pro_id_47 FROM Comandes t0 WHERE t0.com_id = '63701';
|
| 8 |
0.17 ms |
SELECT t0.col_id AS col_id_1, t0.col_data_alta AS col_data_alta_2, t0.col_quantitat AS col_quantitat_3, t0.col_preu AS col_preu_4, t0.col_total AS col_total_5, t0.col_detall AS col_detall_6, t0.col_nom AS col_nom_7, t0.col_cognom1 AS col_cognom1_8, t0.col_cognom2 AS col_cognom2_9, t0.col_taquilla AS col_taquilla_10, t0.col_foto AS col_foto_11, t0.col_document AS col_document_12, t0.col_resident AS col_resident_13, t0.col_familia_nombrosa AS col_familia_nombrosa_14, t0.col_abonaments_tipus AS col_abonaments_tipus_15, t0.col_suplement AS col_suplement_16, t0.col_nocturn AS col_nocturn_17, t0.col_id_aux AS col_id_aux_18, t0.col_data_naixement AS col_data_naixement_19, t0.col_data_modificacio AS col_data_modificacio_20, t0.col_xip AS col_xip_21, t0.col_proj_no AS col_proj_no_22, t0.col_pos_no AS col_pos_no_23, t0.col_serial_no AS col_serial_no_24, t0.col_journal_no AS col_journal_no_25, t0.col_estat AS col_estat_26, t0.col_resposta_enviat AS col_resposta_enviat_27, t0.col_resposta_error AS col_resposta_error_28, t0.col_data_comunicacio AS col_data_comunicacio_29, t0.col_pagament_targeta AS col_pagament_targeta_30, t0.col_pagament_efectiu AS col_pagament_efectiu_31, t0.col_descompte AS col_descompte_32, t0.col_anulada AS col_anulada_33, t0.col_xip_introduit_client AS col_xip_introduit_client_34, t0.col_tipus_descompte AS col_tipus_descompte_35, t0.col_linia_id AS col_linia_id_36, t0.col_com_id AS col_com_id_37, t0.col_con_id AS col_con_id_38, t0.col_abo_id AS col_abo_id_39, t0.col_col_id AS col_col_id_40, t0.col_usu_id_modificacio AS col_usu_id_modificacio_41 FROM ComandesLinies t0 WHERE t0.col_com_id = ?
SELECT
t0.col_id AS col_id_1,
t0.col_data_alta AS col_data_alta_2,
t0.col_quantitat AS col_quantitat_3,
t0.col_preu AS col_preu_4,
t0.col_total AS col_total_5,
t0.col_detall AS col_detall_6,
t0.col_nom AS col_nom_7,
t0.col_cognom1 AS col_cognom1_8,
t0.col_cognom2 AS col_cognom2_9,
t0.col_taquilla AS col_taquilla_10,
t0.col_foto AS col_foto_11,
t0.col_document AS col_document_12,
t0.col_resident AS col_resident_13,
t0.col_familia_nombrosa AS col_familia_nombrosa_14,
t0.col_abonaments_tipus AS col_abonaments_tipus_15,
t0.col_suplement AS col_suplement_16,
t0.col_nocturn AS col_nocturn_17,
t0.col_id_aux AS col_id_aux_18,
t0.col_data_naixement AS col_data_naixement_19,
t0.col_data_modificacio AS col_data_modificacio_20,
t0.col_xip AS col_xip_21,
t0.col_proj_no AS col_proj_no_22,
t0.col_pos_no AS col_pos_no_23,
t0.col_serial_no AS col_serial_no_24,
t0.col_journal_no AS col_journal_no_25,
t0.col_estat AS col_estat_26,
t0.col_resposta_enviat AS col_resposta_enviat_27,
t0.col_resposta_error AS col_resposta_error_28,
t0.col_data_comunicacio AS col_data_comunicacio_29,
t0.col_pagament_targeta AS col_pagament_targeta_30,
t0.col_pagament_efectiu AS col_pagament_efectiu_31,
t0.col_descompte AS col_descompte_32,
t0.col_anulada AS col_anulada_33,
t0.col_xip_introduit_client AS col_xip_introduit_client_34,
t0.col_tipus_descompte AS col_tipus_descompte_35,
t0.col_linia_id AS col_linia_id_36,
t0.col_com_id AS col_com_id_37,
t0.col_con_id AS col_con_id_38,
t0.col_abo_id AS col_abo_id_39,
t0.col_col_id AS col_col_id_40,
t0.col_usu_id_modificacio AS col_usu_id_modificacio_41
FROM
ComandesLinies t0
WHERE
t0.col_com_id = ?
SELECT t0.col_id AS col_id_1, t0.col_data_alta AS col_data_alta_2, t0.col_quantitat AS col_quantitat_3, t0.col_preu AS col_preu_4, t0.col_total AS col_total_5, t0.col_detall AS col_detall_6, t0.col_nom AS col_nom_7, t0.col_cognom1 AS col_cognom1_8, t0.col_cognom2 AS col_cognom2_9, t0.col_taquilla AS col_taquilla_10, t0.col_foto AS col_foto_11, t0.col_document AS col_document_12, t0.col_resident AS col_resident_13, t0.col_familia_nombrosa AS col_familia_nombrosa_14, t0.col_abonaments_tipus AS col_abonaments_tipus_15, t0.col_suplement AS col_suplement_16, t0.col_nocturn AS col_nocturn_17, t0.col_id_aux AS col_id_aux_18, t0.col_data_naixement AS col_data_naixement_19, t0.col_data_modificacio AS col_data_modificacio_20, t0.col_xip AS col_xip_21, t0.col_proj_no AS col_proj_no_22, t0.col_pos_no AS col_pos_no_23, t0.col_serial_no AS col_serial_no_24, t0.col_journal_no AS col_journal_no_25, t0.col_estat AS col_estat_26, t0.col_resposta_enviat AS col_resposta_enviat_27, t0.col_resposta_error AS col_resposta_error_28, t0.col_data_comunicacio AS col_data_comunicacio_29, t0.col_pagament_targeta AS col_pagament_targeta_30, t0.col_pagament_efectiu AS col_pagament_efectiu_31, t0.col_descompte AS col_descompte_32, t0.col_anulada AS col_anulada_33, t0.col_xip_introduit_client AS col_xip_introduit_client_34, t0.col_tipus_descompte AS col_tipus_descompte_35, t0.col_linia_id AS col_linia_id_36, t0.col_com_id AS col_com_id_37, t0.col_con_id AS col_con_id_38, t0.col_abo_id AS col_abo_id_39, t0.col_col_id AS col_col_id_40, t0.col_usu_id_modificacio AS col_usu_id_modificacio_41 FROM ComandesLinies t0 WHERE t0.col_com_id = '63701';
|
| 9 |
0.23 ms |
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0
SELECT
t0.gen_id AS gen_id_1,
t0.gen_masella_cm AS gen_masella_cm_2,
t0.gen_masella_estat_ca AS gen_masella_estat_ca_3,
t0.gen_masella_estat_es AS gen_masella_estat_es_4,
t0.gen_masella_estat_en AS gen_masella_estat_en_5,
t0.gen_masella_estat_fr AS gen_masella_estat_fr_6,
t0.gen_masella_estat_pt AS gen_masella_estat_pt_7,
t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8,
t0.gen_masella_estat2_es AS gen_masella_estat2_es_9,
t0.gen_masella_estat2_en AS gen_masella_estat2_en_10,
t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11,
t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12,
t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13,
t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14,
t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15,
t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16,
t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17,
t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18,
t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19,
t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20,
t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21,
t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22,
t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23,
t0.gen_bosc_cm AS gen_bosc_cm_24,
t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25,
t0.gen_bosc_estat_es AS gen_bosc_estat_es_26,
t0.gen_bosc_estat_en AS gen_bosc_estat_en_27,
t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28,
t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29,
t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30,
t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31,
t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32,
t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33,
t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34,
t0.gen_la_pleta_cm AS gen_la_pleta_cm_35,
t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36,
t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37,
t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38,
t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39,
t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40,
t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41,
t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42,
t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43,
t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44,
t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45,
t0.gen_tosa_cm AS gen_tosa_cm_46,
t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47,
t0.gen_tosa_estat_es AS gen_tosa_estat_es_48,
t0.gen_tosa_estat_en AS gen_tosa_estat_en_49,
t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50,
t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51,
t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52,
t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53,
t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54,
t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55,
t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56,
t0.gen_data_fi_oferta AS gen_data_fi_oferta_57,
t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58,
t0.gen_text_moviment_ca AS gen_text_moviment_ca_59,
t0.gen_text_moviment_es AS gen_text_moviment_es_60,
t0.gen_text_moviment_en AS gen_text_moviment_en_61,
t0.gen_text_moviment_fr AS gen_text_moviment_fr_62,
t0.gen_text_moviment_pt AS gen_text_moviment_pt_63,
t0.gen_text_estatic_ca AS gen_text_estatic_ca_64,
t0.gen_text_estatic_es AS gen_text_estatic_es_65,
t0.gen_text_estatic_en AS gen_text_estatic_en_66,
t0.gen_text_estatic_fr AS gen_text_estatic_fr_67,
t0.gen_text_estatic_pt AS gen_text_estatic_pt_68,
t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69,
t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70,
t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71,
t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72,
t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73,
t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74,
t0.gen_logo_ca AS gen_logo_ca_75,
t0.gen_logo_es AS gen_logo_es_76,
t0.gen_logo_en AS gen_logo_en_77,
t0.gen_logo_fr AS gen_logo_fr_78,
t0.gen_logo_pt AS gen_logo_pt_79,
t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80,
t0.gen_idioma_es_visible AS gen_idioma_es_visible_81,
t0.gen_idioma_en_visible AS gen_idioma_en_visible_82,
t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83,
t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84,
t0.gen_webcam_visible AS gen_webcam_visible_85,
t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86,
t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87,
t0.gen_prediccio_visible AS gen_prediccio_visible_88,
t0.gen_meteo_visible AS gen_meteo_visible_89,
t0.gen_pistes_visible AS gen_pistes_visible_90,
t0.gen_remuntadors_visible AS gen_remuntadors_visible_91,
t0.gen_desnivell_visible AS gen_desnivell_visible_92,
t0.gen_gruix_visible AS gen_gruix_visible_93,
t0.gen_qualitat_visible AS gen_qualitat_visible_94,
t0.gen_km_esquiables AS gen_km_esquiables_95,
t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96,
t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97,
t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98,
t0.gen_facebook_visible AS gen_facebook_visible_99,
t0.gen_twitter_visible AS gen_twitter_visible_100,
t0.gen_youtube_visible AS gen_youtube_visible_101,
t0.gen_instagram_visible AS gen_instagram_visible_102,
t0.gen_app_visible AS gen_app_visible_103,
t0.gen_blog_visible AS gen_blog_visible_104,
t0.gen_area_privada_visible AS gen_area_privada_visible_105,
t0.gen_comprar_visible AS gen_comprar_visible_106,
t0.gen_contacte_visible AS gen_contacte_visible_107,
t0.gen_masella_informa_ca AS gen_masella_informa_ca_108,
t0.gen_masella_informa_es AS gen_masella_informa_es_109,
t0.gen_masella_informa_en AS gen_masella_informa_en_110,
t0.gen_masella_informa_fr AS gen_masella_informa_fr_111,
t0.gen_masella_informa_pt AS gen_masella_informa_pt_112,
t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113,
t0.gen_instagram_informa_es AS gen_instagram_informa_es_114,
t0.gen_instagram_informa_en AS gen_instagram_informa_en_115,
t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116,
t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117,
t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118,
t0.gen_infonit_informa_es AS gen_infonit_informa_es_119,
t0.gen_infonit_informa_en AS gen_infonit_informa_en_120,
t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121,
t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122,
t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123,
t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124,
t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125,
t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126,
t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127,
t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128,
t0.gen_snowpark_dia AS gen_snowpark_dia_129,
t0.gen_snowpark_nit AS gen_snowpark_nit_130,
t0.gen_alp2500 AS gen_alp2500_131,
t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132,
t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133,
t0.gen_imatge_infoneu AS gen_imatge_infoneu_134,
t0.gen_imatge_infonit AS gen_imatge_infonit_135,
t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136,
t0.gen_previsio_nit_es AS gen_previsio_nit_es_137,
t0.gen_previsio_nit_en AS gen_previsio_nit_en_138,
t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139,
t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140,
t0.gen_infoneu_visible AS gen_infoneu_visible_141,
t0.gen_infonit_visible AS gen_infonit_visible_142,
t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143,
t0.gen_titol_video_central_es AS gen_titol_video_central_es_144,
t0.gen_titol_video_central_en AS gen_titol_video_central_en_145,
t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146,
t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147,
t0.gen_video_central_visible AS gen_video_central_visible_148,
t0.gen_numero_video_home AS gen_numero_video_home_149,
t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150,
t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151,
t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152,
t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153,
t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154,
t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155,
t0.gen_codi_descompte AS gen_codi_descompte_156,
t0.gen_masella_tv AS gen_masella_tv_157,
t0.gen_promocio_visible AS gen_promocio_visible_158,
t0.gen_horaris_ca AS gen_horaris_ca_159,
t0.gen_horaris_es AS gen_horaris_es_160,
t0.gen_horaris_en AS gen_horaris_en_161,
t0.gen_horaris_fr AS gen_horaris_fr_162,
t0.gen_horaris_pt AS gen_horaris_pt_163,
t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164,
t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165,
t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166,
t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167,
t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168,
t0.gen_botiga_abonament AS gen_botiga_abonament_169,
t0.gen_botiga_forfets AS gen_botiga_forfets_170,
t0.gen_botiga_promocions AS gen_botiga_promocions_171,
t0.gen_botiga_recarrega AS gen_botiga_recarrega_172,
t0.gen_botiga_classes AS gen_botiga_classes_173,
t0.gen_botiga_lloguer AS gen_botiga_lloguer_174,
t0.gen_video_slider_home AS gen_video_slider_home_175,
t0.gen_des_id AS gen_des_id_176
FROM
General t0
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0;
|
| 10 |
0.20 ms |
SELECT t0.con_id AS con_id_1, t0.con_data_alta AS con_data_alta_2, t0.con_nom AS con_nom_3, t0.con_cognoms AS con_cognoms_4, t0.con_cognom1 AS con_cognom1_5, t0.con_cognom2 AS con_cognom2_6, t0.con_direccio AS con_direccio_7, t0.con_cp AS con_cp_8, t0.con_poblacio AS con_poblacio_9, t0.con_email AS con_email_10, t0.con_data_naixement AS con_data_naixement_11, t0.con_telefon AS con_telefon_12, t0.con_clau AS con_clau_13, t0.con_id_aux AS con_id_aux_14, t0.con_dni AS con_dni_15, t0.con_nom_empresa AS con_nom_empresa_16, t0.con_nif_empresa AS con_nif_empresa_17, t0.con_direccio_empresa AS con_direccio_empresa_18, t0.con_cp_empresa AS con_cp_empresa_19, t0.con_poblacio_empresa AS con_poblacio_empresa_20, t0.con_provincia_empresa AS con_provincia_empresa_21, t0.con_comentaris AS con_comentaris_22, t0.con_historic AS con_historic_23, t0.con_abo_id AS con_abo_id_24, t0.con_familia_4i AS con_familia_4i_25, t0.con_origen_entrada AS con_origen_entrada_26, t0.con_resposta_4i AS con_resposta_4i_27, t0.con_wtp AS con_wtp_28, t0.con_tipus AS con_tipus_29, t0.con_foto AS con_foto_30, t0.con_document AS con_document_31, t0.con_resident AS con_resident_32, t0.con_familia_nombrosa AS con_familia_nombrosa_33, t0.con_modificat AS con_modificat_34, t0.con_customer_id_proj AS con_customer_id_proj_35, t0.con_customer_id_pos AS con_customer_id_pos_36, t0.con_customer_id_num AS con_customer_id_num_37, t0.con_company_proj_no AS con_company_proj_no_38, t0.con_company_pos_no AS con_company_pos_no_39, t0.con_company_num AS con_company_num_40, t0.con_customer_account_no AS con_customer_account_no_41, t0.con_validate_hash AS con_validate_hash_42, t0.con_resposta_dci4_connect AS con_resposta_dci4_connect_43, t0.con_validate_token AS con_validate_token_44, t0.con_descompte AS con_descompte_45, t0.con_pai_id AS con_pai_id_46, t0.usuari_id AS usuari_id_47 FROM Consumers t0 WHERE t0.con_id = ?
SELECT
t0.con_id AS con_id_1,
t0.con_data_alta AS con_data_alta_2,
t0.con_nom AS con_nom_3,
t0.con_cognoms AS con_cognoms_4,
t0.con_cognom1 AS con_cognom1_5,
t0.con_cognom2 AS con_cognom2_6,
t0.con_direccio AS con_direccio_7,
t0.con_cp AS con_cp_8,
t0.con_poblacio AS con_poblacio_9,
t0.con_email AS con_email_10,
t0.con_data_naixement AS con_data_naixement_11,
t0.con_telefon AS con_telefon_12,
t0.con_clau AS con_clau_13,
t0.con_id_aux AS con_id_aux_14,
t0.con_dni AS con_dni_15,
t0.con_nom_empresa AS con_nom_empresa_16,
t0.con_nif_empresa AS con_nif_empresa_17,
t0.con_direccio_empresa AS con_direccio_empresa_18,
t0.con_cp_empresa AS con_cp_empresa_19,
t0.con_poblacio_empresa AS con_poblacio_empresa_20,
t0.con_provincia_empresa AS con_provincia_empresa_21,
t0.con_comentaris AS con_comentaris_22,
t0.con_historic AS con_historic_23,
t0.con_abo_id AS con_abo_id_24,
t0.con_familia_4i AS con_familia_4i_25,
t0.con_origen_entrada AS con_origen_entrada_26,
t0.con_resposta_4i AS con_resposta_4i_27,
t0.con_wtp AS con_wtp_28,
t0.con_tipus AS con_tipus_29,
t0.con_foto AS con_foto_30,
t0.con_document AS con_document_31,
t0.con_resident AS con_resident_32,
t0.con_familia_nombrosa AS con_familia_nombrosa_33,
t0.con_modificat AS con_modificat_34,
t0.con_customer_id_proj AS con_customer_id_proj_35,
t0.con_customer_id_pos AS con_customer_id_pos_36,
t0.con_customer_id_num AS con_customer_id_num_37,
t0.con_company_proj_no AS con_company_proj_no_38,
t0.con_company_pos_no AS con_company_pos_no_39,
t0.con_company_num AS con_company_num_40,
t0.con_customer_account_no AS con_customer_account_no_41,
t0.con_validate_hash AS con_validate_hash_42,
t0.con_resposta_dci4_connect AS con_resposta_dci4_connect_43,
t0.con_validate_token AS con_validate_token_44,
t0.con_descompte AS con_descompte_45,
t0.con_pai_id AS con_pai_id_46,
t0.usuari_id AS usuari_id_47
FROM
Consumers t0
WHERE
t0.con_id = ?
SELECT t0.con_id AS con_id_1, t0.con_data_alta AS con_data_alta_2, t0.con_nom AS con_nom_3, t0.con_cognoms AS con_cognoms_4, t0.con_cognom1 AS con_cognom1_5, t0.con_cognom2 AS con_cognom2_6, t0.con_direccio AS con_direccio_7, t0.con_cp AS con_cp_8, t0.con_poblacio AS con_poblacio_9, t0.con_email AS con_email_10, t0.con_data_naixement AS con_data_naixement_11, t0.con_telefon AS con_telefon_12, t0.con_clau AS con_clau_13, t0.con_id_aux AS con_id_aux_14, t0.con_dni AS con_dni_15, t0.con_nom_empresa AS con_nom_empresa_16, t0.con_nif_empresa AS con_nif_empresa_17, t0.con_direccio_empresa AS con_direccio_empresa_18, t0.con_cp_empresa AS con_cp_empresa_19, t0.con_poblacio_empresa AS con_poblacio_empresa_20, t0.con_provincia_empresa AS con_provincia_empresa_21, t0.con_comentaris AS con_comentaris_22, t0.con_historic AS con_historic_23, t0.con_abo_id AS con_abo_id_24, t0.con_familia_4i AS con_familia_4i_25, t0.con_origen_entrada AS con_origen_entrada_26, t0.con_resposta_4i AS con_resposta_4i_27, t0.con_wtp AS con_wtp_28, t0.con_tipus AS con_tipus_29, t0.con_foto AS con_foto_30, t0.con_document AS con_document_31, t0.con_resident AS con_resident_32, t0.con_familia_nombrosa AS con_familia_nombrosa_33, t0.con_modificat AS con_modificat_34, t0.con_customer_id_proj AS con_customer_id_proj_35, t0.con_customer_id_pos AS con_customer_id_pos_36, t0.con_customer_id_num AS con_customer_id_num_37, t0.con_company_proj_no AS con_company_proj_no_38, t0.con_company_pos_no AS con_company_pos_no_39, t0.con_company_num AS con_company_num_40, t0.con_customer_account_no AS con_customer_account_no_41, t0.con_validate_hash AS con_validate_hash_42, t0.con_resposta_dci4_connect AS con_resposta_dci4_connect_43, t0.con_validate_token AS con_validate_token_44, t0.con_descompte AS con_descompte_45, t0.con_pai_id AS con_pai_id_46, t0.usuari_id AS usuari_id_47 FROM Consumers t0 WHERE t0.con_id = 20737;
|
| 11 |
0.16 ms |
SELECT t0.abo_id AS abo_id_1, t0.abo_familiar AS abo_familiar_2, t0.abo_estacio AS abo_estacio_3, t0.abo_suplement AS abo_suplement_4, t0.abo_sense_suplement AS abo_sense_suplement_5, t0.abo_ordre AS abo_ordre_6, t0.abo_nom_ca AS abo_nom_ca_7, t0.abo_nom_es AS abo_nom_es_8, t0.abo_nom_en AS abo_nom_en_9, t0.abo_nom_fr AS abo_nom_fr_10, t0.abo_nom_pt AS abo_nom_pt_11, t0.abo_nom_breu_ca AS abo_nom_breu_ca_12, t0.abo_nom_breu_es AS abo_nom_breu_es_13, t0.abo_nom_breu_en AS abo_nom_breu_en_14, t0.abo_nom_breu_fr AS abo_nom_breu_fr_15, t0.abo_nom_breu_pt AS abo_nom_breu_pt_16, t0.abo_actiu AS abo_actiu_17, t0.abo_data_inici AS abo_data_inici_18, t0.abo_data_fi AS abo_data_fi_19, t0.abo_empresa AS abo_empresa_20, t0.abo_nomes_tablet AS abo_nomes_tablet_21, t0.abo_id_aux AS abo_id_aux_22, t0.abo_club_esqui AS abo_club_esqui_23, t0.abo_nocturn AS abo_nocturn_24, t0.abo_devolucio_fianca AS abo_devolucio_fianca_25, t0.abo_esborrat AS abo_esborrat_26, t0.abo_promocio AS abo_promocio_27, t0.abo_data_inici_calendari AS abo_data_inici_calendari_28, t0.abo_data_fi_calendari AS abo_data_fi_calendari_29, t0.abo_tariff_sheet_id AS abo_tariff_sheet_id_30, t0.abo_tarifa_id AS abo_tarifa_id_31, t0.abo_tarifa_desc AS abo_tarifa_desc_32, t0.abo_section_id AS abo_section_id_33, t0.abo_section_desc AS abo_section_desc_34, t0.abo_ticket_type_id AS abo_ticket_type_id_35, t0.abo_ticket_type_desc AS abo_ticket_type_desc_36, t0.abo_pool_id AS abo_pool_id_37, t0.abo_pool_desc AS abo_pool_desc_38, t0.abo_person_type_id AS abo_person_type_id_39, t0.abo_person_type_desc AS abo_person_type_desc_40, t0.abo_person_type_general_id AS abo_person_type_general_id_41, t0.abo_person_type_general_desc AS abo_person_type_general_desc_42, t0.abo_preu AS abo_preu_43, t0.abo_contador_gratuit AS abo_contador_gratuit_44, t0.abo_atribut AS abo_atribut_45, t0.abo_clubs1 AS abo_clubs1_46, t0.abo_clubs2 AS abo_clubs2_47, t0.abo_clubs3 AS abo_clubs3_48, t0.abo_clubs4 AS abo_clubs4_49, t0.abo_alp2500 AS abo_alp2500_50, t0.abo_fires_oficina AS abo_fires_oficina_51, t0.abo_admin AS abo_admin_52, t0.abo_abo_id AS abo_abo_id_53, t0.abo_per_id AS abo_per_id_54 FROM Abonaments t0 WHERE t0.abo_id = ?
SELECT
t0.abo_id AS abo_id_1,
t0.abo_familiar AS abo_familiar_2,
t0.abo_estacio AS abo_estacio_3,
t0.abo_suplement AS abo_suplement_4,
t0.abo_sense_suplement AS abo_sense_suplement_5,
t0.abo_ordre AS abo_ordre_6,
t0.abo_nom_ca AS abo_nom_ca_7,
t0.abo_nom_es AS abo_nom_es_8,
t0.abo_nom_en AS abo_nom_en_9,
t0.abo_nom_fr AS abo_nom_fr_10,
t0.abo_nom_pt AS abo_nom_pt_11,
t0.abo_nom_breu_ca AS abo_nom_breu_ca_12,
t0.abo_nom_breu_es AS abo_nom_breu_es_13,
t0.abo_nom_breu_en AS abo_nom_breu_en_14,
t0.abo_nom_breu_fr AS abo_nom_breu_fr_15,
t0.abo_nom_breu_pt AS abo_nom_breu_pt_16,
t0.abo_actiu AS abo_actiu_17,
t0.abo_data_inici AS abo_data_inici_18,
t0.abo_data_fi AS abo_data_fi_19,
t0.abo_empresa AS abo_empresa_20,
t0.abo_nomes_tablet AS abo_nomes_tablet_21,
t0.abo_id_aux AS abo_id_aux_22,
t0.abo_club_esqui AS abo_club_esqui_23,
t0.abo_nocturn AS abo_nocturn_24,
t0.abo_devolucio_fianca AS abo_devolucio_fianca_25,
t0.abo_esborrat AS abo_esborrat_26,
t0.abo_promocio AS abo_promocio_27,
t0.abo_data_inici_calendari AS abo_data_inici_calendari_28,
t0.abo_data_fi_calendari AS abo_data_fi_calendari_29,
t0.abo_tariff_sheet_id AS abo_tariff_sheet_id_30,
t0.abo_tarifa_id AS abo_tarifa_id_31,
t0.abo_tarifa_desc AS abo_tarifa_desc_32,
t0.abo_section_id AS abo_section_id_33,
t0.abo_section_desc AS abo_section_desc_34,
t0.abo_ticket_type_id AS abo_ticket_type_id_35,
t0.abo_ticket_type_desc AS abo_ticket_type_desc_36,
t0.abo_pool_id AS abo_pool_id_37,
t0.abo_pool_desc AS abo_pool_desc_38,
t0.abo_person_type_id AS abo_person_type_id_39,
t0.abo_person_type_desc AS abo_person_type_desc_40,
t0.abo_person_type_general_id AS abo_person_type_general_id_41,
t0.abo_person_type_general_desc AS abo_person_type_general_desc_42,
t0.abo_preu AS abo_preu_43,
t0.abo_contador_gratuit AS abo_contador_gratuit_44,
t0.abo_atribut AS abo_atribut_45,
t0.abo_clubs1 AS abo_clubs1_46,
t0.abo_clubs2 AS abo_clubs2_47,
t0.abo_clubs3 AS abo_clubs3_48,
t0.abo_clubs4 AS abo_clubs4_49,
t0.abo_alp2500 AS abo_alp2500_50,
t0.abo_fires_oficina AS abo_fires_oficina_51,
t0.abo_admin AS abo_admin_52,
t0.abo_abo_id AS abo_abo_id_53,
t0.abo_per_id AS abo_per_id_54
FROM
Abonaments t0
WHERE
t0.abo_id = ?
SELECT t0.abo_id AS abo_id_1, t0.abo_familiar AS abo_familiar_2, t0.abo_estacio AS abo_estacio_3, t0.abo_suplement AS abo_suplement_4, t0.abo_sense_suplement AS abo_sense_suplement_5, t0.abo_ordre AS abo_ordre_6, t0.abo_nom_ca AS abo_nom_ca_7, t0.abo_nom_es AS abo_nom_es_8, t0.abo_nom_en AS abo_nom_en_9, t0.abo_nom_fr AS abo_nom_fr_10, t0.abo_nom_pt AS abo_nom_pt_11, t0.abo_nom_breu_ca AS abo_nom_breu_ca_12, t0.abo_nom_breu_es AS abo_nom_breu_es_13, t0.abo_nom_breu_en AS abo_nom_breu_en_14, t0.abo_nom_breu_fr AS abo_nom_breu_fr_15, t0.abo_nom_breu_pt AS abo_nom_breu_pt_16, t0.abo_actiu AS abo_actiu_17, t0.abo_data_inici AS abo_data_inici_18, t0.abo_data_fi AS abo_data_fi_19, t0.abo_empresa AS abo_empresa_20, t0.abo_nomes_tablet AS abo_nomes_tablet_21, t0.abo_id_aux AS abo_id_aux_22, t0.abo_club_esqui AS abo_club_esqui_23, t0.abo_nocturn AS abo_nocturn_24, t0.abo_devolucio_fianca AS abo_devolucio_fianca_25, t0.abo_esborrat AS abo_esborrat_26, t0.abo_promocio AS abo_promocio_27, t0.abo_data_inici_calendari AS abo_data_inici_calendari_28, t0.abo_data_fi_calendari AS abo_data_fi_calendari_29, t0.abo_tariff_sheet_id AS abo_tariff_sheet_id_30, t0.abo_tarifa_id AS abo_tarifa_id_31, t0.abo_tarifa_desc AS abo_tarifa_desc_32, t0.abo_section_id AS abo_section_id_33, t0.abo_section_desc AS abo_section_desc_34, t0.abo_ticket_type_id AS abo_ticket_type_id_35, t0.abo_ticket_type_desc AS abo_ticket_type_desc_36, t0.abo_pool_id AS abo_pool_id_37, t0.abo_pool_desc AS abo_pool_desc_38, t0.abo_person_type_id AS abo_person_type_id_39, t0.abo_person_type_desc AS abo_person_type_desc_40, t0.abo_person_type_general_id AS abo_person_type_general_id_41, t0.abo_person_type_general_desc AS abo_person_type_general_desc_42, t0.abo_preu AS abo_preu_43, t0.abo_contador_gratuit AS abo_contador_gratuit_44, t0.abo_atribut AS abo_atribut_45, t0.abo_clubs1 AS abo_clubs1_46, t0.abo_clubs2 AS abo_clubs2_47, t0.abo_clubs3 AS abo_clubs3_48, t0.abo_clubs4 AS abo_clubs4_49, t0.abo_alp2500 AS abo_alp2500_50, t0.abo_fires_oficina AS abo_fires_oficina_51, t0.abo_admin AS abo_admin_52, t0.abo_abo_id AS abo_abo_id_53, t0.abo_per_id AS abo_per_id_54 FROM Abonaments t0 WHERE t0.abo_id = 2043;
|
| 12 |
0.46 ms |
SELECT t0.con_id AS con_id_1, t0.con_data_alta AS con_data_alta_2, t0.con_nom AS con_nom_3, t0.con_cognoms AS con_cognoms_4, t0.con_cognom1 AS con_cognom1_5, t0.con_cognom2 AS con_cognom2_6, t0.con_direccio AS con_direccio_7, t0.con_cp AS con_cp_8, t0.con_poblacio AS con_poblacio_9, t0.con_email AS con_email_10, t0.con_data_naixement AS con_data_naixement_11, t0.con_telefon AS con_telefon_12, t0.con_clau AS con_clau_13, t0.con_id_aux AS con_id_aux_14, t0.con_dni AS con_dni_15, t0.con_nom_empresa AS con_nom_empresa_16, t0.con_nif_empresa AS con_nif_empresa_17, t0.con_direccio_empresa AS con_direccio_empresa_18, t0.con_cp_empresa AS con_cp_empresa_19, t0.con_poblacio_empresa AS con_poblacio_empresa_20, t0.con_provincia_empresa AS con_provincia_empresa_21, t0.con_comentaris AS con_comentaris_22, t0.con_historic AS con_historic_23, t0.con_abo_id AS con_abo_id_24, t0.con_familia_4i AS con_familia_4i_25, t0.con_origen_entrada AS con_origen_entrada_26, t0.con_resposta_4i AS con_resposta_4i_27, t0.con_wtp AS con_wtp_28, t0.con_tipus AS con_tipus_29, t0.con_foto AS con_foto_30, t0.con_document AS con_document_31, t0.con_resident AS con_resident_32, t0.con_familia_nombrosa AS con_familia_nombrosa_33, t0.con_modificat AS con_modificat_34, t0.con_customer_id_proj AS con_customer_id_proj_35, t0.con_customer_id_pos AS con_customer_id_pos_36, t0.con_customer_id_num AS con_customer_id_num_37, t0.con_company_proj_no AS con_company_proj_no_38, t0.con_company_pos_no AS con_company_pos_no_39, t0.con_company_num AS con_company_num_40, t0.con_customer_account_no AS con_customer_account_no_41, t0.con_validate_hash AS con_validate_hash_42, t0.con_resposta_dci4_connect AS con_resposta_dci4_connect_43, t0.con_validate_token AS con_validate_token_44, t0.con_descompte AS con_descompte_45, t0.con_pai_id AS con_pai_id_46, t0.usuari_id AS usuari_id_47 FROM Consumers t0 WHERE t0.con_id = ?
SELECT
t0.con_id AS con_id_1,
t0.con_data_alta AS con_data_alta_2,
t0.con_nom AS con_nom_3,
t0.con_cognoms AS con_cognoms_4,
t0.con_cognom1 AS con_cognom1_5,
t0.con_cognom2 AS con_cognom2_6,
t0.con_direccio AS con_direccio_7,
t0.con_cp AS con_cp_8,
t0.con_poblacio AS con_poblacio_9,
t0.con_email AS con_email_10,
t0.con_data_naixement AS con_data_naixement_11,
t0.con_telefon AS con_telefon_12,
t0.con_clau AS con_clau_13,
t0.con_id_aux AS con_id_aux_14,
t0.con_dni AS con_dni_15,
t0.con_nom_empresa AS con_nom_empresa_16,
t0.con_nif_empresa AS con_nif_empresa_17,
t0.con_direccio_empresa AS con_direccio_empresa_18,
t0.con_cp_empresa AS con_cp_empresa_19,
t0.con_poblacio_empresa AS con_poblacio_empresa_20,
t0.con_provincia_empresa AS con_provincia_empresa_21,
t0.con_comentaris AS con_comentaris_22,
t0.con_historic AS con_historic_23,
t0.con_abo_id AS con_abo_id_24,
t0.con_familia_4i AS con_familia_4i_25,
t0.con_origen_entrada AS con_origen_entrada_26,
t0.con_resposta_4i AS con_resposta_4i_27,
t0.con_wtp AS con_wtp_28,
t0.con_tipus AS con_tipus_29,
t0.con_foto AS con_foto_30,
t0.con_document AS con_document_31,
t0.con_resident AS con_resident_32,
t0.con_familia_nombrosa AS con_familia_nombrosa_33,
t0.con_modificat AS con_modificat_34,
t0.con_customer_id_proj AS con_customer_id_proj_35,
t0.con_customer_id_pos AS con_customer_id_pos_36,
t0.con_customer_id_num AS con_customer_id_num_37,
t0.con_company_proj_no AS con_company_proj_no_38,
t0.con_company_pos_no AS con_company_pos_no_39,
t0.con_company_num AS con_company_num_40,
t0.con_customer_account_no AS con_customer_account_no_41,
t0.con_validate_hash AS con_validate_hash_42,
t0.con_resposta_dci4_connect AS con_resposta_dci4_connect_43,
t0.con_validate_token AS con_validate_token_44,
t0.con_descompte AS con_descompte_45,
t0.con_pai_id AS con_pai_id_46,
t0.usuari_id AS usuari_id_47
FROM
Consumers t0
WHERE
t0.con_id = ?
SELECT t0.con_id AS con_id_1, t0.con_data_alta AS con_data_alta_2, t0.con_nom AS con_nom_3, t0.con_cognoms AS con_cognoms_4, t0.con_cognom1 AS con_cognom1_5, t0.con_cognom2 AS con_cognom2_6, t0.con_direccio AS con_direccio_7, t0.con_cp AS con_cp_8, t0.con_poblacio AS con_poblacio_9, t0.con_email AS con_email_10, t0.con_data_naixement AS con_data_naixement_11, t0.con_telefon AS con_telefon_12, t0.con_clau AS con_clau_13, t0.con_id_aux AS con_id_aux_14, t0.con_dni AS con_dni_15, t0.con_nom_empresa AS con_nom_empresa_16, t0.con_nif_empresa AS con_nif_empresa_17, t0.con_direccio_empresa AS con_direccio_empresa_18, t0.con_cp_empresa AS con_cp_empresa_19, t0.con_poblacio_empresa AS con_poblacio_empresa_20, t0.con_provincia_empresa AS con_provincia_empresa_21, t0.con_comentaris AS con_comentaris_22, t0.con_historic AS con_historic_23, t0.con_abo_id AS con_abo_id_24, t0.con_familia_4i AS con_familia_4i_25, t0.con_origen_entrada AS con_origen_entrada_26, t0.con_resposta_4i AS con_resposta_4i_27, t0.con_wtp AS con_wtp_28, t0.con_tipus AS con_tipus_29, t0.con_foto AS con_foto_30, t0.con_document AS con_document_31, t0.con_resident AS con_resident_32, t0.con_familia_nombrosa AS con_familia_nombrosa_33, t0.con_modificat AS con_modificat_34, t0.con_customer_id_proj AS con_customer_id_proj_35, t0.con_customer_id_pos AS con_customer_id_pos_36, t0.con_customer_id_num AS con_customer_id_num_37, t0.con_company_proj_no AS con_company_proj_no_38, t0.con_company_pos_no AS con_company_pos_no_39, t0.con_company_num AS con_company_num_40, t0.con_customer_account_no AS con_customer_account_no_41, t0.con_validate_hash AS con_validate_hash_42, t0.con_resposta_dci4_connect AS con_resposta_dci4_connect_43, t0.con_validate_token AS con_validate_token_44, t0.con_descompte AS con_descompte_45, t0.con_pai_id AS con_pai_id_46, t0.usuari_id AS usuari_id_47 FROM Consumers t0 WHERE t0.con_id = 29231;
|