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 = 223796 AND q.type NOT IN ('M','R','P','T','O','S','|','Y','L','G','X','!')
## 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 = 223796 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 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 = 223796
 
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 = 223796 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 = 223796 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 = 223796 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 = 223796 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 = 223796 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 = 223796 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 = 223796 AND q.type = 'O'
 
UNION
# Drop down list
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,
 'DDLQ' 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 = 223796 AND q.type in ('!')
 
UNION
# Drop down list - 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,
 'DDLA' 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 = 223796 AND q.type in ('!')
 
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 = 223796 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 = 223796 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,
 (SELECT value FROM `lime_question_attributes` qa
  WHERE qa.qid = q.qid 
  AND qa.attribute = 'allowed_filetypes') AS EXTRA,
 'allowed_filetypes' 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 = 223796 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 = 223796 AND q.type IN ('Y')
 
UNION
# Gender field  - 20191219 // Quick fix !!??
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,
 'GNDR' 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 = 223796 AND q.type IN ('G')
 
UNION
# Text field (static) - 20191219 - Value always NULL (?)
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,
 'TSCRN' 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 = 223796 AND q.type IN ('X')
 
 
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 = 223796 AND q.type IN ('M','R','P')
  AND q.parent_qid = 0
## Tot 20190520 - zonder laatste restrictie
 
ORDER BY 1, 3

SELECT
  # CONCAT('223796_', lime_survey_223796.id) AS SURVEY_REC_ID,
  CONCAT('223796_', LPAD(lime_survey_223796.id, 4, '0')) AS SURVEY_REC_ID,
  lime_tokens_223796.token,
  lime_survey_223796.seed,
  lime_survey_223796.submitdate,
  IF(CONCAT(lime_tokens_223796.firstname,lime_tokens_223796.lastname) = '', 'Anonieme', lime_tokens_223796.firstname) as firstname,
  IF(CONCAT(lime_tokens_223796.firstname,lime_tokens_223796.lastname) = '', 'Gebruiker', lime_tokens_223796.lastname) as lastname,
  lime_tokens_223796.email, 
  lime_tokens_223796.sent,
  lime_tokens_223796.completed,
  lime_survey_223796.223796X113X1657,
  lime_survey_223796.223796X113X1657_filecount,
  lime_survey_223796.223796X113X1658,
  lime_survey_223796.223796X113X1692,
  CASE lime_survey_223796.223796X113X1659
    WHEN 'M' THEN 'Man'
    WHEN 'F' THEN 'Vrouw'
    ELSE 'Onbekend'
  END AS 223796X113X1659,
  lime_survey_223796.223796X113X1660,
  lime_survey_223796.223796X113X1661SQ001,
  lime_survey_223796.223796X113X1661SQ002,
  lime_survey_223796.223796X113X1661SQ003,
  lime_survey_223796.223796X113X1661SQ004,
  lime_survey_223796.223796X113X1661SQ005,
  lime_survey_223796.223796X113X1661other,
  lime_survey_223796.223796X114X1667,
  lime_survey_223796.223796X114X1668,
  lime_survey_223796.223796X114X1696,
  lime_survey_223796.223796X114X1669,
  lime_survey_223796.223796X114X1690,
  lime_survey_223796.223796X114X1697,
  lime_survey_223796.223796X115X1670SQ001,
  lime_survey_223796.223796X115X1670SQ002,
  lime_survey_223796.223796X115X1670SQ003,
  lime_survey_223796.223796X115X1670SQ004,
  lime_survey_223796.223796X115X1670SQ005,
  lime_survey_223796.223796X115X1670SQ006,
  lime_survey_223796.223796X115X1670SQ007,
  lime_survey_223796.223796X115X1670SQ008,
  lime_survey_223796.223796X115X1670SQ009,
  lime_survey_223796.223796X115X1670SQ010,
  lime_survey_223796.223796X115X1670SQ011,
  lime_survey_223796.223796X115X1670SQ012,
  lime_survey_223796.223796X115X1682,
  lime_survey_223796.223796X115X1683,
  lime_survey_223796.223796X115X1691,
  lime_survey_223796.223796X115X1694,
  lime_survey_223796.223796X115X1695,
  lime_survey_223796.223796X115X1684,
  lime_survey_223796.223796X115X1693,
  lime_survey_223796.223796X115X1685,
  lime_survey_223796.223796X115X1685_filecount,
  lime_survey_223796.223796X115X1687,
  lime_survey_223796.223796X116X1689
FROM lime_survey_223796
INNER JOIN lime_tokens_223796
ON lime_survey_223796.token = lime_tokens_223796.token
WHERE lime_survey_223796.submitdate IS NOT NULL
ORDER BY lime_tokens_223796.token, lime_survey_223796.id

Column-To-Question-map

array (
  '223796X113X1657' => 
  array (
    'description' => '<strong>Upload een foto van jezelf.</strong>',
    'stripped_description' => 'Upload een foto van jezelf.',
    'core_description' => 'Upload een foto van jezelf.',
    'type' => '|',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'UPLD',
    '1sttimeonly' => '0',
    'extra' => 'png, gif, jpg, jpeg',
    'meaning_extra' => 'allowed_filetypes',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'upload',
    'mandatory' => 'N',
    'question_nr' => 1,
    'main_question' => 1,
  ),
  '223796X113X1657_filecount' => 
  array (
    'description' => '<strong>Upload een foto van jezelf.</strong>',
    'stripped_description' => 'Upload een foto van jezelf.',
    'core_description' => 'Upload een foto van jezelf.',
    'type' => '|',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'FCNT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1658' => 
  array (
    'description' => '<p><strong>Geef op de kaart aan waar je ongeveer woont.</strong> Als je niet in de Indische Buurt woont, mag het ook je werkplaats, school, kantoor of bedrijf zijn. </p>
',
    'stripped_description' => 'Geef op de kaart aan waar je ongeveer woont. Als je niet in de Indische Buurt woont, mag het ook je werkplaats, school, kantoor of bedrijf zijn. ',
    'core_description' => 'Geef op de kaart aan waar je ongeveer woont.',
    'type' => 'S',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '0',
    'extra' => '52.361814 4.939646 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 2,
    'main_question' => 1,
  ),
  '223796X113X1692' => 
  array (
    'description' => '<strong>Hoe heet de locatie waar je woont, werkt of studeert?</strong> Dit hoeft niet de officiële naam te zijn.',
    'stripped_description' => 'Hoe heet de locatie waar je woont, werkt of studeert? Dit hoeft niet de officiële naam te zijn.',
    'core_description' => 'Hoe heet de locatie waar je woont, werkt of studeert?',
    'type' => 'T',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 3,
    'main_question' => 1,
  ),
  '223796X113X1659' => 
  array (
    'description' => '<strong>Wat is je geslacht?</strong>',
    'stripped_description' => 'Wat is je geslacht?',
    'core_description' => 'Wat is je geslacht?',
    'type' => 'G',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'GNDR',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'keuze',
    'mandatory' => 'N',
    'question_nr' => 4,
    'main_question' => 1,
  ),
  '223796X113X1660' => 
  array (
    'description' => '<strong>Wat is je leeftijd?</strong>',
    'stripped_description' => 'Wat is je leeftijd?',
    'core_description' => 'Wat is je leeftijd?',
    'type' => 'L',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'RDOQ',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'keuze',
    'mandatory' => 'N',
    'question_nr' => 5,
    'main_question' => 1,
  ),
  '223796X113X1660A2' => 
  array (
    'description' => '<strong>18 tot 30 jaar</strong>',
    'stripped_description' => '18 tot 30 jaar',
    'core_description' => '18 tot 30 jaar',
    'type' => 'L',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'RDOA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1660',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1660A3' => 
  array (
    'description' => '<strong>30 tot 55 jaar</strong>',
    'stripped_description' => '30 tot 55 jaar',
    'core_description' => '30 tot 55 jaar',
    'type' => 'L',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'RDOA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1660',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1660A4' => 
  array (
    'description' => '<strong>55 tot 70 jaar</strong>',
    'stripped_description' => '55 tot 70 jaar',
    'core_description' => '55 tot 70 jaar',
    'type' => 'L',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'RDOA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1660',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1660A5' => 
  array (
    'description' => '<strong>70 jaar en ouder</strong>',
    'stripped_description' => '70 jaar en ouder',
    'core_description' => '70 jaar en ouder',
    'type' => 'L',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'RDOA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1660',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1661' => 
  array (
    'description' => 'Geef aan hoe je betrokken bent bij de Indische Buurt. Meerdere antwoorden zijn mogelijk. Als het antwoord er niet bij staat, kies Anders en vul aan. <strong>Ik ben betrokken bij de Indische Buurt als ... :</strong>',
    'stripped_description' => 'Geef aan hoe je betrokken bent bij de Indische Buurt. Meerdere antwoorden zijn mogelijk. Als het antwoord er niet bij staat, kies Anders en vul aan. Ik ben betrokken bij de Indische Buurt als ... :',
    'core_description' => 'Ik ben betrokken bij de Indische Buurt als ... :',
    'type' => 'M',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'MCQ1',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'meerkeuze',
    'mandatory' => 'N',
    'question_nr' => 6,
    'main_question' => 1,
  ),
  '223796X113X1661SQ001' => 
  array (
    'description' => '<strong>Bewoner</strong>: ik woon in de IB.',
    'stripped_description' => 'Bewoner: ik woon in de IB.',
    'core_description' => 'Bewoner',
    'type' => 'T',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1661',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1661SQ002' => 
  array (
    'description' => '<strong>Student</strong>: ik studeer in de IB',
    'stripped_description' => 'Student: ik studeer in de IB',
    'core_description' => 'Student',
    'type' => 'T',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1661',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1661SQ003' => 
  array (
    'description' => '<strong>Werknemer</strong>: ik werk in de IB',
    'stripped_description' => 'Werknemer: ik werk in de IB',
    'core_description' => 'Werknemer',
    'type' => 'T',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1661',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1661SQ004' => 
  array (
    'description' => '<strong>Ondernemer, winkelier, zelfstandige</strong>: ik heb een bedrijf in de IB.',
    'stripped_description' => 'Ondernemer, winkelier, zelfstandige: ik heb een bedrijf in de IB.',
    'core_description' => 'Ondernemer, winkelier, zelfstandige',
    'type' => 'T',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1661',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1661SQ005' => 
  array (
    'description' => '<strong>Bezoeker</strong> van bijv. winkel, café, restaurant, club, wandelgebied: ik bezoek/recreëer in de IB',
    'stripped_description' => 'Bezoeker van bijv. winkel, café, restaurant, club, wandelgebied: ik bezoek/recreëer in de IB',
    'core_description' => 'Bezoeker',
    'type' => 'T',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1661',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X113X1661other' => 
  array (
    'description' => 'Anders',
    'stripped_description' => 'Anders',
    'core_description' => 'Anders',
    'type' => 'M',
    'group_name' => 'Wie ben je?',
    'hqtype' => 'OTHR',
    '1sttimeonly' => '0',
    'extra' => '223796X113X1661',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X114X1667' => 
  array (
    'description' => '<strong>Wat vind jij persoonlijk de belangrijkste plek van de Indische Buurt?</strong> Wijs de locatie aan op de kaart. Dit kan een station, school, park, straat, winkel, etc. zijn. Maar ook de straat waar je woont of waar je werkt mag je aanwijzen. ',
    'stripped_description' => 'Wat vind jij persoonlijk de belangrijkste plek van de Indische Buurt? Wijs de locatie aan op de kaart. Dit kan een station, school, park, straat, winkel, etc. zijn. Maar ook de straat waar je woont of waar je werkt mag je aanwijzen. ',
    'core_description' => 'Wat vind jij persoonlijk de belangrijkste plek van de Indische Buurt?',
    'type' => 'S',
    'group_name' => 'Prioriteiten',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '0',
    'extra' => '52.361814 4.939646 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 7,
    'main_question' => 1,
  ),
  '223796X114X1668' => 
  array (
    'description' => '<strong>Wat is de naam van deze plek?</strong>',
    'stripped_description' => 'Wat is de naam van deze plek?',
    'core_description' => 'Wat is de naam van deze plek?',
    'type' => 'T',
    'group_name' => 'Prioriteiten',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 8,
    'main_question' => 1,
  ),
  '223796X114X1696' => 
  array (
    'description' => 'Interpretatie Naam Plek 1',
    'stripped_description' => 'Interpretatie Naam Plek 1',
    'core_description' => 'Interpretatie Naam Plek 1',
    'type' => 'T',
    'group_name' => 'Prioriteiten',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 9,
    'main_question' => 1,
  ),
  '223796X114X1669' => 
  array (
    'description' => '<strong>Als je nog een belangrijke locatie hebt, wijs deze aan.</strong><br />
(Voor het geval je later nog meer locaties wilt opgeven dan is dat altijd mogelijk.)',
    'stripped_description' => 'Als je nog een belangrijke locatie hebt, wijs deze aan. (Voor het geval je later nog meer locaties wilt opgeven dan is dat altijd mogelijk.)',
    'core_description' => 'Als je nog een belangrijke locatie hebt, wijs deze aan.',
    'type' => 'S',
    'group_name' => 'Prioriteiten',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '0',
    'extra' => '52.361814 4.939646 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 10,
    'main_question' => 1,
  ),
  '223796X114X1690' => 
  array (
    'description' => '<strong>Wat is de naam van deze plek?</strong>',
    'stripped_description' => 'Wat is de naam van deze plek?',
    'core_description' => 'Wat is de naam van deze plek?',
    'type' => 'T',
    'group_name' => 'Prioriteiten',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 11,
    'main_question' => 1,
  ),
  '223796X114X1697' => 
  array (
    'description' => 'Interpretatie Naam Plek 2',
    'stripped_description' => 'Interpretatie Naam Plek 2',
    'core_description' => 'Interpretatie Naam Plek 2',
    'type' => 'T',
    'group_name' => 'Prioriteiten',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 12,
    'main_question' => 1,
  ),
  '223796X115X1670' => 
  array (
    'description' => '<strong>Over welke thema\'s zou je willen meepraten?</strong>',
    'stripped_description' => 'Over welke thema\'s zou je willen meepraten?',
    'core_description' => 'Over welke thema\'s zou je willen meepraten?',
    'type' => 'M',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQ1',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'meerkeuze',
    'mandatory' => 'N',
    'question_nr' => 13,
    'main_question' => 1,
  ),
  '223796X115X1670SQ001' => 
  array (
    'description' => '<strong>Armoede</strong>',
    'stripped_description' => 'Armoede',
    'core_description' => 'Armoede',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ002' => 
  array (
    'description' => '<strong>Eenzaamheid</strong>',
    'stripped_description' => 'Eenzaamheid',
    'core_description' => 'Eenzaamheid',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ003' => 
  array (
    'description' => '<strong>Lokale democratie</strong>',
    'stripped_description' => 'Lokale democratie',
    'core_description' => 'Lokale democratie',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ004' => 
  array (
    'description' => '<strong>Jeugd en onderwijs</strong>',
    'stripped_description' => 'Jeugd en onderwijs',
    'core_description' => 'Jeugd en onderwijs',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ005' => 
  array (
    'description' => '<strong>Gezondheid en zorg</strong>',
    'stripped_description' => 'Gezondheid en zorg',
    'core_description' => 'Gezondheid en zorg',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ006' => 
  array (
    'description' => '<strong>Duurzaamheid</strong>',
    'stripped_description' => 'Duurzaamheid',
    'core_description' => 'Duurzaamheid',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ007' => 
  array (
    'description' => '<strong>Veiligheid en openbare orde</strong>',
    'stripped_description' => 'Veiligheid en openbare orde',
    'core_description' => 'Veiligheid en openbare orde',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ008' => 
  array (
    'description' => '<strong>Diversiteit</strong>',
    'stripped_description' => 'Diversiteit',
    'core_description' => 'Diversiteit',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ009' => 
  array (
    'description' => '<strong>Werk en economie</strong>',
    'stripped_description' => 'Werk en economie',
    'core_description' => 'Werk en economie',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ010' => 
  array (
    'description' => '<strong>Ontmoeting en sociale cohesie</strong>',
    'stripped_description' => 'Ontmoeting en sociale cohesie',
    'core_description' => 'Ontmoeting en sociale cohesie',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ011' => 
  array (
    'description' => '<strong>Kunst en cultuur</strong>',
    'stripped_description' => 'Kunst en cultuur',
    'core_description' => 'Kunst en cultuur',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1670SQ012' => 
  array (
    'description' => '<strong>Verkeer en wonen</strong>',
    'stripped_description' => 'Verkeer en wonen',
    'core_description' => 'Verkeer en wonen',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '223796X115X1670',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1682' => 
  array (
    'description' => 'We zijn benieuwd welke ideeën bewoners en bezoekers hebben om een probleem/thema aan te pakken. <strong>Heb jij een idee over de aanpak van een probleem/thema?</strong>',
    'stripped_description' => 'We zijn benieuwd welke ideeën bewoners en bezoekers hebben om een probleem/thema aan te pakken. Heb jij een idee over de aanpak van een probleem/thema?',
    'core_description' => 'Heb jij een idee over de aanpak van een probleem/thema?',
    'type' => 'Y',
    'group_name' => 'Thema\'s',
    'hqtype' => 'YSNO',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'keuze',
    'mandatory' => 'N',
    'question_nr' => 14,
    'main_question' => 1,
  ),
  '223796X115X1683' => 
  array (
    'description' => '<strong>Is jouw idee te koppelen aan een locatie op de kaart?</strong> Zo ja, wijs de locatie aan op de kaart. Als er geen locatie bij hoort, sla deze vraag dan over.',
    'stripped_description' => 'Is jouw idee te koppelen aan een locatie op de kaart? Zo ja, wijs de locatie aan op de kaart. Als er geen locatie bij hoort, sla deze vraag dan over.',
    'core_description' => 'Is jouw idee te koppelen aan een locatie op de kaart?',
    'type' => 'S',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '0',
    'extra' => '52.361814 4.939646 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 15,
    'main_question' => 1,
  ),
  '223796X115X1691' => 
  array (
    'description' => '<strong>Wat is de naam van de locatie waar je jouw idee kunt uitvoeren?</strong> Dit kan de naam van een school, park, straat, plein, winkel of wat dan ook zijn. Meer locaties invullen kan aan tafel. Vul voor nu de belangrijkste locatie in.',
    'stripped_description' => 'Wat is de naam van de locatie waar je jouw idee kunt uitvoeren? Dit kan de naam van een school, park, straat, plein, winkel of wat dan ook zijn. Meer locaties invullen kan aan tafel. Vul voor nu de belangrijkste locatie in.',
    'core_description' => 'Wat is de naam van de locatie waar je jouw idee kunt uitvoeren?',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 16,
    'main_question' => 1,
  ),
  '223796X115X1694' => 
  array (
    'description' => 'Wat is je idee? <strong>Ik wil dat er ...</strong>',
    'stripped_description' => 'Wat is je idee? Ik wil dat er ...',
    'core_description' => 'Ik wil dat er ...',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 17,
    'main_question' => 1,
  ),
  '223796X115X1695' => 
  array (
    'description' => 'Interpretatie idee: ik wil dat er ...',
    'stripped_description' => 'Interpretatie idee: ik wil dat er ...',
    'core_description' => 'Interpretatie idee: ik wil dat er ...',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 18,
    'main_question' => 1,
  ),
  '223796X115X1684' => 
  array (
    'description' => 'Vul de volgende zin aan.<strong> Als we jouw idee uitvoeren dan zorgt dat ervoor dat ...</strong>',
    'stripped_description' => 'Vul de volgende zin aan. Als we jouw idee uitvoeren dan zorgt dat ervoor dat ...',
    'core_description' => ' Als we jouw idee uitvoeren dan zorgt dat ervoor dat ...',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 19,
    'main_question' => 1,
  ),
  '223796X115X1693' => 
  array (
    'description' => '<strong>Interpretatie</strong>: Als we jouw idee uitvoeren dan zorgt dat ervoor dat ..',
    'stripped_description' => 'Interpretatie: Als we jouw idee uitvoeren dan zorgt dat ervoor dat ..',
    'core_description' => 'Interpretatie',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 20,
    'main_question' => 1,
  ),
  '223796X115X1685' => 
  array (
    'description' => 'Mogelijk heb je dit idee al eerder ingebracht of heb je al langer over het idee nagedacht of gelezen. We willen zoveel mogelijk van je idee weten. <strong>Upload eventueel een foto, document of krantenartikel dat bij jouw idee hoort.</strong> ',
    'stripped_description' => 'Mogelijk heb je dit idee al eerder ingebracht of heb je al langer over het idee nagedacht of gelezen. We willen zoveel mogelijk van je idee weten. Upload eventueel een foto, document of krantenartikel dat bij jouw idee hoort. ',
    'core_description' => 'Upload eventueel een foto, document of krantenartikel dat bij jouw idee hoort.',
    'type' => '|',
    'group_name' => 'Thema\'s',
    'hqtype' => 'UPLD',
    '1sttimeonly' => '0',
    'extra' => 'png, gif, doc, odt, jpg, pdf, jpeg,docx',
    'meaning_extra' => 'allowed_filetypes',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'upload',
    'mandatory' => 'N',
    'question_nr' => 21,
    'main_question' => 1,
  ),
  '223796X115X1685_filecount' => 
  array (
    'description' => 'Mogelijk heb je dit idee al eerder ingebracht of heb je al langer over het idee nagedacht of gelezen. We willen zoveel mogelijk van je idee weten. <strong>Upload eventueel een foto, document of krantenartikel dat bij jouw idee hoort.</strong> ',
    'stripped_description' => 'Mogelijk heb je dit idee al eerder ingebracht of heb je al langer over het idee nagedacht of gelezen. We willen zoveel mogelijk van je idee weten. Upload eventueel een foto, document of krantenartikel dat bij jouw idee hoort. ',
    'core_description' => 'Upload eventueel een foto, document of krantenartikel dat bij jouw idee hoort.',
    'type' => '|',
    'group_name' => 'Thema\'s',
    'hqtype' => 'FCNT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '223796X115X1687' => 
  array (
    'description' => 'Mogelijk is er een link naar een artikel, facebookpost, linked-in artikl, boek of tijdschrift die bij je idee past. <strong>Vul deze link hier in.</strong>',
    'stripped_description' => 'Mogelijk is er een link naar een artikel, facebookpost, linked-in artikl, boek of tijdschrift die bij je idee past. Vul deze link hier in.',
    'core_description' => 'Vul deze link hier in.',
    'type' => 'T',
    'group_name' => 'Thema\'s',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 22,
    'main_question' => 1,
  ),
  '223796X116X1689' => 
  array (
    'description' => '<p>Bedankt voor je deelname. Mogelijk zijn we een vraag vergeten of wil je nog iets aan ons meegeven.</p>
 
<p><strong>Ik wil jullie het volgende laten weten:</strong></p>
',
    'stripped_description' => 'Bedankt voor je deelname. Mogelijk zijn we een vraag vergeten of wil je nog iets aan ons meegeven. Ik wil jullie het volgende laten weten:',
    'core_description' => 'Ik wil jullie het volgende laten weten:',
    'type' => 'T',
    'group_name' => 'Afsluiting',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 23,
    'main_question' => 1,
  ),
)

Qnrs

array (
  0 => 
  array (
    'label' => 'OBJECT',
    'org' => '16',
    'int' => '99',
  ),
  1 => 
  array (
    'label' => 'IDEA',
    'org' => '17',
    'int' => '18',
  ),
  2 => 
  array (
    'label' => 'GOAL',
    'org' => '19',
    'int' => '20',
  ),
)

Qcols

array (
  0 => 
  array (
    'label' => 'OBJECT',
    'org' => '223796X115X1691',
    'int' => '99',
  ),
  1 => 
  array (
    'label' => 'IDEA',
    'org' => '223796X115X1694',
    'int' => '223796X115X1695',
  ),
  2 => 
  array (
    'label' => 'GOAL',
    'org' => '223796X115X1684',
    'int' => '223796X115X1693',
  ),
)