<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Group</LimeSurveyDocType>
 <DBVersion>164</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[27]]></gid>
    <sid><![CDATA[612676]]></sid>
    <group_name><![CDATA[Test Group 01]]></group_name>
    <group_order><![CDATA[16]]></group_order>
    <description><![CDATA[This is the first group.]]></description>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[1408]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[612676]]></sid>
    <gid><![CDATA[27]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[ALC_WKUSE]]></title>
    <question><![CDATA[On average, how many days a week do you have an alcoholic beverage?]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[612676]]></sid>
    <gid><![CDATA[27]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[ALC_DAYUSE]]></title>
    <question><![CDATA[On a typical drinking day, how many drinks* do you have?<br />
<br />
* A standard drink is defined as one 12-ounce bottle of beer, one 5-ounce glass of wine or 1.5 ounces of distilled spirits.]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[((TOKEN:ATTRIBUTE_1 == "1"))]]></relevance>
   </row>
   <row>
    <qid><![CDATA[1410]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[612676]]></sid>
    <gid><![CDATA[27]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[ALC_AUDITC1]]></title>
    <question><![CDATA[<p>
	How often did you have a drink* containing alcohol in the past year?</p>
<p>
	 </p>
<p>
	 </p>
]]></question>
    <preg/>
    <help><![CDATA[<p>
	<span style="font-size:16px;">* A standard drink is defined as one 12-ounce bottle of beer, one 5-ounce glass of wine or 1.5 ounces of distilled spirits.</span></p>
]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[6]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[((ALC_WKUSE.value * ALC_DAYUSE.value >= 14))]]></relevance>
   </row>
  </rows>
 </questions>
 <answers>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[1410]]></qid>
    <code><![CDATA[A1]]></code>
    <answer><![CDATA[Never ]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1410]]></qid>
    <code><![CDATA[A2]]></code>
    <answer><![CDATA[Monthly or less]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1410]]></qid>
    <code><![CDATA[A3]]></code>
    <answer><![CDATA[2 to 4 times per month]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1410]]></qid>
    <code><![CDATA[A4]]></code>
    <answer><![CDATA[2 to 3 times per week]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1410]]></qid>
    <code><![CDATA[A5]]></code>
    <answer><![CDATA[4 or more times per week]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A1]]></code>
    <answer><![CDATA[1 drink]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A2]]></code>
    <answer><![CDATA[2 drinks]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[2]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A3]]></code>
    <answer><![CDATA[3 drinks]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[3]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A4]]></code>
    <answer><![CDATA[4 drinks]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[4]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A5]]></code>
    <answer><![CDATA[5 drinks]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[5]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A6]]></code>
    <answer><![CDATA[6 drinks]]></answer>
    <sortorder><![CDATA[6]]></sortorder>
    <assessment_value><![CDATA[6]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A7]]></code>
    <answer><![CDATA[7 drinks]]></answer>
    <sortorder><![CDATA[7]]></sortorder>
    <assessment_value><![CDATA[7]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A8]]></code>
    <answer><![CDATA[8 drinks]]></answer>
    <sortorder><![CDATA[8]]></sortorder>
    <assessment_value><![CDATA[8]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <code><![CDATA[A9]]></code>
    <answer><![CDATA[9 or more drinks]]></answer>
    <sortorder><![CDATA[9]]></sortorder>
    <assessment_value><![CDATA[9]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1408]]></qid>
    <code><![CDATA[A1]]></code>
    <answer><![CDATA[No days]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1408]]></qid>
    <code><![CDATA[A2]]></code>
    <answer><![CDATA[1 day]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1408]]></qid>
    <code><![CDATA[A3]]></code>
    <answer><![CDATA[2 days]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[2]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1408]]></qid>
    <code><![CDATA[A4]]></code>
    <answer><![CDATA[3 days]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[3]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1408]]></qid>
    <code><![CDATA[A5]]></code>
    <answer><![CDATA[4 days]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[4]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[1408]]></qid>
    <code><![CDATA[A6]]></code>
    <answer><![CDATA[5 days]]></answer>
    <sortorder><![CDATA[6]]></sortorder>
    <assessment_value><![CDATA[5]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[1408]]></qid>
    <attribute><![CDATA[hide_tip]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <attribute><![CDATA[display_columns]]></attribute>
    <value><![CDATA[3]]></value>
   </row>
   <row>
    <qid><![CDATA[1409]]></qid>
    <attribute><![CDATA[hide_tip]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[1410]]></qid>
    <attribute><![CDATA[hide_tip]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
  </rows>
 </question_attributes>
</document>
<script type="text/javascript">
/*<![CDATA[*/
if(typeof(console)=='object')
{
	console.group("Application Log");
	console.log("[06:59:15.262][trace][system.db.CDbConnection] Opening DB connection");
	console.log("[06:59:15.269][trace][system.db.CDbCommand] Querying SQL: SHOW COLUMNS FROM `lime_settings_global`");
	console.log("[06:59:15.280][trace][system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_settings_global`");
	console.log("[06:59:15.280][trace][system.db.ar.CActiveRecord] Settings_global.findAll()");
	console.log("[06:59:15.283][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t`");
	console.log("[06:59:15.335][trace][system.db.CDbCommand] Querying SQL: SHOW COLUMNS FROM `lime_surveys`");
	console.log("[06:59:15.349][trace][system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys`");
	console.log("[06:59:15.366][trace][system.db.ar.CActiveRecord] Survey.findByPk()");
	console.log("[06:59:15.366][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=612676 LIMIT 1");
	console.log("[06:59:15.368][trace][system.db.CDbCommand] Querying SQL: SHOW COLUMNS FROM `lime_groups`");
	console.log("[06:59:15.375][trace][system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_groups`");
	console.log("[06:59:15.375][trace][system.db.ar.CActiveRecord] Groups.findAllByAttributes()");
	console.log("[06:59:15.375][trace][system.db.CDbCommand] Querying SQL: SELECT language FROM `lime_groups` `t` WHERE `t`.`gid`=:yp0 GROUP BY language. Bound with :yp0=\'27\'");
	console.log("[06:59:15.375][trace][system.db.CDbCommand] Querying SQL: SELECT *\n    FROM lime_groups\n    WHERE gid=27");
	console.log("[06:59:15.376][trace][system.db.CDbCommand] Querying SQL: SELECT *\n    FROM lime_questions\n    WHERE gid=27 and parent_qid=0 order by question_order, language, scale_id");
	console.log("[06:59:15.377][trace][system.db.CDbCommand] Querying SQL: SELECT *\n    FROM lime_questions\n    WHERE gid=27 and parent_qid>0 order by question_order, language, scale_id");
	console.log("[06:59:15.377][trace][system.db.CDbCommand] Querying SQL: SELECT DISTINCT lime_answers.*\n    FROM lime_answers, lime_questions\n    WHERE (lime_answers.qid=lime_questions.qid)\n    AND (lime_questions.gid=27)");
	console.log("[06:59:15.385][trace][system.db.CDbCommand] Querying SQL: SELECT DISTINCT c.*\n    FROM lime_conditions c, lime_questions q, lime_questions b\n    WHERE (c.cqid=q.qid)\n    AND (c.qid=b.qid)\n    AND (q.gid=27)\n    AND (b.gid=27)");
	console.log("[06:59:15.386][trace][system.db.CDbCommand] Querying SQL: select sid from lime_groups where gid=27");
	console.log("[06:59:15.386][trace][system.db.CDbCommand] Querying SQL: SELECT qa.qid, qa.attribute, qa.value, qa.language\n        FROM lime_question_attributes qa JOIN lime_questions  q ON q.qid = qa.qid AND q.sid=612676 and q.gid=27\n        where q.language=\'en\' group by qa.qid, qa.attribute, qa.value, qa.language");
	console.log("[06:59:15.394][trace][system.db.CDbCommand] Querying SQL: SELECT dv.*\n    FROM lime_defaultvalues dv\n    JOIN lime_questions ON lime_questions.qid = dv.qid\n    AND lime_questions.language=dv.language\n    AND lime_questions.gid=27\n    order by dv.language, dv.scale_id");
	console.groupEnd();
}
/*]]>*/
</script>