| Description | SQL is invalid. The ID needs to be shown correctly.
{s:5:"%type";s:9:"Exception";s:8:"!message";s:7644:"Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous. The S
QL statement executed was: SELECT submitdate, lastpage, startlanguage, startdate, datestamp, ipaddr, refurl, 893581X40X2261, 893581X40X2262, 893581X40X22701, 893581X40X22702, 893581X40X22703, 893581X40X2271, 893581X40X2272, 893581X40X2273, 893581X40X2274, 893581X40X2275, 893581X40 X2276, 893581X40X2277, 893581X40X2278, 893581X40X2279, 893581X40X2280, 893581X40X2281, 893581X40X2282, 893581X40X2283, 893581X40X2284, 893581X40X2285, 893581X40X3863, 893581X40X2287, 893581X40X2288, 893581X40X2289, 893581X40X2290, 893581X41X2291, 893581X41X2292, 893581X41X2293, 8 93581X41X2294, 893581X41X2295, 893581X41X2296, 893581X41X2297, 893581X41X2298, 893581X41X2299, 893581X41X2300, 893581X41X2301, 893581X41X2302, 893581X41X2303, 893581X41X2304, 893581X41X2305, 893581X41X2306, 893581X41X2307, 893581X41X2308, 893581X41X23091, 893581X41X23092, 893581X41 X23093, 893581X41X23094, 893581X41X23095, 893581X41X2316, 893581X41X2317, 893581X41X2318, 893581X41X2319, 893581X41X2320, 893581X41X2321, 893581X41X2322, 893581X41X2323, 893581X41X2324, 893581X41X23251, 893581X41X23252, 893581X41X23253, 893581X41X23254, 893581X41X23255, 893581X41X2 3256, 893581X41X23257, 893581X41X23258, 893581X41X2335, 893581X41X2336, 893581X41X2337, 893581X41X2338, 893581X41X3864, 893581X41X2339, 893581X42X23401, 893581X42X23402, 893581X42X23403, 893581X42X23404, 893581X42X23405, 893581X42X23406, 893581X42X23407, 893581X42X23408, 893581X42X 23409, 893581X42X234010, 893581X42X234011, 893581X42X234012, 893581X42X234013, 893581X42X234014, 893581X42X234015, 893581X42X234016, 893581X42X234017, 893581X42X234018, 893581X42X234019, 893581X42X234020, 893581X42X234021, 893581X42X234022, 893581X42X234023, 893581X42X234024, 893581X 42X234025, 893581X43X2367, 893581X43X2368, 893581X43X2369, 893581X43X2370, 893581X43X2371, 893581X43X2372, 893581X43X2373, 893581X43X3738, 893581X43X3739, 893581X43X3740, 893581X43X3741, 893581X43X37421, 893581X43X37422, 893581X43X37423, 893581X43X37424, 893581X43X3748, 893581X43X3 749, 893581X43X3750, 893581X43X37511, 893581X43X37512, 893581X43X37513, 893581X43X3756, 893581X43X3757, 893581X43X3758, 893581X44X3728, 893581X44X3729, 893581X44X3730, 893581X44X3731, 893581X44X3732, 893581X44X3733, 893581X44X3734, 893581X44X3735, 893581X44X3736, 893581X44X3737, 893581X45X3759, 893581X45X37601, 893581X45X37602, 893581X45X37603, 893581X45X37604, 893581X45X37605, 893581X45X37606, 893581X45X37607, 893581X45X37608, 893581X45X37609, 893581X45X376010, 893581X45X376011, 893581X45X376012, 893581X45X376013, 893581X45X376014, 893581X45X376015, 893581X 45X376016, 893581X45X376017, 893581X45X376018, 893581X45X376019, 893581X45X376020, 893581X45X3782, 893581X45X37831, 893581X45X37832, 893581X45X37833, 893581X45X37834, 893581X45X37835, 893581X45X37836, 893581X45X3791, 893581X45X3792, 893581X45X3793, 893581X45X3794, 893581X45X3795, 8 93581X45X3796, 893581X45X3797, 893581X45X3798, 893581X45X3799, 893581X45X3800, 893581X45X3801, 893581X45X3802, 893581X45X3803, 893581X45X3804, 893581X45X3805, 893581X45X3806, 893581X45X3807, 893581X45X3808, 893581X45X3809, 893581X45X3810, 893581X45X3811, 893581X45X3812, 893581X46X3 825, 893581X46X3826, 893581X46X3827, 893581X47X3828, 893581X47X3829, 893581X47X3830, 893581X47X3831, 893581X47X3832, 893581X48X3821, 893581X48X3822, 893581X48X3823, 893581X48X3824, 893581X49X3813, 893581X49X3814, 893581X49X3815, 893581X49X3816, 893581X49X3817, 893581X49X3818, 893 581X49X3819, 893581X49X3820, tid, participant_id, firstname, lastname, email, emailstatus, language, blacklisted, sent, remindersent, remindercount, completed, usesleft, validfrom, validuntil, mpid, lime_survey_893581.token, interviewtime, 893581X40time, 893581X40X2261tim e, 893581X40X2262time, 893581X40X2270time, 893581X40X2271time, 893581X40X2272time, 893581X40X2273time, 893581X40X2274time, 893581X40X2275time, 893581X40X2276time, 893581X40X2277time, 893581X40X2278time, 893581X40X2279time, 893581X40X2280time, 893581X40X2281time, 893581X40X2282time, 893 581X40X2283time, 893581X40X2284time, 893581X40X2285time, 893581X40X3863time, 893581X40X2287time, 893581X40X2288time, 893581X40X2289time, 893581X40X2290time, 893581X41time, 893581X41X2291time, 893581X41X2292time, 893581X41X2293time, 893581X41X2294time, 893581X41X2295time, 893581X41X2296ti me, 893581X41X2297time, 893581X41X2298time, 893581X41X2299time, 893581X41X2300time, 893581X41X2301time, 893581X41X2302time, 893581X41X2303time, 893581X41X2304time, 893581X41X2305time, 893581X41X2306time, 893581X41X2307time, 893581X41X2308time, 893581X41X2309time, 893581X41X2316time, 89 3581X41X2317time, 893581X41X2318time, 893581X41X2319time, 893581X41X2320time, 893581X41X2321time, 893581X41X2322time, 893581X41X2323time, 893581X41X2324time, 893581X41X2325time, 893581X41X2335time, 893581X41X2336time, 893581X41X2337time, 893581X41X2338time, 893581X41X3864time, 893581X41X 2339time, 893581X42time, 893581X42X2340time, 893581X43time, 893581X43X2367time, 893581X43X2368time, 893581X43X2369time, 893581X43X2370time, 893581X43X2371time, 893581X43X2372time, 893581X43X2373time, 893581X43X3738time, 893581X43X3739time, 893581X43X3740time, 893581X43X3741time, 893581X43X3742time, 893581X43X3748time, 893581X43X3749time, 893581X43X3750time, 893581X43X3751time, 893581X43X3756time, 893581X43X3757time, 893581X43X3758time, 893581X44time, 893581X44X3728time, 893581X44X3729time, 893581X44X3730time, 893581X44X3731time, 893581X44X3732time, 893581X44X3733time$,893581X44X3734time,893581X44X3735time,893581X44X3736time,893581X44X3737time,893581X45time,893581X45X3759time,893581X45X3760time,893581X45X3782time,893581X45X3783time,893581X45X3791time,893581X45X3792time,893581X45X3793time,893581X45X3794time,893581X45X3795time,893581X45$3796time,893581X45X3797time,893581X45X3798time,893581X45X3799time,893581X45X3800time,893581X45X3801time,893581X45X3802time,893581X45X3803time,893581X45X3804time,893581X45X3805time,893581X45X3806time,893581X45X3807time,893581X45X3808time,893581X45X3809time,893581X45X3810tim$,893581X45X3811time,893581X45X3812time,893581X46time,893581X46X3825time,893581X46X3826time,893581X46X3827time,893581X47time,893581X47X3828time,893581X47X3829time,893581X47X3830time,893581X47X3831time,893581X47X3832time,893581X48time,893581X48X3821time,893581X48X3822time$, 893581X48X3823time, 893581X48X3824time, 893581X49time, 893581X49X3813time, 893581X49X3814time, 893581X49X3815time, 893581X49X3816time, 893581X49X3817time, 893581X49X3818time, 893581X49X3819time, 893581X49X3820time, lime_survey_893581.id
FROM lime_survey_893581
LEFT JOIN lime_tokens_893581 tokentable ON tokentable.token=lime_survey_893581.token
LEFT JOIN lime_survey_893581_timings survey_timings ON lime_survey_893581.id = survey_timings.id |
|---|