SELECT i.item_id,i.creation_cat,i.`start`,i.einde,i.titel,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=2 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=2 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_2_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=2 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_2_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=1 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=1 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_1_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=1 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_1_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=97 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_97,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=97 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_97_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=97 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_97_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=13 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_13,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=13 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_13_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=13 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_13_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=34 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_34,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=34 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_34_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=34 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_34_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_56,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_56_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_56_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=57 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_57,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=57 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_57_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=57 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_57_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=14 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_14,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=14 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_14_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=14 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_14_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=35 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_35,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=35 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_35_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=35 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_35_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=15 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_15,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=15 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_15_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=15 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_15_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=16 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_16,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=16 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_16_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=16 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_16_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=17 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_17,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=17 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_17_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=17 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_17_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=89 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_89,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=89 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_89_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=89 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_89_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=18 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_18,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=18 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_18_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=18 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_18_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=19 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_19,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=19 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_19_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=19 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_19_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=20 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_20,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=20 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_20_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=20 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_20_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=21 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_21,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=21 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_21_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=21 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_21_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=22 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_22,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=22 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_22_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=22 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_22_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=23 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_23,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=23 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_23_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=23 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_23_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=24 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_24,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=24 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_24_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=24 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_24_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=25 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_25,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=25 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_25_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=25 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_25_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=26 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_26,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=26 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_26_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=26 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_26_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=27 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_27,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=27 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_27_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=27 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_27_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=28 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_28,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=28 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_28_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=28 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_28_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=29 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_29,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=29 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_29_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=29 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_29_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=54 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_54,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=54 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_54_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=54 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_54_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=30 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_30,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=30 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_30_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=30 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_30_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=31 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_31,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=31 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_31_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=31 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_31_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=32 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_32,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=32 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_32_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=32 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_32_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=33 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_33,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=33 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_33_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=33 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_33_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=58 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_58,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=58 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_58_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=58 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_58_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=36 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_36,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=36 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_36_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=36 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_36_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=37 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_37,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=37 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_37_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=37 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_37_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=48 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_48,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=48 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_48_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=48 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_48_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=49 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_49,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=49 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_49_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=49 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_49_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=50 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_50,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=50 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_50_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=50 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_50_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=51 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_51,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=51 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_51_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=51 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_51_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=52 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_52,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=52 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_52_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=52 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_52_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=69 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_69,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=69 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_69_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=69 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_69_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=74 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_74,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=74 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_74_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=74 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_74_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=76 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_76,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=76 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_76_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=76 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_76_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=78 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_78,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=78 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_78_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=78 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_78_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=75 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_75,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=75 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_75_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=75 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_75_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=59 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_59,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=59 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_59_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=59 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_59_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=61 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_61,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=61 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_61_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=61 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_61_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=62 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_62,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=62 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_62_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=62 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_62_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=63 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_63,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=63 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_63_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=63 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_63_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=64 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_64,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=64 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_64_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=64 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_64_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=65 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_65,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=65 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_65_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=65 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_65_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=66 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_66,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=66 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_66_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=66 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_66_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=68 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_68,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=68 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_68_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=68 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_68_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=80 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_80,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=80 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_80_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=80 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_80_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=67 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_67,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=67 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_67_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=67 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_67_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=71 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_71,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=71 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_71_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=71 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_71_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=72 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_72,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=72 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_72_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=72 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_72_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=73 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_73,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=73 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_73_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=73 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_73_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=79 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_79,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=79 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_79_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=79 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_79_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=90 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_90,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=90 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_90_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=90 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_90_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=96 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_96,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=96 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_96_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=96 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_96_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=103 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_103,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=103 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_103_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=103 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_103_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=98 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_98,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=98 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_98_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=98 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_98_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=134 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_134,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=134 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_134_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=134 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_134_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=154 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_154,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=154 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_154_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=154 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_154_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=173 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_173,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=173 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_173_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=173 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_173_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=174 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_174,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=174 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_174_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=174 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_174_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=53 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_53,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=53 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_53_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=53 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_53_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=135 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_135,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=135 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_135_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=135 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_135_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=180 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_180,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=180 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_180_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=180 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_180_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=181 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_181,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=181 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_181_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=181 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_181_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=182 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_182,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=182 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_182_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=182 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_182_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=183 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_183,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=183 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_183_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=183 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_183_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=184 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_184,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=184 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_184_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=184 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_184_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=185 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_185,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=185 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_185_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=185 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_185_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=186 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_186,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=186 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_186_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=186 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_186_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=187 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_187,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=187 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_187_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=187 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_187_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=188 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_188,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=188 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_188_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=188 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_188_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=189 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_189,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=189 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_189_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=189 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_189_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=190 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_190,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=190 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_190_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=190 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_190_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=191 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_191,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=191 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_191_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=191 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_191_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=192 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_192,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=192 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_192_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=192 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_192_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=193 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_193,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=193 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_193_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=193 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_193_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=195 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_195,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=195 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_195_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=195 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_195_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=196 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_196,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=196 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_196_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=196 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_196_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=197 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_197,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=197 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_197_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=197 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_197_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=198 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_198,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=198 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_198_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=198 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_198_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=199 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_199,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=199 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_199_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=199 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_199_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=200 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_200,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=200 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_200_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=200 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_200_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=201 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_201,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=201 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_201_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=201 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_201_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=202 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_202,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=202 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_202_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=202 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_202_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=203 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_203,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=203 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_203_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=203 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_203_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=204 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_204,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=204 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_204_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=204 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_204_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=205 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_205,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=205 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_205_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=205 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_205_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=206 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_206,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=206 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_206_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=206 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_206_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_166,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_166_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_166_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=217 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_217,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=217 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_217_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=217 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_217_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=106 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_106,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=106 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_106_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=106 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_106_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=110 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_110,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=110 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_110_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=110 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_110_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=112 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_112,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=112 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_112_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=112 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_112_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=107 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_107,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=107 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_107_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=107 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_107_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=108 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_108,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=108 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_108_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=108 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_108_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=109 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_109,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=109 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_109_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=109 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_109_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=218 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_218,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=218 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_218_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=218 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_218_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_56,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_56_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_56_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=160 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_160,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=160 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_160_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=160 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_160_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=161 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_161,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=161 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_161_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=161 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_161_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=163 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_163,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=163 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_163_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=163 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_163_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=164 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_164,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=164 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_164_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=164 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_164_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=165 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_165,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=165 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_165_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=165 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_165_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_166,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_166_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=1 AND fk_web_countries=2) AS data_166_1_2 FROM `data_item` i WHERE item_id=12652 - error: Got a packet bigger than 'max_allowed_packet' bytes