CREATE VIEW lime_view_967824 AS SELECT s.id 'id',s.submitdate 'submitdate',s.lastpage 'lastpage',s.startlanguage 'startlanguage',s.967824X1087X6950SQ001 'arraySD_SQ001',(SELECT IFNULL((SELECT a.answer from lime_answers a, lime_survey_967824 ls where a.qid=6950 AND a.language='en' AND ls.967824X1087X6950SQ001=a.code LIMIT 1),'')) AS 'arraySD_SQ001[TEXT]',s.967824X1087X6950SQ002 'arraySD_SQ002',(SELECT IFNULL((SELECT a.answer from lime_answers a, lime_survey_967824 ls where a.qid=6950 AND a.language='en' AND ls.967824X1087X6950SQ002=a.code LIMIT 1),'')) AS 'arraySD_SQ002[TEXT]',s.967824X1087X6950SQ003 'arraySD_SQ003',(SELECT IFNULL((SELECT a.answer from lime_answers a, lime_survey_967824 ls where a.qid=6950 AND a.language='en' AND ls.967824X1087X6950SQ003=a.code LIMIT 1),'')) AS 'arraySD_SQ003[TEXT]',s.967824X1087X6946SQ001 'multiOptions_SQ001',s.967824X1087X6946SQ002 'multiOptions_SQ002',s.967824X1087X6946SQ003 'multiOptions_SQ003',s.967824X1087X6946other 'multiOptions_other',s.967824X1087X6941SQ001 'multiNumInput_SQ001',(SELECT IFNULL((SELECT q.question from lime_questions q, lime_survey_967824 ls where q.qid=6941 AND q.title='SQ001' AND q.language='en' AND q.type='K' LIMIT 1),'')) AS 'multiNumInput_SQ001[TEXT]',s.967824X1087X6941SQ002 'multiNumInput_SQ002',(SELECT IFNULL((SELECT q.question from lime_questions q, lime_survey_967824 ls where q.qid=6941 AND q.title='SQ002' AND q.language='en' AND q.type='K' LIMIT 1),'')) AS 'multiNumInput_SQ002[TEXT]',s.967824X1087X6941SQ003 'multiNumInput_SQ003',(SELECT IFNULL((SELECT q.question from lime_questions q, lime_survey_967824 ls where q.qid=6941 AND q.title='SQ003' AND q.language='en' AND q.type='K' LIMIT 1),'')) AS 'multiNumInput_SQ003[TEXT]',s.967824X1087X6941SQ004 'multiNumInput_SQ004',(SELECT IFNULL((SELECT q.question from lime_questions q, lime_survey_967824 ls where q.qid=6941 AND q.title='SQ004' AND q.language='en' AND q.type='K' LIMIT 1),'')) AS 'multiNumInput_SQ004[TEXT]' FROM lime_survey_967824 s