Technisch overzicht

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',
  ),
)