Survey 171 en qid code answer sortorder assessment_value language scale_id gid sid group_name group_order description language randomization_group grelevance qid parent_qid sid gid type title question preg help other mandatory question_order language scale_id same_default relevance <![CDATA[q1]]> <![CDATA[q2]]> <![CDATA[q3]]> sid admin expires startdate adminemail anonymized faxto format savetimings template language additional_languages datestamp usecookie allowregister allowsave autonumber_start autoredirect allowprev printanswers ipaddr refurl publicstatistics publicgraphs listpublic htmlemail sendconfirmation tokenanswerspersistence assessments usecaptcha usetokens bounce_email attributedescriptions emailresponseto emailnotificationto tokenlength showxquestions showgroupinfo shownoanswer showqnumcode bouncetime bounceprocessing bounceaccounttype bounceaccounthost bounceaccountpass bounceaccountencryption bounceaccountuser showwelcome showprogress navigationdelay nokeyboard alloweditaftercompletion googleanalyticsstyle googleanalyticsapikey questionindex surveyls_survey_id surveyls_language surveyls_title surveyls_description surveyls_welcometext surveyls_endtext surveyls_url surveyls_urldescription surveyls_email_invite_subj surveyls_email_invite surveyls_email_remind_subj surveyls_email_remind surveyls_email_register_subj surveyls_email_register surveyls_email_confirm_subj surveyls_email_confirm surveyls_dateformat surveyls_attributecaptions email_admin_notification_subj email_admin_notification email_admin_responses_subj email_admin_responses surveyls_numberformat attachments
you have been invited to participate in a survey.

The survey is titled:
"{SURVEYNAME}"

"{SURVEYDESCRIPTION}"

To participate, please click on the link below.

Sincerely,

{ADMINNAME} ({ADMINEMAIL})

----------------------------------------------
Click here to do the survey:
{SURVEYURL}

If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:
{OPTOUTURL}

If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:
{OPTINURL}]]>
Recently we invited you to participate in a survey.

We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.

The survey is titled:
"{SURVEYNAME}"

"{SURVEYDESCRIPTION}"

To participate, please click on the link below.

Sincerely,

{ADMINNAME} ({ADMINEMAIL})

----------------------------------------------
Click here to do the survey:
{SURVEYURL}

If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:
{OPTOUTURL}]]>
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.

To complete this survey, click on the following URL:

{SURVEYURL}

If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]>
this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.

If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.

Sincerely,

{ADMINNAME}]]>
A new response was submitted for your survey '{SURVEYNAME}'.

Click the following link to reload the survey:
{RELOADURL}

Click the following link to see the individual response:
{VIEWRESPONSEURL}

Click the following link to edit the individual response:
{EDITRESPONSEURL}

View statistics by clicking here:
{STATISTICSURL}]]>
A new response was submitted for your survey '{SURVEYNAME}'.

Click the following link to reload the survey:
{RELOADURL}

Click the following link to see the individual response:
{VIEWRESPONSEURL}

Click the following link to edit the individual response:
{EDITRESPONSEURL}

View statistics by clicking here:
{STATISTICSURL}


The following answers were given by the participant:
{ANSWERTABLE}]]>
Application Log
Timestamp Level Category Message
20:48:02.954133 trace system.CModule 
Loading "log" application component
20:48:02.956134 trace system.CModule 
Loading "request" application component
20:48:02.959134 trace system.CModule 
Loading "assetManager" application component
20:48:02.963135 trace system.db.ar.CActiveRecord 
Plugin.findAllByAttributes()
20:48:02.963135 trace system.CModule 
Loading "db" application component
20:48:02.964134 trace system.db.CDbConnection 
Opening DB connection
20:48:02.979135 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `lime_plugins`
20:48:02.979135 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)
20:48:02.984136 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)
20:48:02.985136 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `lime_plugins`
20:48:02.985136 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)
20:48:02.985136 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)
20:48:02.986135 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0.
Bound with :yp0=1
20:48:02.986135 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE
`t`.`active`=:yp0. Bound with :yp0=1)
20:48:02.986135 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE
`t`.`active`=:yp0. Bound with :yp0=1)
20:48:02.988136 trace system.CModule 
Loading "urlManager" application component
20:48:02.990135 trace system.CModule 
Loading "session" application component
20:48:02.999136 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `lime_settings_global`
20:48:02.999136 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`lime_settings_global`)
20:48:03.004137 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`lime_settings_global`)
20:48:03.004137 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `lime_settings_global`
20:48:03.004137 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)
20:48:03.004137 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)
20:48:03.005136 trace system.db.ar.CActiveRecord 
SettingGlobal.findAll()
20:48:03.005136 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `lime_settings_global` `t`
20:48:03.005136 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)
20:48:03.005136 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)
20:48:03.026138 trace system.CModule 
Loading "bootstrap" application component
20:48:03.026138 trace system.CModule 
Loading "clientScript" application component
20:48:03.027137 trace system.CModule 
Loading "user" application component
20:48:03.029138 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys`
20:48:03.029138 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)
20:48:03.034138 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)
20:48:03.034138 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `lime_surveys`
20:48:03.034138 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)
20:48:03.034138 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)
20:48:03.039139 trace system.db.ar.CActiveRecord 
Survey.findByPk()
20:48:03.039139 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=673882 LIMIT
1
20:48:03.039139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE
`t`.`sid`=673882 LIMIT 1)
20:48:03.039139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE
`t`.`sid`=673882 LIMIT 1)
20:48:03.040138 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `lime_permissions`
20:48:03.040138 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)
20:48:03.043138 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)
20:48:03.043138 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `lime_permissions`
20:48:03.043138 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)
20:48:03.043138 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)
20:48:03.044138 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`
20:48:03.044138 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`lime_surveys_languagesettings`)
20:48:03.046139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`lime_surveys_languagesettings`)
20:48:03.046139 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `lime_surveys_languagesettings`
20:48:03.046139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE
`lime_surveys_languagesettings`)
20:48:03.046139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE
`lime_surveys_languagesettings`)
20:48:03.047138 trace system.db.ar.CActiveRecord 
SurveyLanguageSetting.findByPk()
20:48:03.048139 trace system.db.CDbCommand 
Querying SQL: SELECT `t`.`surveyls_survey_id` AS `t0_c0`,
`t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS `t0_c2`,
`t`.`surveyls_description` AS `t0_c3`, `t`.`surveyls_welcometext` AS
`t0_c4`, `t`.`surveyls_endtext` AS `t0_c5`, `t`.`surveyls_url` AS `t0_c6`,
`t`.`surveyls_urldescription` AS `t0_c7`, `t`.`surveyls_email_invite_subj`
AS `t0_c8`, `t`.`surveyls_email_invite` AS `t0_c9`,
`t`.`surveyls_email_remind_subj` AS `t0_c10`, `t`.`surveyls_email_remind`
AS `t0_c11`, `t`.`surveyls_email_register_subj` AS `t0_c12`,
`t`.`surveyls_email_register` AS `t0_c13`,
`t`.`surveyls_email_confirm_subj` AS `t0_c14`, `t`.`surveyls_email_confirm`
AS `t0_c15`, `t`.`surveyls_dateformat` AS `t0_c16`,
`t`.`surveyls_attributecaptions` AS `t0_c17`,
`t`.`email_admin_notification_subj` AS `t0_c18`,
`t`.`email_admin_notification` AS `t0_c19`,
`t`.`email_admin_responses_subj` AS `t0_c20`, `t`.`email_admin_responses`
AS `t0_c21`, `t`.`surveyls_numberformat` AS `t0_c22`, `t`.`attachments` AS
`t0_c23`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`,
`survey`.`admin` AS `t1_c2`, `survey`.`active` AS `t1_c3`,
`survey`.`expires` AS `t1_c4`, `survey`.`startdate` AS `t1_c5`,
`survey`.`adminemail` AS `t1_c6`, `survey`.`anonymized` AS `t1_c7`,
`survey`.`faxto` AS `t1_c8`, `survey`.`format` AS `t1_c9`,
`survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`,
`survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS
`t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS
`t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS
`t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect`
AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS
`t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`refurl` AS `t1_c23`,
`survey`.`datecreated` AS `t1_c24`, `survey`.`publicstatistics` AS
`t1_c25`, `survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS
`t1_c27`, `survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS
`t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`,
`survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`,
`survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`,
`survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto` AS
`t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`,
`survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS `t1_c39`,
`survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer` AS `t1_c41`,
`survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime` AS `t1_c43`,
`survey`.`bounceprocessing` AS `t1_c44`, `survey`.`bounceaccounttype` AS
`t1_c45`, `survey`.`bounceaccounthost` AS `t1_c46`,
`survey`.`bounceaccountpass` AS `t1_c47`,
`survey`.`bounceaccountencryption` AS `t1_c48`,
`survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS
`t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`navigationdelay`
AS `t1_c52`, `survey`.`nokeyboard` AS `t1_c53`,
`survey`.`alloweditaftercompletion` AS `t1_c54`,
`survey`.`googleanalyticsstyle` AS `t1_c55`,
`survey`.`googleanalyticsapikey` AS `t1_c56`, `survey`.`questionindex` AS
`t1_c57` FROM `lime_surveys_languagesettings` `t`  LEFT OUTER JOIN
`lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid)  WHERE
(`t`.`surveyls_survey_id`=673882 AND `t`.`surveyls_language`='en')
20:48:03.048139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS
`t0_c0`, `t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS
`t0_c2`, `t`.`surveyls_description` AS `t0_c3`, `t`.`surveyls_welcometext`
AS `t0_c4`, `t`.`surveyls_endtext` AS `t0_c5`, `t`.`surveyls_url` AS
`t0_c6`, `t`.`surveyls_urldescription` AS `t0_c7`,
`t`.`surveyls_email_invite_subj` AS `t0_c8`, `t`.`surveyls_email_invite` AS
`t0_c9`, `t`.`surveyls_email_remind_subj` AS `t0_c10`,
`t`.`surveyls_email_remind` AS `t0_c11`, `t`.`surveyls_email_register_subj`
AS `t0_c12`, `t`.`surveyls_email_register` AS `t0_c13`,
`t`.`surveyls_email_confirm_subj` AS `t0_c14`, `t`.`surveyls_email_confirm`
AS `t0_c15`, `t`.`surveyls_dateformat` AS `t0_c16`,
`t`.`surveyls_attributecaptions` AS `t0_c17`,
`t`.`email_admin_notification_subj` AS `t0_c18`,
`t`.`email_admin_notification` AS `t0_c19`,
`t`.`email_admin_responses_subj` AS `t0_c20`, `t`.`email_admin_responses`
AS `t0_c21`, `t`.`surveyls_numberformat` AS `t0_c22`, `t`.`attachments` AS
`t0_c23`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`,
`survey`.`admin` AS `t1_c2`, `survey`.`active` AS `t1_c3`,
`survey`.`expires` AS `t1_c4`, `survey`.`startdate` AS `t1_c5`,
`survey`.`adminemail` AS `t1_c6`, `survey`.`anonymized` AS `t1_c7`,
`survey`.`faxto` AS `t1_c8`, `survey`.`format` AS `t1_c9`,
`survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`,
`survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS
`t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS
`t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS
`t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect`
AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS
`t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`refurl` AS `t1_c23`,
`survey`.`datecreated` AS `t1_c24`, `survey`.`publicstatistics` AS
`t1_c25`, `survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS
`t1_c27`, `survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS
`t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`,
`survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`,
`survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`,
`survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto` AS
`t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`,
`survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS `t1_c39`,
`survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer` AS `t1_c41`,
`survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime` AS `t1_c43`,
`survey`.`bounceprocessing` AS `t1_c44`, `survey`.`bounceaccounttype` AS
`t1_c45`, `survey`.`bounceaccounthost` AS `t1_c46`,
`survey`.`bounceaccountpass` AS `t1_c47`,
`survey`.`bounceaccountencryption` AS `t1_c48`,
`survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS
`t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`navigationdelay`
AS `t1_c52`, `survey`.`nokeyboard` AS `t1_c53`,
`survey`.`alloweditaftercompletion` AS `t1_c54`,
`survey`.`googleanalyticsstyle` AS `t1_c55`,
`survey`.`googleanalyticsapikey` AS `t1_c56`, `survey`.`questionindex` AS
`t1_c57` FROM `lime_surveys_languagesettings` `t`  LEFT OUTER JOIN
`lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid)  WHERE
(`t`.`surveyls_survey_id`=673882 AND `t`.`surveyls_language`='en'))
20:48:03.049139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS `t0_c0`,
`t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS `t0_c2`,
`t`.`surveyls_description` AS `t0_c3`, `t`.`surveyls_welcometext` AS
`t0_c4`, `t`.`surveyls_endtext` AS `t0_c5`, `t`.`surveyls_url` AS `t0_c6`,
`t`.`surveyls_urldescription` AS `t0_c7`, `t`.`surveyls_email_invite_subj`
AS `t0_c8`, `t`.`surveyls_email_invite` AS `t0_c9`,
`t`.`surveyls_email_remind_subj` AS `t0_c10`, `t`.`surveyls_email_remind`
AS `t0_c11`, `t`.`surveyls_email_register_subj` AS `t0_c12`,
`t`.`surveyls_email_register` AS `t0_c13`,
`t`.`surveyls_email_confirm_subj` AS `t0_c14`, `t`.`surveyls_email_confirm`
AS `t0_c15`, `t`.`surveyls_dateformat` AS `t0_c16`,
`t`.`surveyls_attributecaptions` AS `t0_c17`,
`t`.`email_admin_notification_subj` AS `t0_c18`,
`t`.`email_admin_notification` AS `t0_c19`,
`t`.`email_admin_responses_subj` AS `t0_c20`, `t`.`email_admin_responses`
AS `t0_c21`, `t`.`surveyls_numberformat` AS `t0_c22`, `t`.`attachments` AS
`t0_c23`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`,
`survey`.`admin` AS `t1_c2`, `survey`.`active` AS `t1_c3`,
`survey`.`expires` AS `t1_c4`, `survey`.`startdate` AS `t1_c5`,
`survey`.`adminemail` AS `t1_c6`, `survey`.`anonymized` AS `t1_c7`,
`survey`.`faxto` AS `t1_c8`, `survey`.`format` AS `t1_c9`,
`survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`,
`survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS
`t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS
`t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS
`t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect`
AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS
`t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`refurl` AS `t1_c23`,
`survey`.`datecreated` AS `t1_c24`, `survey`.`publicstatistics` AS
`t1_c25`, `survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS
`t1_c27`, `survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS
`t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`,
`survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`,
`survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`,
`survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto` AS
`t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`,
`survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS `t1_c39`,
`survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer` AS `t1_c41`,
`survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime` AS `t1_c43`,
`survey`.`bounceprocessing` AS `t1_c44`, `survey`.`bounceaccounttype` AS
`t1_c45`, `survey`.`bounceaccounthost` AS `t1_c46`,
`survey`.`bounceaccountpass` AS `t1_c47`,
`survey`.`bounceaccountencryption` AS `t1_c48`,
`survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS
`t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`navigationdelay`
AS `t1_c52`, `survey`.`nokeyboard` AS `t1_c53`,
`survey`.`alloweditaftercompletion` AS `t1_c54`,
`survey`.`googleanalyticsstyle` AS `t1_c55`,
`survey`.`googleanalyticsapikey` AS `t1_c56`, `survey`.`questionindex` AS
`t1_c57` FROM `lime_surveys_languagesettings` `t`  LEFT OUTER JOIN
`lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid)  WHERE
(`t`.`surveyls_survey_id`=673882 AND `t`.`surveyls_language`='en'))
20:48:03.049139 trace system.db.ar.CActiveRecord 
Permission.findByAttributes()
20:48:03.049139 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `lime_permissions` `t` WHERE
`t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND
`t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin'
20:48:03.049139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE
`t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND
`t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin')
20:48:03.049139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE
`t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND
`t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin')
20:48:03.055140 trace system.db.CDbCommand 
Querying SQL: SELECT lime_answers.*
        FROM lime_answers, lime_questions
        WHERE lime_answers.language=lime_questions.language
        AND lime_answers.qid=lime_questions.qid
        AND lime_questions.sid=673882
20:48:03.055140 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT lime_answers.*
        FROM lime_answers, lime_questions
        WHERE lime_answers.language=lime_questions.language
        AND lime_answers.qid=lime_questions.qid
        AND lime_questions.sid=673882)
20:48:03.055140 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT lime_answers.*
        FROM lime_answers, lime_questions
        WHERE lime_answers.language=lime_questions.language
        AND lime_answers.qid=lime_questions.qid
        AND lime_questions.sid=673882)
20:48:03.055140 trace system.db.CDbCommand 
Querying SQL: SELECT lime_assessments.*
    FROM lime_assessments
    WHERE lime_assessments.sid=673882
20:48:03.055140 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT lime_assessments.*
    FROM lime_assessments
    WHERE lime_assessments.sid=673882)
20:48:03.055140 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT lime_assessments.*
    FROM lime_assessments
    WHERE lime_assessments.sid=673882)
20:48:03.055140 trace system.db.CDbCommand 
Querying SQL: SELECT DISTINCT lime_conditions.*
        FROM lime_conditions, lime_questions
        WHERE lime_conditions.qid=lime_questions.qid
        AND lime_questions.sid=673882
20:48:03.055140 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT DISTINCT lime_conditions.*
        FROM lime_conditions, lime_questions
        WHERE lime_conditions.qid=lime_questions.qid
        AND lime_questions.sid=673882)
20:48:03.056139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT DISTINCT lime_conditions.*
        FROM lime_conditions, lime_questions
        WHERE lime_conditions.qid=lime_questions.qid
        AND lime_questions.sid=673882)
20:48:03.056139 trace system.db.CDbCommand 
Querying SQL: SELECT lime_defaultvalues.*
    FROM lime_defaultvalues JOIN lime_questions ON lime_questions.qid =
lime_defaultvalues.qid AND lime_questions.sid=673882 AND
lime_questions.language=lime_defaultvalues.language
20:48:03.056139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT lime_defaultvalues.*
    FROM lime_defaultvalues JOIN lime_questions ON lime_questions.qid =
lime_defaultvalues.qid AND lime_questions.sid=673882 AND
lime_questions.language=lime_defaultvalues.language )
20:48:03.056139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT lime_defaultvalues.*
    FROM lime_defaultvalues JOIN lime_questions ON lime_questions.qid =
lime_defaultvalues.qid AND lime_questions.sid=673882 AND
lime_questions.language=lime_defaultvalues.language )
20:48:03.056139 trace system.db.CDbCommand 
Querying SQL: SELECT *
    FROM lime_groups
    WHERE sid=673882
    ORDER BY gid
20:48:03.056139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT *
    FROM lime_groups
    WHERE sid=673882
    ORDER BY gid)
20:48:03.056139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT *
    FROM lime_groups
    WHERE sid=673882
    ORDER BY gid)
20:48:03.056139 trace system.db.CDbCommand 
Querying SQL: SELECT *
    FROM lime_questions
    WHERE sid=673882 and parent_qid=0
    ORDER BY qid
20:48:03.056139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT *
    FROM lime_questions
    WHERE sid=673882 and parent_qid=0
    ORDER BY qid)
20:48:03.056139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT *
    FROM lime_questions
    WHERE sid=673882 and parent_qid=0
    ORDER BY qid)
20:48:03.056139 trace system.db.CDbCommand 
Querying SQL: SELECT *
    FROM lime_questions
    WHERE sid=673882 and parent_qid>0
    ORDER BY qid
20:48:03.056139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT *
    FROM lime_questions
    WHERE sid=673882 and parent_qid>0
    ORDER BY qid)
20:48:03.056139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT *
    FROM lime_questions
    WHERE sid=673882 and parent_qid>0
    ORDER BY qid)
20:48:03.056139 trace system.db.CDbCommand 
Querying SQL: SELECT qa.qid, qa.attribute, qa.value, qa.language
        FROM lime_question_attributes qa JOIN lime_questions  q ON q.qid =
qa.qid AND q.sid=673882
        where q.language='en' group by qa.qid, qa.attribute, qa.value,
qa.language
20:48:03.056139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT qa.qid, qa.attribute, qa.value,
qa.language
        FROM lime_question_attributes qa JOIN lime_questions  q ON q.qid =
qa.qid AND q.sid=673882
        where q.language='en' group by qa.qid, qa.attribute, qa.value,
qa.language)
20:48:03.059139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT qa.qid, qa.attribute, qa.value,
qa.language
        FROM lime_question_attributes qa JOIN lime_questions  q ON q.qid =
qa.qid AND q.sid=673882
        where q.language='en' group by qa.qid, qa.attribute, qa.value,
qa.language)
20:48:03.059139 trace system.db.CDbCommand 
Querying SQL: SELECT lime_quota.*
        FROM lime_quota
        WHERE lime_quota.sid=673882
20:48:03.059139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT lime_quota.*
        FROM lime_quota
        WHERE lime_quota.sid=673882)
20:48:03.059139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT lime_quota.*
        FROM lime_quota
        WHERE lime_quota.sid=673882)
20:48:03.059139 trace system.db.CDbCommand 
Querying SQL: SELECT lime_quota_members.*
        FROM lime_quota_members
        WHERE lime_quota_members.sid=673882
20:48:03.059139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT lime_quota_members.*
        FROM lime_quota_members
        WHERE lime_quota_members.sid=673882)
20:48:03.059139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT lime_quota_members.*
        FROM lime_quota_members
        WHERE lime_quota_members.sid=673882)
20:48:03.059139 trace system.db.CDbCommand 
Querying SQL: SELECT lime_quota_languagesettings.*
        FROM lime_quota_languagesettings, lime_quota
        WHERE lime_quota.id = lime_quota_languagesettings.quotals_quota_id
        AND lime_quota.sid=673882
20:48:03.059139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT lime_quota_languagesettings.*
        FROM lime_quota_languagesettings, lime_quota
        WHERE lime_quota.id = lime_quota_languagesettings.quotals_quota_id
        AND lime_quota.sid=673882)
20:48:03.059139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT lime_quota_languagesettings.*
        FROM lime_quota_languagesettings, lime_quota
        WHERE lime_quota.id = lime_quota_languagesettings.quotals_quota_id
        AND lime_quota.sid=673882)
20:48:03.059139 trace system.db.CDbCommand 
Querying SQL: SELECT *
    FROM lime_surveys
    WHERE sid=673882
20:48:03.059139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT *
    FROM lime_surveys
    WHERE sid=673882)
20:48:03.059139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT *
    FROM lime_surveys
    WHERE sid=673882)
20:48:03.060139 trace system.db.CDbCommand 
Querying SQL: SELECT *
    FROM lime_surveys_languagesettings
    WHERE surveyls_survey_id=673882
20:48:03.060139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT *
    FROM lime_surveys_languagesettings
    WHERE surveyls_survey_id=673882)
20:48:03.060139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT *
    FROM lime_surveys_languagesettings
    WHERE surveyls_survey_id=673882)
20:48:03.060139 trace system.db.CDbCommand 
Querying SQL: SELECT *
    FROM lime_survey_url_parameters
    WHERE sid=673882
20:48:03.060139 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT *
    FROM lime_survey_url_parameters
    WHERE sid=673882)
20:48:03.060139 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT *
    FROM lime_survey_url_parameters
    WHERE sid=673882)