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 |
---|