SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, '???' AS column_exists, q.question AS DESCR, ## Harmonica Question TYPE '????' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type NOT IN ('M','R','P','T','O','S','|','Y','L') ## Hierboven komt niets meer uit, als het goed is! UNION # Multiple choice subquestions (zowel gewone Multiple Choice antwoorden als MC met commentaar) SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (pq.question_order * 1000) + (q.question_order * 10) AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'MCQA' AS HQTYPE, '0' AS 1STTIMEONLY, # '' AS EXTRA, # EXTRA contains the reference to the multiple-choice question CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END) ) AS EXTRA, 'Reference to question' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid INNER JOIN `lime_questions` pq ON q.parent_qid = pq.qid WHERE q.sid = 718124 AND q.type IN ('M','P','T') ## Tot 20190520 - WAS alleen type 'T' voor controle data-integriteit !! ## M = Multiple Choice antwoord ## P = Multiple Choice antwoord met commentaar UNION # Multiple choice with comments SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', q.qid, sq.title, 'comment') AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + (sq.question_order * 10) + 1 AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'CMNT' AS HQTYPE, '0' AS 1STTIMEONLY, # '' AS EXTRA, # EXTRA contains the reference to the multiple-choice question CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END) ) AS EXTRA, 'Reference to question' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, sq.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid INNER JOIN `lime_questions` sq ON q.sid = sq.sid AND q.qid = sq.parent_qid AND q.type = 'P' AND sq.type in ('P','T') ## Tot 20190520 - WAS type 'T' voor controle data-integriteit !! WHERE q.sid = 718124 UNION # Multiple choice questions which have option 'Other' SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), 'other') AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + 99 AS ORD, 'Y' AS column_exists, 'Anders' AS DESCR, 'OTHR' AS HQTYPE, '0' AS 1STTIMEONLY, # '' AS EXTRA, # EXTRA contains the reference to the multiple-choice question CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END) ) AS EXTRA, 'Reference to question' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.other = 'Y' UNION # File upload fields - filecount SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), '_filecount') AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + 1 AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'FCNT' AS HQTYPE, '0' AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type = '|' UNION # Long text fields SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END)) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + 1 AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'LTXT' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type = 'T' AND q.parent_qid = 0 UNION # Ranking fields SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), a.sortorder) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + (a.sortorder * 10) AS ORD, 'Y' AS column_exists, a.answer AS DESCR, 'RKGA' AS HQTYPE, '0' AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid INNER JOIN `lime_answers` a ON q.qid = a.qid WHERE q.sid = 718124 AND q.type = 'R' UNION # Radio button SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', q.qid) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'RDOQ' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type in ('O','L') UNION # Radio button - all answers SELECT CONCAT('lime_survey_', q.sid) AS table_name, #CONCAT(q.sid , 'X', q.gid, 'X', q.qid) AS column_name, # Deze kolomnaam bestaat niet, want alleen die voor de RDOQ hierboven bestaat # Dus voor de fake kolomnaam a.code toegevoegd CONCAT(q.sid , 'X', q.gid, 'X', q.qid, a.code) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + (a.sortorder * 10) + 5 AS ORD, 'N' AS column_exists, # CONCAT(a.code, '|', a.answer) AS DESCR, CONCAT(a.answer) AS DESCR, 'RDOA' AS HQTYPE, '0' AS 1STTIMEONLY, # CONCAT(q.sid , 'X', q.gid, 'X', q.qid, '|', a.code) AS EXTRA, # 'Reference to question|Answer code or label' AS MEANING_EXTRA, CONCAT(q.sid , 'X', q.gid, 'X', q.qid) AS EXTRA, 'Reference to question' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid INNER JOIN `lime_answers` a ON q.qid = a.qid WHERE q.sid = 718124 AND q.type in ('O','L') UNION # Radio button with comments SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', q.qid, 'comment') AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) + 1 AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'CMNT' AS HQTYPE, '0' AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type = 'O' UNION # Short text SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'STXT' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid AND NOT EXISTS (SELECT 1 FROM `lime_question_attributes` qattr WHERE q.qid = qattr.qid AND qattr.attribute = 'location_defaultcoordinates') WHERE q.sid = 718124 AND q.type IN ('S') UNION # Location with default coordinates !! (Hence inner join) SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'LOCA' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, # qattr.value AS EXTRA, CONCAT(locamc.value, ' ', locamz.value) AS EXTRA, 'Coordinates latitude and longitude plus zoom level (space separated)' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid # INNER JOIN `lime_question_attributes` qattr # ON q.qid = qattr.qid AND qattr.attribute = 'location_defaultcoordinates' INNER JOIN `lime_question_attributes` locamc ON q.qid = locamc.qid AND locamc.attribute = 'location_defaultcoordinates' AND locamc.value != '' INNER JOIN `lime_question_attributes` locamz ON q.qid = locamz.qid AND locamz.attribute = 'location_mapzoom' WHERE q.sid = 718124 AND q.type IN ('S') UNION # File upload field SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'UPLD' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type IN ('|') UNION # YES/NO field SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, 'Y' AS column_exists, q.question AS DESCR, 'YSNO' AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type IN ('Y') UNION # Het is een gesloten Multiple choice vraag # of één met optie Other # of één met commentaarmogelijkheid # of één die we nog niet kennen => GEENIDEE # Do NOT exist as columns SELECT CONCAT('lime_survey_', q.sid) AS table_name, CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END) ) AS column_name, (grp.group_order * 100000) + (q.question_order * 1000) AS ORD, 'N' AS column_exists, q.question AS DESCR, (CASE q.type WHEN 'M' THEN 'MCQ1' WHEN 'P' THEN 'MCQ2' WHEN 'R' THEN 'RKGQ' END) AS HQTYPE, (SELECT COUNT(*) FROM `lime_conditions` c WHERE c.qid = q.qid AND c.cfieldname = '{TOKEN:USESLEFT}' AND c.method = '==' AND c.value = '1') AS 1STTIMEONLY, '' AS EXTRA, '' AS MEANING_EXTRA, (SELECT COUNT(*) FROM `lime_question_attributes` sqa WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN, grp.group_name, q.* FROM `lime_questions` q INNER JOIN `lime_groups` grp ON q.sid = grp.sid AND q.gid = grp.gid WHERE q.sid = 718124 AND q.type IN ('M','R','P') AND q.parent_qid = 0 ## Tot 20190520 - zonder laatste restrictie ORDER BY 1, 3
SELECT # CONCAT('718124_', lime_survey_718124.id) AS SURVEY_REC_ID, CONCAT('718124_', LPAD(lime_survey_718124.id, 4, '0')) AS SURVEY_REC_ID, lime_tokens_718124.token, lime_survey_718124.seed, lime_survey_718124.submitdate, IF(CONCAT(lime_tokens_718124.firstname,lime_tokens_718124.lastname) = '', 'Anonieme', lime_tokens_718124.firstname) as firstname, IF(CONCAT(lime_tokens_718124.firstname,lime_tokens_718124.lastname) = '', 'Gebruiker', lime_tokens_718124.lastname) as lastname, lime_tokens_718124.email, lime_tokens_718124.sent, lime_tokens_718124.completed, lime_survey_718124.718124X101X1517SQ001, lime_survey_718124.718124X101X1517SQ002, lime_survey_718124.718124X101X1517SQ003, lime_survey_718124.718124X101X1517SQ004, lime_survey_718124.718124X101X1517SQ005, lime_survey_718124.718124X101X1517SQ006, lime_survey_718124.718124X101X1518SQ001, lime_survey_718124.718124X101X1518SQ002, lime_survey_718124.718124X101X1518SQ003, lime_survey_718124.718124X101X1518SQ006, lime_survey_718124.718124X101X1518SQ004, lime_survey_718124.718124X101X1518SQ005, lime_survey_718124.718124X101X1518other, lime_survey_718124.718124X102X1520, lime_survey_718124.718124X102X1526, lime_survey_718124.718124X102X1521, lime_survey_718124.718124X102X1549, lime_survey_718124.718124X102X1522, lime_survey_718124.718124X102X1550, lime_survey_718124.718124X102X1525, lime_survey_718124.718124X102X1551, lime_survey_718124.718124X102X1527, lime_survey_718124.718124X103X1519SQ001, lime_survey_718124.718124X103X1519SQ002, lime_survey_718124.718124X103X1519SQ003, lime_survey_718124.718124X103X1519other, lime_survey_718124.718124X103X1524SQ001, lime_survey_718124.718124X103X1524SQ002, lime_survey_718124.718124X103X1524SQ003, lime_survey_718124.718124X103X1524SQ004, lime_survey_718124.718124X103X1524SQ005, lime_survey_718124.718124X103X1524SQ006, lime_survey_718124.718124X103X1523, lime_survey_718124.718124X103X1523_filecount FROM lime_survey_718124 INNER JOIN lime_tokens_718124 ON lime_survey_718124.token = lime_tokens_718124.token WHERE lime_survey_718124.submitdate IS NOT NULL ORDER BY lime_tokens_718124.token, lime_survey_718124.id
Column-To-Question-map
array ( '718124X101X1517' => array ( 'description' => '<strong>Hoe ben je betrokken bij de Indische Buurt?</strong>', 'stripped_description' => 'Hoe ben je betrokken bij de Indische Buurt?', 'core_description' => 'Hoe ben je betrokken bij de Indische Buurt?', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQ1', '1sttimeonly' => '1', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'N', 'hqtype_descr' => 'meerkeuze', 'mandatory' => 'Y', 'question_nr' => 1, 'main_question' => 1, ), '718124X101X1517SQ001' => array ( 'description' => '<strong>bewoner</strong>', 'stripped_description' => 'bewoner', 'core_description' => 'bewoner', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1517', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1517SQ002' => array ( 'description' => '<strong>ondernemer</strong>', 'stripped_description' => 'ondernemer', 'core_description' => 'ondernemer', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1517', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1517SQ003' => array ( 'description' => '<strong>werknemer / student / vrijwilliger</strong>', 'stripped_description' => 'werknemer / student / vrijwilliger', 'core_description' => 'werknemer / student / vrijwilliger', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1517', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1517SQ004' => array ( 'description' => '<strong>ambtenaar</strong>', 'stripped_description' => 'ambtenaar', 'core_description' => 'ambtenaar', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1517', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1517SQ005' => array ( 'description' => '<strong>bestuurder</strong>', 'stripped_description' => 'bestuurder', 'core_description' => 'bestuurder', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1517', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1517SQ006' => array ( 'description' => '<strong>bezoeker</strong>', 'stripped_description' => 'bezoeker', 'core_description' => 'bezoeker', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1517', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518' => array ( 'description' => '<strong>Hoe maak je gebruik van de Indische Buurt?</strong>', 'stripped_description' => 'Hoe maak je gebruik van de Indische Buurt?', 'core_description' => 'Hoe maak je gebruik van de Indische Buurt?', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQ1', '1sttimeonly' => '1', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'N', 'hqtype_descr' => 'meerkeuze', 'mandatory' => 'Y', 'question_nr' => 2, 'main_question' => 1, ), '718124X101X1518SQ001' => array ( 'description' => '<strong>woning</strong> (appartement, huis, verzorgingshuis, ...)', 'stripped_description' => 'woning (appartement, huis, verzorgingshuis, ...)', 'core_description' => 'woning', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518SQ002' => array ( 'description' => '<strong>bedrijf</strong> (bedrijfspand, winkel, kantoorruimte, ...)', 'stripped_description' => 'bedrijf (bedrijfspand, winkel, kantoorruimte, ...)', 'core_description' => 'bedrijf', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518SQ003' => array ( 'description' => '<strong>sociale voorziening</strong> (horeca, buurthuis, speeltuin, school, ...)', 'stripped_description' => 'sociale voorziening (horeca, buurthuis, speeltuin, school, ...)', 'core_description' => 'sociale voorziening', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518SQ006' => array ( 'description' => '<strong>culturele voorziening</strong> (museum, bioscoop, theater, bibliotheek, ...)', 'stripped_description' => 'culturele voorziening (museum, bioscoop, theater, bibliotheek, ...)', 'core_description' => 'culturele voorziening', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518SQ004' => array ( 'description' => '<strong>transportmiddel</strong> (auto, fiets, openbaar vervoer, ...)', 'stripped_description' => 'transportmiddel (auto, fiets, openbaar vervoer, ...)', 'core_description' => 'transportmiddel', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518SQ005' => array ( 'description' => '<strong>groen</strong> (parken, sportvoorzieningen, water, ...)', 'stripped_description' => 'groen (parken, sportvoorzieningen, water, ...)', 'core_description' => 'groen', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X101X1518other' => array ( 'description' => 'Anders', 'stripped_description' => 'Anders', 'core_description' => 'Anders', 'type' => 'M', 'group_name' => 'Over jou', 'hqtype' => 'OTHR', '1sttimeonly' => '0', 'extra' => '718124X101X1518', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X102X1520' => array ( 'description' => '<p>Waar wil je je idee uitvoeren?</p> <p><strong>Wijs de locatie aan op de kaart.</strong></p> ', 'stripped_description' => 'Waar wil je je idee uitvoeren? Wijs de locatie aan op de kaart.', 'core_description' => 'Wijs de locatie aan op de kaart.', 'type' => 'S', 'group_name' => 'Jouw idee', 'hqtype' => 'LOCA', '1sttimeonly' => '0', 'extra' => '52.361939 4.939720 15', 'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'locatie', 'mandatory' => 'N', 'question_nr' => 3, 'main_question' => 1, ), '718124X102X1526' => array ( 'description' => '<p><strong>Mijn idee is uit te voeren op:</strong></p> ', 'stripped_description' => 'Mijn idee is uit te voeren op:', 'core_description' => 'Mijn idee is uit te voeren op:', 'type' => 'L', 'group_name' => 'Jouw idee', 'hqtype' => 'RDOQ', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'keuze', 'mandatory' => 'Y', 'question_nr' => 4, 'main_question' => 1, ), '718124X102X1526A1' => array ( 'description' => 'Een specifieke locatie (straat, park, plein, kruising) ', 'stripped_description' => 'Een specifieke locatie (straat, park, plein, kruising)', 'core_description' => 'Een specifieke locatie (straat, park, plein, kruising) ', 'type' => 'L', 'group_name' => 'Jouw idee', 'hqtype' => 'RDOA', '1sttimeonly' => '0', 'extra' => '718124X102X1526', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'N', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X102X1526A2' => array ( 'description' => 'Mijn idee is op meerdere locaties / locatie ongebonden', 'stripped_description' => 'Mijn idee is op meerdere locaties / locatie ongebonden', 'core_description' => 'Mijn idee is op meerdere locaties / locatie ongebonden', 'type' => 'L', 'group_name' => 'Jouw idee', 'hqtype' => 'RDOA', '1sttimeonly' => '0', 'extra' => '718124X102X1526', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'N', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X102X1521' => array ( 'description' => '<strong>Hoe heet de locatie waar je het idee kunt uitvoeren?</strong>', 'stripped_description' => 'Hoe heet de locatie waar je het idee kunt uitvoeren?', 'core_description' => 'Hoe heet de locatie waar je het idee kunt uitvoeren?', 'type' => 'T', 'group_name' => 'Jouw idee', 'hqtype' => 'LTXT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'open', 'mandatory' => 'Y', 'question_nr' => 5, 'main_question' => 1, ), '718124X102X1549' => array ( 'description' => '<strong>Naam Locatie - Interpretatie</strong>', 'stripped_description' => 'Naam Locatie - Interpretatie', 'core_description' => 'Naam Locatie - Interpretatie', 'type' => 'T', 'group_name' => 'Jouw idee', 'hqtype' => 'LTXT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 1, 'column_exists' => 'Y', 'hqtype_descr' => 'open', 'mandatory' => 'N', 'question_nr' => 6, 'main_question' => 1, ), '718124X102X1522' => array ( 'description' => '<p>Wat houdt je idee in? Wat wil je dat er wordt uitgevoerd?</p> <p><strong>Ik wil dat er.....</strong></p> ', 'stripped_description' => 'Wat houdt je idee in? Wat wil je dat er wordt uitgevoerd? Ik wil dat er.....', 'core_description' => 'Ik wil dat er.....', 'type' => 'T', 'group_name' => 'Jouw idee', 'hqtype' => 'LTXT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'open', 'mandatory' => 'Y', 'question_nr' => 7, 'main_question' => 1, ), '718124X102X1550' => array ( 'description' => '<strong>Idee - Interpretatie</strong>', 'stripped_description' => 'Idee - Interpretatie', 'core_description' => 'Idee - Interpretatie', 'type' => 'T', 'group_name' => 'Jouw idee', 'hqtype' => 'LTXT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 1, 'column_exists' => 'Y', 'hqtype_descr' => 'open', 'mandatory' => 'N', 'question_nr' => 8, 'main_question' => 1, ), '718124X102X1525' => array ( 'description' => '<p>Met mijn idee wordt de Indische Buurt aantrekkelijker voor bewoners, ondernemers, bezoekers, etc.</p> <p><strong>Mijn idee zorgt ervoor dat ...</strong></p> ', 'stripped_description' => 'Met mijn idee wordt de Indische Buurt aantrekkelijker voor bewoners, ondernemers, bezoekers, etc. Mijn idee zorgt ervoor dat ...', 'core_description' => 'Mijn idee zorgt ervoor dat ...', 'type' => 'T', 'group_name' => 'Jouw idee', 'hqtype' => 'LTXT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'open', 'mandatory' => 'N', 'question_nr' => 9, 'main_question' => 1, ), '718124X102X1551' => array ( 'description' => '<strong>Gevolg Idee - Interpretatie</strong>', 'stripped_description' => 'Gevolg Idee - Interpretatie', 'core_description' => 'Gevolg Idee - Interpretatie', 'type' => 'T', 'group_name' => 'Jouw idee', 'hqtype' => 'LTXT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 1, 'column_exists' => 'Y', 'hqtype_descr' => 'open', 'mandatory' => 'N', 'question_nr' => 10, 'main_question' => 1, ), '718124X102X1527' => array ( 'description' => '<p>Alle bijdragen worden opgenomen in de buurtmozaïek. Als je liever hebt dat je naam niet wordt getoond, geef dat dan hier aan.</p> <p><strong>Toon mijn naam bij mijn wens:</strong></p> <p> </p> ', 'stripped_description' => 'Alle bijdragen worden opgenomen in de buurtmozaïek. Als je liever hebt dat je naam niet wordt getoond, geef dat dan hier aan. Toon mijn naam bij mijn wens: ', 'core_description' => 'Toon mijn naam bij mijn wens:', 'type' => 'Y', 'group_name' => 'Jouw idee', 'hqtype' => 'YSNO', '1sttimeonly' => '1', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'keuze', 'mandatory' => 'Y', 'question_nr' => 11, 'main_question' => 1, ), '718124X103X1519' => array ( 'description' => '<p>Met het opstellen van dit buurtmozaïek werken we toe naar een mooiere en aantrekkelijkere Indische Buurt. Hiervoor stellen we een agenda 2020 op waarin we alle ideeën onderbrengen bij een overkoepelend doel.</p> <p><strong>Wat wil jij graag bereiken met je idee? Ik wil verbeteren:</strong></p> ', 'stripped_description' => 'Met het opstellen van dit buurtmozaïek werken we toe naar een mooiere en aantrekkelijkere Indische Buurt. Hiervoor stellen we een agenda 2020 op waarin we alle ideeën onderbrengen bij een overkoepelend doel. Wat wil jij graag bereiken met je idee? Ik wil verbeteren:', 'core_description' => 'Wat wil jij graag bereiken met je idee? Ik wil verbeteren:', 'type' => 'M', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQ1', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'N', 'hqtype_descr' => 'meerkeuze', 'mandatory' => 'Y', 'question_nr' => 12, 'main_question' => 1, ), '718124X103X1519SQ001' => array ( 'description' => '<strong>de woon- en verkeerssituatie</strong><br/> (betaalbaar en beter wonen, veiligere infrastructuur, verbeteren veiligheid) ', 'stripped_description' => 'de woon- en verkeerssituatie (betaalbaar en beter wonen, veiligere infrastructuur, verbeteren veiligheid)', 'core_description' => 'de woon- en verkeerssituatie', 'type' => 'M', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1519', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1519SQ002' => array ( 'description' => '<strong>de leefomgeving</strong><br/> (duurzaamheid, groen en leefbaarheid)', 'stripped_description' => 'de leefomgeving (duurzaamheid, groen en leefbaarheid)', 'core_description' => 'de leefomgeving', 'type' => 'M', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1519', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1519SQ003' => array ( 'description' => '<strong>de samenhang in de buurt</strong><br/> (bevorderen contacten, inclusiviteit, minder eenzaamheid)', 'stripped_description' => 'de samenhang in de buurt (bevorderen contacten, inclusiviteit, minder eenzaamheid)', 'core_description' => 'de samenhang in de buurt', 'type' => 'M', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1519', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1519other' => array ( 'description' => 'Anders', 'stripped_description' => 'Anders', 'core_description' => 'Anders', 'type' => 'M', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'OTHR', '1sttimeonly' => '0', 'extra' => '718124X103X1519', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1524' => array ( 'description' => '<p>Het is handig om ideeën die bij elkaar horen te bundelen tot een thema.</p> <p><b>Waar past jouw idee het beste? </b></p> ', 'stripped_description' => 'Het is handig om ideeën die bij elkaar horen te bundelen tot een thema. Waar past jouw idee het beste? ', 'core_description' => 'Het is handig om ideeën die bij elkaar horen te bundelen tot een thema. Waar past jouw idee het beste? ', 'type' => 'M', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQ1', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'N', 'hqtype_descr' => 'meerkeuze', 'mandatory' => 'Y', 'question_nr' => 13, 'main_question' => 1, ), '718124X103X1524SQ001' => array ( 'description' => '<div style="width:100%;clear:both;"><img alt="Wonen" src="https://goharmonica.nl/harmonica_files/themas_ibf/ibf_v2_wonen_en_groen.png" style="width:80px;float:left;margin-right:20px;margin-bottom:10px;" /><div style="width:280px;float:left;"><strong>Wonen</strong></div></div>', 'stripped_description' => 'Wonen', 'core_description' => 'Wonen', 'type' => 'T', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1524', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1524SQ002' => array ( 'description' => '<div style="width:100%;clear:both;"><img alt="Leefbaarheid" src="https://goharmonica.nl/harmonica_files/themas_ibf/ibf_v2_wonen_winkelen_horeca_en_recreatie.png" style="width:80px;float:left;margin-right:20px;margin-bottom:10px;" /><div style="width:280px;float:left;"><strong>Leefbaarheid</strong></div></div>', 'stripped_description' => 'Leefbaarheid', 'core_description' => 'Leefbaarheid', 'type' => 'T', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1524', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1524SQ003' => array ( 'description' => '<div style="width:100%;clear:both;"><img alt="Hulp en ondersteuning" src="https://goharmonica.nl/harmonica_files/themas_ibf/ibf_v2_zorg_sport_en_school.png" style="width:80px;float:left;margin-right:20px;margin-bottom:10px;" /><div style="width:280px;float:left;"><strong>Hulp en ondersteuning</strong></div></div>', 'stripped_description' => 'Hulp en ondersteuning', 'core_description' => 'Hulp en ondersteuning', 'type' => 'T', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1524', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1524SQ004' => array ( 'description' => '<div style="width:100%;clear:both;"><img alt="Duurzaamheid" src="https://goharmonica.nl/harmonica_files/themas_ibf/ibf_v2_duurzaam.png" style="width:80px;float:left;margin-right:20px;margin-bottom:10px;" /><div style="width:280px;float:left;"><strong>Duurzaamheid</strong></div></div>', 'stripped_description' => 'Duurzaamheid', 'core_description' => 'Duurzaamheid', 'type' => 'T', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1524', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1524SQ005' => array ( 'description' => '<div style="width:100%;clear:both;"><img alt="Sociale betrokkenheid" src="https://goharmonica.nl/harmonica_files/themas_ibf/ibf_v2_speeltuin_buurthuis_en_spiritualiteit.png" style="width:80px;float:left;margin-right:20px;margin-bottom:10px;" /><div style="width:280px;float:left;"><strong>Sociale betrokkenheid</strong></div></div>', 'stripped_description' => 'Sociale betrokkenheid', 'core_description' => 'Sociale betrokkenheid', 'type' => 'T', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1524', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1524SQ006' => array ( 'description' => '<div style="width:100%;clear:both;"><img alt="Verkeer en veiligheid" src="https://goharmonica.nl/harmonica_files/themas_ibf/ibf_v2_verkeer_van_auto_ov_fiets_etc.png" style="width:80px;float:left;margin-right:20px;margin-bottom:10px;" /><div style="width:280px;float:left;"><strong>Verkeer en veiligheid</strong></div></div>', 'stripped_description' => 'Verkeer en veiligheid', 'core_description' => 'Verkeer en veiligheid', 'type' => 'T', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'MCQA', '1sttimeonly' => '0', 'extra' => '718124X103X1524', 'meaning_extra' => 'Reference to question', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), '718124X103X1523' => array ( 'description' => '<p><strong>Voeg een foto van jezelf toe.</strong></p> <p>Dit is niet verplicht, maar maakt je pagina persoonlijker.</p> ', 'stripped_description' => 'Voeg een foto van jezelf toe. Dit is niet verplicht, maar maakt je pagina persoonlijker.', 'core_description' => 'Voeg een foto van jezelf toe.', 'type' => '|', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'UPLD', '1sttimeonly' => '1', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'upload', 'mandatory' => 'N', 'question_nr' => 14, 'main_question' => 1, ), '718124X103X1523_filecount' => array ( 'description' => '<p><strong>Voeg een foto van jezelf toe.</strong></p> <p>Dit is niet verplicht, maar maakt je pagina persoonlijker.</p> ', 'stripped_description' => 'Voeg een foto van jezelf toe. Dit is niet verplicht, maar maakt je pagina persoonlijker.', 'core_description' => 'Voeg een foto van jezelf toe.', 'type' => '|', 'group_name' => 'Waar past jouw idee?', 'hqtype' => 'FCNT', '1sttimeonly' => '0', 'extra' => '', 'meaning_extra' => '', 'hidden' => 0, 'column_exists' => 'Y', 'hqtype_descr' => 'antwoord', 'mandatory' => '-', 'question_nr' => '', 'main_question' => 0, ), )
Qnrs
array ( 0 => array ( 'label' => 'OBJECT', 'org' => '5', 'int' => '6', ), 1 => array ( 'label' => 'IDEA', 'org' => '7', 'int' => '8', ), 2 => array ( 'label' => 'GOAL', 'org' => '9', 'int' => '10', ), )
Qcols
array ( 0 => array ( 'label' => 'OBJECT', 'org' => '718124X102X1521', 'int' => '718124X102X1549', ), 1 => array ( 'label' => 'IDEA', 'org' => '718124X102X1522', 'int' => '718124X102X1550', ), 2 => array ( 'label' => 'GOAL', 'org' => '718124X102X1525', 'int' => '718124X102X1551', ), )