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=7 AND fk_web_countries IS NULL) AS data_2_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=2 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_2_7_23,(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=7 AND fk_web_countries IS NULL) AS data_1_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=1 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_1_7_23,(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=7 AND fk_web_countries IS NULL) AS data_97_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=97 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_97_7_23,(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=7 AND fk_web_countries IS NULL) AS data_13_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=13 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_13_7_23,(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=7 AND fk_web_countries IS NULL) AS data_34_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=34 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_34_7_23,(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=7 AND fk_web_countries IS NULL) AS data_56_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_56_7_23,(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=7 AND fk_web_countries IS NULL) AS data_57_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=57 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_57_7_23,(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=7 AND fk_web_countries IS NULL) AS data_14_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=14 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_14_7_23,(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=7 AND fk_web_countries IS NULL) AS data_35_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=35 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_35_7_23,(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=7 AND fk_web_countries IS NULL) AS data_15_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=15 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_15_7_23,(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=7 AND fk_web_countries IS NULL) AS data_16_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=16 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_16_7_23,(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=7 AND fk_web_countries IS NULL) AS data_17_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=17 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_17_7_23,(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=7 AND fk_web_countries IS NULL) AS data_89_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=89 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_89_7_23,(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=7 AND fk_web_countries IS NULL) AS data_18_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=18 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_18_7_23,(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=7 AND fk_web_countries IS NULL) AS data_19_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=19 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_19_7_23,(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=7 AND fk_web_countries IS NULL) AS data_20_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=20 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_20_7_23,(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=7 AND fk_web_countries IS NULL) AS data_21_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=21 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_21_7_23,(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=7 AND fk_web_countries IS NULL) AS data_22_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=22 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_22_7_23,(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=7 AND fk_web_countries IS NULL) AS data_23_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=23 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_23_7_23,(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=7 AND fk_web_countries IS NULL) AS data_24_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=24 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_24_7_23,(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=7 AND fk_web_countries IS NULL) AS data_25_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=25 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_25_7_23,(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=7 AND fk_web_countries IS NULL) AS data_26_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=26 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_26_7_23,(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=7 AND fk_web_countries IS NULL) AS data_27_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=27 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_27_7_23,(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=7 AND fk_web_countries IS NULL) AS data_28_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=28 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_28_7_23,(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=7 AND fk_web_countries IS NULL) AS data_29_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=29 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_29_7_23,(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=7 AND fk_web_countries IS NULL) AS data_54_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=54 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_54_7_23,(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=7 AND fk_web_countries IS NULL) AS data_30_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=30 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_30_7_23,(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=7 AND fk_web_countries IS NULL) AS data_31_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=31 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_31_7_23,(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=7 AND fk_web_countries IS NULL) AS data_32_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=32 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_32_7_23,(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=7 AND fk_web_countries IS NULL) AS data_33_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=33 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_33_7_23,(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=7 AND fk_web_countries IS NULL) AS data_58_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=58 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_58_7_23,(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=7 AND fk_web_countries IS NULL) AS data_36_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=36 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_36_7_23,(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=7 AND fk_web_countries IS NULL) AS data_37_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=37 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_37_7_23,(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=7 AND fk_web_countries IS NULL) AS data_48_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=48 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_48_7_23,(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=7 AND fk_web_countries IS NULL) AS data_49_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=49 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_49_7_23,(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=7 AND fk_web_countries IS NULL) AS data_50_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=50 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_50_7_23,(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=7 AND fk_web_countries IS NULL) AS data_51_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=51 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_51_7_23,(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=7 AND fk_web_countries IS NULL) AS data_52_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=52 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_52_7_23,(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=7 AND fk_web_countries IS NULL) AS data_69_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=69 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_69_7_23,(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=7 AND fk_web_countries IS NULL) AS data_74_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=74 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_74_7_23,(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=7 AND fk_web_countries IS NULL) AS data_76_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=76 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_76_7_23,(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=7 AND fk_web_countries IS NULL) AS data_78_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=78 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_78_7_23,(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=7 AND fk_web_countries IS NULL) AS data_75_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=75 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_75_7_23,(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=7 AND fk_web_countries IS NULL) AS data_59_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=59 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_59_7_23,(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=7 AND fk_web_countries IS NULL) AS data_61_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=61 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_61_7_23,(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=7 AND fk_web_countries IS NULL) AS data_62_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=62 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_62_7_23,(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=7 AND fk_web_countries IS NULL) AS data_63_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=63 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_63_7_23,(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=7 AND fk_web_countries IS NULL) AS data_64_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=64 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_64_7_23,(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=7 AND fk_web_countries IS NULL) AS data_65_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=65 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_65_7_23,(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=7 AND fk_web_countries IS NULL) AS data_66_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=66 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_66_7_23,(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=7 AND fk_web_countries IS NULL) AS data_68_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=68 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_68_7_23,(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=7 AND fk_web_countries IS NULL) AS data_80_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=80 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_80_7_23,(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=7 AND fk_web_countries IS NULL) AS data_67_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=67 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_67_7_23,(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=7 AND fk_web_countries IS NULL) AS data_71_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=71 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_71_7_23,(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=7 AND fk_web_countries IS NULL) AS data_72_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=72 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_72_7_23,(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=7 AND fk_web_countries IS NULL) AS data_73_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=73 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_73_7_23,(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=7 AND fk_web_countries IS NULL) AS data_79_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=79 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_79_7_23,(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=7 AND fk_web_countries IS NULL) AS data_90_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=90 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_90_7_23,(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=7 AND fk_web_countries IS NULL) AS data_96_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=96 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_96_7_23,(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=7 AND fk_web_countries IS NULL) AS data_103_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=103 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_103_7_23,(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=7 AND fk_web_countries IS NULL) AS data_98_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=98 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_98_7_23,(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=7 AND fk_web_countries IS NULL) AS data_134_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=134 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_134_7_23,(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=7 AND fk_web_countries IS NULL) AS data_154_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=154 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_154_7_23,(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=7 AND fk_web_countries IS NULL) AS data_173_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=173 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_173_7_23,(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=7 AND fk_web_countries IS NULL) AS data_174_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=174 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_174_7_23,(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=7 AND fk_web_countries IS NULL) AS data_53_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=53 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_53_7_23,(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=7 AND fk_web_countries IS NULL) AS data_166_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_166_7_23,(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=7 AND fk_web_countries IS NULL) AS data_180_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=180 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_180_7_23,(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=7 AND fk_web_countries IS NULL) AS data_186_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=186 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_186_7_23,(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=7 AND fk_web_countries IS NULL) AS data_187_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=187 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_187_7_23,(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=7 AND fk_web_countries IS NULL) AS data_193_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=193 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_193_7_23,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=194 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_194,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=194 AND fk_app_language_codes=7 AND fk_web_countries IS NULL) AS data_194_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=194 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_194_7_23,(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=7 AND fk_web_countries IS NULL) AS data_196_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=196 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_196_7_23,(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=7 AND fk_web_countries IS NULL) AS data_197_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=197 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_197_7_23,(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=7 AND fk_web_countries IS NULL) AS data_198_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=198 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_198_7_23,(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=7 AND fk_web_countries IS NULL) AS data_200_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=200 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_200_7_23,(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=7 AND fk_web_countries IS NULL) AS data_201_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=201 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_201_7_23,(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=7 AND fk_web_countries IS NULL) AS data_203_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=203 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_203_7_23,(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=7 AND fk_web_countries IS NULL) AS data_204_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=204 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_204_7_23,(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=7 AND fk_web_countries IS NULL) AS data_205_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=205 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_205_7_23,(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=7 AND fk_web_countries IS NULL) AS data_206_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=206 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_206_7_23,(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=7 AND fk_web_countries IS NULL) AS data_181_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=181 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_181_7_23,(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=7 AND fk_web_countries IS NULL) AS data_188_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=188 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_188_7_23,(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=7 AND fk_web_countries IS NULL) AS data_202_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=202 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_202_7_23,(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=7 AND fk_web_countries IS NULL) AS data_182_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=182 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_182_7_23,(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=7 AND fk_web_countries IS NULL) AS data_183_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=183 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_183_7_23,(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=7 AND fk_web_countries IS NULL) AS data_184_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=184 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_184_7_23,(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=7 AND fk_web_countries IS NULL) AS data_185_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=185 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_185_7_23,(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=7 AND fk_web_countries IS NULL) AS data_189_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=189 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_189_7_23,(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=7 AND fk_web_countries IS NULL) AS data_190_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=190 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_190_7_23,(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=7 AND fk_web_countries IS NULL) AS data_191_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=191 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_191_7_23,(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=7 AND fk_web_countries IS NULL) AS data_199_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=199 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_199_7_23,(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=7 AND fk_web_countries IS NULL) AS data_192_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=192 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_192_7_23,(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=7 AND fk_web_countries IS NULL) AS data_195_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=195 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_195_7_23,(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=7 AND fk_web_countries IS NULL) AS data_135_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=135 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_135_7_23,(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=7 AND fk_web_countries IS NULL) AS data_56_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=56 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_56_7_23,(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=7 AND fk_web_countries IS NULL) AS data_160_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=160 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_160_7_23,(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=7 AND fk_web_countries IS NULL) AS data_161_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=161 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_161_7_23,(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=7 AND fk_web_countries IS NULL) AS data_163_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=163 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_163_7_23,(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=7 AND fk_web_countries IS NULL) AS data_164_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=164 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_164_7_23,(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=7 AND fk_web_countries IS NULL) AS data_165_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=165 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_165_7_23,(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=7 AND fk_web_countries IS NULL) AS data_166_7,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=166 AND fk_app_language_codes=7 AND fk_web_countries=23) AS data_166_7_23 FROM `data_item` i WHERE item_id=12321 - error: Got a packet bigger than 'max_allowed_packet' bytes