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=2 AND fk_web_countries IS NULL) AS data_2_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=2 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_2_2_4,(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=2 AND fk_web_countries IS NULL) AS data_1_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=1 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_1_2_4,(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=2 AND fk_web_countries IS NULL) AS data_97_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=97 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_97_2_4,(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=2 AND fk_web_countries IS NULL) AS data_13_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=13 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_13_2_4,(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=2 AND fk_web_countries IS NULL) AS data_34_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=34 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_34_2_4,(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=2 AND fk_web_countries IS NULL) AS data_56_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_56_2_4,(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=2 AND fk_web_countries IS NULL) AS data_57_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=57 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_57_2_4,(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=2 AND fk_web_countries IS NULL) AS data_14_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=14 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_14_2_4,(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=2 AND fk_web_countries IS NULL) AS data_35_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=35 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_35_2_4,(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=2 AND fk_web_countries IS NULL) AS data_15_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=15 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_15_2_4,(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=2 AND fk_web_countries IS NULL) AS data_16_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=16 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_16_2_4,(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=2 AND fk_web_countries IS NULL) AS data_17_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=17 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_17_2_4,(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=2 AND fk_web_countries IS NULL) AS data_89_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=89 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_89_2_4,(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=2 AND fk_web_countries IS NULL) AS data_18_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=18 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_18_2_4,(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=2 AND fk_web_countries IS NULL) AS data_19_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=19 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_19_2_4,(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=2 AND fk_web_countries IS NULL) AS data_20_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=20 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_20_2_4,(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=2 AND fk_web_countries IS NULL) AS data_21_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=21 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_21_2_4,(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=2 AND fk_web_countries IS NULL) AS data_22_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=22 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_22_2_4,(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=2 AND fk_web_countries IS NULL) AS data_23_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=23 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_23_2_4,(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=2 AND fk_web_countries IS NULL) AS data_24_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=24 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_24_2_4,(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=2 AND fk_web_countries IS NULL) AS data_25_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=25 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_25_2_4,(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=2 AND fk_web_countries IS NULL) AS data_26_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=26 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_26_2_4,(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=2 AND fk_web_countries IS NULL) AS data_27_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=27 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_27_2_4,(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=2 AND fk_web_countries IS NULL) AS data_28_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=28 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_28_2_4,(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=2 AND fk_web_countries IS NULL) AS data_29_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=29 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_29_2_4,(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=2 AND fk_web_countries IS NULL) AS data_54_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=54 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_54_2_4,(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=2 AND fk_web_countries IS NULL) AS data_30_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=30 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_30_2_4,(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=2 AND fk_web_countries IS NULL) AS data_31_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=31 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_31_2_4,(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=2 AND fk_web_countries IS NULL) AS data_32_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=32 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_32_2_4,(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=2 AND fk_web_countries IS NULL) AS data_33_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=33 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_33_2_4,(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=2 AND fk_web_countries IS NULL) AS data_58_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=58 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_58_2_4,(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=2 AND fk_web_countries IS NULL) AS data_36_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=36 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_36_2_4,(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=2 AND fk_web_countries IS NULL) AS data_37_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=37 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_37_2_4,(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=2 AND fk_web_countries IS NULL) AS data_48_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=48 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_48_2_4,(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=2 AND fk_web_countries IS NULL) AS data_49_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=49 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_49_2_4,(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=2 AND fk_web_countries IS NULL) AS data_50_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=50 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_50_2_4,(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=2 AND fk_web_countries IS NULL) AS data_51_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=51 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_51_2_4,(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=2 AND fk_web_countries IS NULL) AS data_52_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=52 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_52_2_4,(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=2 AND fk_web_countries IS NULL) AS data_69_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=69 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_69_2_4,(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=2 AND fk_web_countries IS NULL) AS data_74_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=74 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_74_2_4,(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=2 AND fk_web_countries IS NULL) AS data_76_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=76 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_76_2_4,(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=2 AND fk_web_countries IS NULL) AS data_78_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=78 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_78_2_4,(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=2 AND fk_web_countries IS NULL) AS data_75_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=75 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_75_2_4,(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=2 AND fk_web_countries IS NULL) AS data_59_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=59 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_59_2_4,(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=2 AND fk_web_countries IS NULL) AS data_61_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=61 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_61_2_4,(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=2 AND fk_web_countries IS NULL) AS data_62_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=62 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_62_2_4,(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=2 AND fk_web_countries IS NULL) AS data_63_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=63 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_63_2_4,(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=2 AND fk_web_countries IS NULL) AS data_64_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=64 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_64_2_4,(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=2 AND fk_web_countries IS NULL) AS data_65_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=65 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_65_2_4,(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=2 AND fk_web_countries IS NULL) AS data_66_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=66 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_66_2_4,(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=2 AND fk_web_countries IS NULL) AS data_68_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=68 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_68_2_4,(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=2 AND fk_web_countries IS NULL) AS data_80_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=80 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_80_2_4,(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=2 AND fk_web_countries IS NULL) AS data_67_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=67 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_67_2_4,(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=2 AND fk_web_countries IS NULL) AS data_71_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=71 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_71_2_4,(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=2 AND fk_web_countries IS NULL) AS data_72_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=72 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_72_2_4,(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=2 AND fk_web_countries IS NULL) AS data_73_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=73 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_73_2_4,(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=2 AND fk_web_countries IS NULL) AS data_79_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=79 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_79_2_4,(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=2 AND fk_web_countries IS NULL) AS data_90_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=90 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_90_2_4,(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=2 AND fk_web_countries IS NULL) AS data_96_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=96 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_96_2_4,(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=2 AND fk_web_countries IS NULL) AS data_103_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=103 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_103_2_4,(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=2 AND fk_web_countries IS NULL) AS data_98_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=98 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_98_2_4,(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=2 AND fk_web_countries IS NULL) AS data_134_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=134 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_134_2_4,(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=2 AND fk_web_countries IS NULL) AS data_154_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=154 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_154_2_4,(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=2 AND fk_web_countries IS NULL) AS data_173_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=173 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_173_2_4,(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=2 AND fk_web_countries IS NULL) AS data_174_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=174 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_174_2_4,(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=2 AND fk_web_countries IS NULL) AS data_53_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=53 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_53_2_4,(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=2 AND fk_web_countries IS NULL) AS data_135_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=135 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_135_2_4,(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=2 AND fk_web_countries IS NULL) AS data_180_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=180 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_180_2_4,(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=2 AND fk_web_countries IS NULL) AS data_181_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=181 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_181_2_4,(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=2 AND fk_web_countries IS NULL) AS data_182_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=182 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_182_2_4,(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=2 AND fk_web_countries IS NULL) AS data_183_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=183 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_183_2_4,(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=2 AND fk_web_countries IS NULL) AS data_184_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=184 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_184_2_4,(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=2 AND fk_web_countries IS NULL) AS data_185_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=185 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_185_2_4,(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=2 AND fk_web_countries IS NULL) AS data_186_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=186 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_186_2_4,(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=2 AND fk_web_countries IS NULL) AS data_187_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=187 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_187_2_4,(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=2 AND fk_web_countries IS NULL) AS data_188_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=188 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_188_2_4,(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=2 AND fk_web_countries IS NULL) AS data_189_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=189 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_189_2_4,(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=2 AND fk_web_countries IS NULL) AS data_190_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=190 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_190_2_4,(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=2 AND fk_web_countries IS NULL) AS data_191_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=191 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_191_2_4,(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=2 AND fk_web_countries IS NULL) AS data_192_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=192 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_192_2_4,(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=2 AND fk_web_countries IS NULL) AS data_193_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=193 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_193_2_4,(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=2 AND fk_web_countries IS NULL) AS data_195_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=195 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_195_2_4,(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=2 AND fk_web_countries IS NULL) AS data_196_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=196 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_196_2_4,(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=2 AND fk_web_countries IS NULL) AS data_197_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=197 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_197_2_4,(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=2 AND fk_web_countries IS NULL) AS data_198_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=198 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_198_2_4,(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=2 AND fk_web_countries IS NULL) AS data_199_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=199 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_199_2_4,(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=2 AND fk_web_countries IS NULL) AS data_200_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=200 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_200_2_4,(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=2 AND fk_web_countries IS NULL) AS data_201_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=201 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_201_2_4,(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=2 AND fk_web_countries IS NULL) AS data_202_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=202 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_202_2_4,(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=2 AND fk_web_countries IS NULL) AS data_203_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=203 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_203_2_4,(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=2 AND fk_web_countries IS NULL) AS data_204_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=204 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_204_2_4,(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=2 AND fk_web_countries IS NULL) AS data_205_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=205 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_205_2_4,(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=2 AND fk_web_countries IS NULL) AS data_206_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=206 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_206_2_4,(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=2 AND fk_web_countries IS NULL) AS data_166_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_166_2_4,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=105 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_105,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=105 AND fk_app_language_codes=2 AND fk_web_countries IS NULL) AS data_105_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=105 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_105_2_4,(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=2 AND fk_web_countries IS NULL) AS data_217_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=217 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_217_2_4,(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=2 AND fk_web_countries IS NULL) AS data_106_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=106 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_106_2_4,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=111 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_111,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=111 AND fk_app_language_codes=2 AND fk_web_countries IS NULL) AS data_111_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=111 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_111_2_4,(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=2 AND fk_web_countries IS NULL) AS data_110_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=110 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_110_2_4,(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=2 AND fk_web_countries IS NULL) AS data_112_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=112 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_112_2_4,(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=2 AND fk_web_countries IS NULL) AS data_107_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=107 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_107_2_4,(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=2 AND fk_web_countries IS NULL) AS data_108_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=108 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_108_2_4,(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=2 AND fk_web_countries IS NULL) AS data_109_2,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=109 AND fk_app_language_codes=2 AND fk_web_countries=4) AS data_109_2_4 FROM `data_item` i WHERE item_id=3711 - error: Got a packet bigger than 'max_allowed_packet' bytes