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=1) AS data_2_1_1,(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=1) AS data_1_1_1,(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=1) AS data_97_1_1,(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=1) AS data_13_1_1,(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=1) AS data_34_1_1,(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=1) AS data_56_1_1,(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=1) AS data_57_1_1,(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=1) AS data_14_1_1,(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=1) AS data_35_1_1,(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=1) AS data_15_1_1,(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=1) AS data_16_1_1,(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=1) AS data_17_1_1,(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=1) AS data_89_1_1,(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=1) AS data_18_1_1,(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=1) AS data_19_1_1,(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=1) AS data_20_1_1,(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=1) AS data_21_1_1,(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=1) AS data_22_1_1,(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=1) AS data_23_1_1,(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=1) AS data_24_1_1,(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=1) AS data_25_1_1,(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=1) AS data_26_1_1,(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=1) AS data_27_1_1,(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=1) AS data_28_1_1,(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=1) AS data_29_1_1,(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=1) AS data_54_1_1,(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=1) AS data_30_1_1,(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=1) AS data_31_1_1,(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=1) AS data_32_1_1,(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=1) AS data_33_1_1,(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=1) AS data_58_1_1,(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=1) AS data_36_1_1,(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=1) AS data_37_1_1,(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=1) AS data_48_1_1,(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=1) AS data_49_1_1,(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=1) AS data_50_1_1,(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=1) AS data_51_1_1,(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=1) AS data_52_1_1,(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=1) AS data_69_1_1,(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=1) AS data_74_1_1,(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=1) AS data_76_1_1,(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=1) AS data_78_1_1,(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=1) AS data_75_1_1,(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=1) AS data_59_1_1,(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=1) AS data_61_1_1,(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=1) AS data_62_1_1,(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=1) AS data_63_1_1,(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=1) AS data_64_1_1,(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=1) AS data_65_1_1,(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=1) AS data_66_1_1,(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=1) AS data_68_1_1,(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=1) AS data_80_1_1,(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=1) AS data_67_1_1,(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=1) AS data_71_1_1,(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=1) AS data_72_1_1,(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=1) AS data_73_1_1,(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=1) AS data_79_1_1,(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=1) AS data_90_1_1,(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=1) AS data_96_1_1,(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=1) AS data_103_1_1,(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=1) AS data_98_1_1,(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=1) AS data_134_1_1,(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=1) AS data_135_1_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=159 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_159,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=159 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_159_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=159 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_159_1_1,(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=1) AS data_154_1_1,(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=1) AS data_160_1_1,(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=1) AS data_161_1_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=162 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_162,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=162 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_162_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=162 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_162_1_1,(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=1) AS data_163_1_1,(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=1) AS data_164_1_1,(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=1) AS data_165_1_1,(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=1) AS data_166_1_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=170 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_170,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=170 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_170_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=170 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_170_1_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=171 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_171,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=171 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_171_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=171 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_171_1_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=172 AND fk_app_language_codes IS NULL AND fk_web_countries IS NULL) AS data_172,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=172 AND fk_app_language_codes=1 AND fk_web_countries IS NULL) AS data_172_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=172 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_172_1_1,(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=1) AS data_173_1_1,(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=1) AS data_53_1_1,(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=1) AS data_174_1_1,(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=1) AS data_180_1_1,(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=1) AS data_181_1_1,(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=1) AS data_182_1_1,(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=1) AS data_183_1_1,(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=1) AS data_184_1_1,(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=1) AS data_185_1_1,(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=1) AS data_186_1_1,(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=1) AS data_187_1_1,(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=1) AS data_188_1_1,(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=1) AS data_189_1_1,(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=1) AS data_190_1_1,(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=1) AS data_191_1_1,(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=1) AS data_192_1_1,(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=1) AS data_193_1_1,(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=1) AS data_195_1_1,(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=1) AS data_196_1_1,(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=1) AS data_197_1_1,(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=1) AS data_198_1_1,(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=1) AS data_199_1_1,(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=1) AS data_200_1_1,(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=1) AS data_201_1_1,(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=1) AS data_202_1_1,(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=1) AS data_203_1_1,(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=1) AS data_204_1_1,(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=1) AS data_205_1_1,(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=1) AS data_206_1_1,(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=1 AND fk_web_countries IS NULL) AS data_105_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=105 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_105_1_1,(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=1) AS data_217_1_1,(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=1) AS data_106_1_1,(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=1 AND fk_web_countries IS NULL) AS data_111_1,(SELECT `value` FROM `data_item_values` WHERE item = i.item_id AND field=111 AND fk_app_language_codes=1 AND fk_web_countries=1) AS data_111_1_1,(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=1) AS data_110_1_1,(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=1) AS data_112_1_1,(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=1) AS data_107_1_1,(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=1) AS data_108_1_1,(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=1) AS data_109_1_1,(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=1) AS data_56_1_1,(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=1) AS data_160_1_1,(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=1) AS data_161_1_1,(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=1) AS data_163_1_1,(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=1) AS data_164_1_1,(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=1) AS data_165_1_1,(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=1) AS data_166_1_1 FROM `data_item` i WHERE item_id=12324 - error: Got a packet bigger than 'max_allowed_packet' bytes