Catch
Entries: 18
additional
Struct (ordered)
SQL
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4165
DriverName
stringMicrosoft JDBC Driver 12.6 for SQL Server
DriverVersion
string12.6.3.0
Datasource
stringpatino_diet
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4165
DriverName
stringMicrosoft JDBC Driver 12.6 for SQL Server
DriverVersion
string12.6.3.0
Datasource
stringpatino_diet
DataSource
stringpatino_diet
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringThe multi-part identifier "webinar_list.cid" could not be bound.
NativeErrorCode
number4104
queryError
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
Sql
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: The multi-part identifier "webinar_list.cid" could not be bound. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:582) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128) at lucee.runtime.tag.Query._doEndTag(Query.java:695) at lucee.runtime.tag.Query.doEndTag(Query.java:560) at cfc.courses_cfc$cf.udfCall2(/cfc/Courses.cfc:473) at cfc.courses_cfc$cf.udfCall(/cfc/Courses.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984) at ceu.dietitian_webinar_cfm$cf.call(/ceu/dietitian_webinar.cfm:115) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921) at application_cfc$cf.udfCall_000002(/Application.cfc:523) at application_cfc$cf.udfCall(/Application.cfc:486) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string471: <br> 472: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORDER&nbsp;BY&nbsp;wl.webinar_dt&nbsp;DESC;<br> <b>473: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 474: <br> 475: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string471: 472: ORDER BY wl.webinar_dt DESC; 473: </cfquery> 474: 475: <!---
column
number0
id
string??
line
number473
Raw_Trace
stringcfc.courses_cfc$cf.udfCall2(/cfc/Courses.cfc:473)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Courses.cfc
type
stringcfml
2
Struct
codePrintHTML
string113: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.HideList&nbsp;=&nbsp;application.coursesObject.getHideList()&gt;<br> 114: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;HideListList&nbsp;=&nbsp;ValueList(HideList.related_cid)&gt;<br> <b>115: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.GetCourseListOnDemand&nbsp;=&nbsp;application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','lt')&gt;</b><br> 116: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.GetCourseListLIVE&nbsp;=&nbsp;application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','gt')&gt;<br> 117: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.AllowStudentsRegister&nbsp;=&nbsp;application.coursesObject.allowStudentRegister(cid&nbsp;=&nbsp;url.cid)&gt;<br>
codePrintPlain
string113: <cfset Variables.HideList = application.coursesObject.getHideList()> 114: <cfset HideListList = ValueList(HideList.related_cid)> 115: <cfset Variables.GetCourseListOnDemand = application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','lt')> 116: <cfset Variables.GetCourseListLIVE = application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','gt')> 117: <cfset Variables.AllowStudentsRegister = application.coursesObject.allowStudentRegister(cid = url.cid)>
column
number0
id
string??
line
number115
Raw_Trace
stringceu.dietitian_webinar_cfm$cf.call(/ceu/dietitian_webinar.cfm:115)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/dietitian_webinar.cfm
type
stringcfml
3
Struct
codePrintHTML
string521: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#ARGUMENTS.targetPage#&quot;&gt;<br> 522: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelse&gt;<br> <b>523: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#ARGUMENTS.targetPage#&quot;&gt;</b><br> 524: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 525: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string521: <cfinclude template="#ARGUMENTS.targetPage#"> 522: <cfelse> 523: <cfinclude template="#ARGUMENTS.targetPage#"> 524: </cfif> 525: </cffunction>
column
number0
id
string??
line
number523
Raw_Trace
stringapplication_cfc$cf.udfCall_000002(/Application.cfc:523)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
4
Struct
codePrintHTML
string484: <br> 485: &nbsp;&nbsp;&nbsp;&lt;cffunction&nbsp;name=&quot;onRequest&quot;&gt;<br> <b>486: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;targetPage&quot;&nbsp;type=&quot;String&quot;&nbsp;required=true/&gt;</b><br> 487: <br> 488: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;cgi.remote_addr&nbsp;NEQ&nbsp;'127.0.0.1'&gt;<br>
codePrintPlain
string484: 485: <cffunction name="onRequest"> 486: <cfargument name="targetPage" type="String" required=true/> 487: 488: <cfif cgi.remote_addr NEQ '127.0.0.1'>
column
number0
id
string??
line
number486
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:486)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringpatino_diet
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringThe multi-part identifier "webinar_list.cid" could not be bound.
name
stringonRequest
NativeErrorCode
number4104
queryError
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4165
DriverName
stringMicrosoft JDBC Driver 12.6 for SQL Server
DriverVersion
string12.6.3.0
Datasource
stringpatino_diet
DataSource
stringpatino_diet
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringThe multi-part identifier "webinar_list.cid" could not be bound.
NativeErrorCode
number4104
queryError
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
Sql
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: The multi-part identifier "webinar_list.cid" could not be bound. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:582) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128) at lucee.runtime.tag.Query._doEndTag(Query.java:695) at lucee.runtime.tag.Query.doEndTag(Query.java:560) at cfc.courses_cfc$cf.udfCall2(/cfc/Courses.cfc:473) at cfc.courses_cfc$cf.udfCall(/cfc/Courses.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984) at ceu.dietitian_webinar_cfm$cf.call(/ceu/dietitian_webinar.cfm:115) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921) at application_cfc$cf.udfCall_000002(/Application.cfc:523) at application_cfc$cf.udfCall(/Application.cfc:486) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string471: <br> 472: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORDER&nbsp;BY&nbsp;wl.webinar_dt&nbsp;DESC;<br> <b>473: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 474: <br> 475: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string471: 472: ORDER BY wl.webinar_dt DESC; 473: </cfquery> 474: 475: <!---
column
number0
id
string??
line
number473
Raw_Trace
stringcfc.courses_cfc$cf.udfCall2(/cfc/Courses.cfc:473)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Courses.cfc
type
stringcfml
2
Struct
codePrintHTML
string113: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.HideList&nbsp;=&nbsp;application.coursesObject.getHideList()&gt;<br> 114: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;HideListList&nbsp;=&nbsp;ValueList(HideList.related_cid)&gt;<br> <b>115: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.GetCourseListOnDemand&nbsp;=&nbsp;application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','lt')&gt;</b><br> 116: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.GetCourseListLIVE&nbsp;=&nbsp;application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','gt')&gt;<br> 117: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.AllowStudentsRegister&nbsp;=&nbsp;application.coursesObject.allowStudentRegister(cid&nbsp;=&nbsp;url.cid)&gt;<br>
codePrintPlain
string113: <cfset Variables.HideList = application.coursesObject.getHideList()> 114: <cfset HideListList = ValueList(HideList.related_cid)> 115: <cfset Variables.GetCourseListOnDemand = application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','lt')> 116: <cfset Variables.GetCourseListLIVE = application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','gt')> 117: <cfset Variables.AllowStudentsRegister = application.coursesObject.allowStudentRegister(cid = url.cid)>
column
number0
id
string??
line
number115
Raw_Trace
stringceu.dietitian_webinar_cfm$cf.call(/ceu/dietitian_webinar.cfm:115)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/dietitian_webinar.cfm
type
stringcfml
3
Struct
codePrintHTML
string521: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#ARGUMENTS.targetPage#&quot;&gt;<br> 522: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelse&gt;<br> <b>523: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#ARGUMENTS.targetPage#&quot;&gt;</b><br> 524: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 525: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string521: <cfinclude template="#ARGUMENTS.targetPage#"> 522: <cfelse> 523: <cfinclude template="#ARGUMENTS.targetPage#"> 524: </cfif> 525: </cffunction>
column
number0
id
string??
line
number523
Raw_Trace
stringapplication_cfc$cf.udfCall_000002(/Application.cfc:523)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
4
Struct
codePrintHTML
string484: <br> 485: &nbsp;&nbsp;&nbsp;&lt;cffunction&nbsp;name=&quot;onRequest&quot;&gt;<br> <b>486: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;targetPage&quot;&nbsp;type=&quot;String&quot;&nbsp;required=true/&gt;</b><br> 487: <br> 488: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;cgi.remote_addr&nbsp;NEQ&nbsp;'127.0.0.1'&gt;<br>
codePrintPlain
string484: 485: <cffunction name="onRequest"> 486: <cfargument name="targetPage" type="String" required=true/> 487: 488: <cfif cgi.remote_addr NEQ '127.0.0.1'>
column
number0
id
string??
line
number486
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:486)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringWITH CategoryAgg AS ( SELECT cid, STRING_AGG(CAST(categoryId AS VARCHAR(10)), ', ') AS categoryId FROM course_category_assign GROUP BY cid ) SELECT ca.categoryId, ah.art_id, cl.cid, cl.ctitle, cl.ccategory, cl.csummary, cl.cexcerpt, cl.ctotalcredits, cl.ccostpercredit, cl.clocation, cl.camount, au.authorname, cl.course_reviewer1, cl.course_reviewer2, cl.course_reviewer3, au.authorcredentials, au.authorbio, cl.caudience, cl.clevel, cl.cobjectives, wl.wkey, wl.webinar_dt, wl.wid, CONVERT(VARCHAR(8), wl.webinar_starttime, 108) AS webinar_starttime, CONVERT(VARCHAR(8), wl.webinar_endTime, 108) AS webinar_endTime, cl.cicon, cl.selfStudy, cl.cauthorid, cl.cauthoridadditional, cl.organizer, cl.cindicators, cl.dropboxMp4FilePath, cu.paydt, cu.cid AS purchasedCid FROM course_list cl INNER JOIN webinar_list wl ON cl.cid = wl.cid INNER JOIN course_author au ON cl.cauthorid = au.cauthorid LEFT JOIN article_headers ah ON ah.cid = wl.cid LEFT JOIN CategoryAgg ca ON ca.cid = wl.cid LEFT JOIN Course_Users cu ON cu.cid = cl.cid AND cu.uid = 0 WHERE ah.art_type = 'Webinar' AND wl.isAvailable = 'YES' AND cl.cid NOT IN (2,3,4,40) AND webinar_list.cid <> 2 AND webinar_list.cid <> 3 AND webinar_list.cid <> 4 AND webinar_list.cid <> 16 AND webinar_list.cid <> 17 AND webinar_list.cid <> 24 AND webinar_list.cid <> 29 AND webinar_list.cid <> 31 AND webinar_list.cid <> 38 AND webinar_list.cid <> 41 AND webinar_list.cid <> 42 AND webinar_list.cid <> 44 AND webinar_list.cid <> 18 AND webinar_list.cid <> 23 AND webinar_list.cid <> 21 AND webinar_list.cid <> 22 AND webinar_list.cid <> 19 AND webinar_list.cid <> 25 AND webinar_list.cid <> 27 AND webinar_list.cid <> 26 AND webinar_list.cid <> 28 AND webinar_list.cid <> 30 AND webinar_list.cid <> 32 AND webinar_list.cid <> 33 AND webinar_list.cid <> 34 AND webinar_list.cid <> 35 AND webinar_list.cid <> 37 AND webinar_list.cid <> 36 AND webinar_list.cid <> 39 AND webinar_list.cid <> 43 AND webinar_list.cid <> 51 AND webinar_list.cid <> 50 AND webinar_list.cid <> 55 AND webinar_list.cid <> 49 AND webinar_list.cid <> 46 AND webinar_list.cid <> 47 AND webinar_list.cid <> 53 AND webinar_list.cid <> 48 AND webinar_list.cid <> 52 AND webinar_list.cid <> 54 AND webinar_list.cid <> 57 AND webinar_list.cid <> 58 AND webinar_list.cid <> 59 AND webinar_list.cid <> 60 AND webinar_list.cid <> 62 AND webinar_list.cid <> 63 AND webinar_list.cid <> 61 AND webinar_list.cid <> 65 AND webinar_list.cid <> 66 AND webinar_list.cid <> 67 AND webinar_list.cid <> 68 AND webinar_list.cid <> 69 AND webinar_list.cid <> 71 AND webinar_list.cid <> 72 AND webinar_list.cid <> 73 AND webinar_list.cid <> 70 AND webinar_list.cid <> 76 AND webinar_list.cid <> 75 AND webinar_list.cid <> 77 AND webinar_list.cid <> 78 AND webinar_list.cid <> 79 AND webinar_list.cid <> 80 AND webinar_list.cid <> 81 AND webinar_list.cid <> 83 AND webinar_list.cid <> 84 AND webinar_list.cid <> 87 AND webinar_list.cid <> 88 AND webinar_list.cid <> 89 AND webinar_list.cid <> 161 AND webinar_list.cid <> 91 AND webinar_list.cid <> 94 AND webinar_list.cid <> 98 AND webinar_list.cid <> 100 AND webinar_list.cid <> 102 AND webinar_list.cid <> 103 AND webinar_list.cid <> 106 AND webinar_list.cid <> 107 AND webinar_list.cid <> 108 AND webinar_list.cid <> 109 AND webinar_list.cid <> 110 AND webinar_list.cid <> 111 AND webinar_list.cid <> 112 AND webinar_list.cid <> 113 AND webinar_list.cid <> 114 AND webinar_list.cid <> 116 AND webinar_list.cid <> 117 AND webinar_list.cid <> 119 AND webinar_list.cid <> 118 AND webinar_list.cid <> 123 AND webinar_list.cid <> 124 AND webinar_list.cid <> 125 AND webinar_list.cid <> 129 AND webinar_list.cid <> 130 AND webinar_list.cid <> 145 AND webinar_list.cid <> 146 AND webinar_list.cid <> 148 AND webinar_list.cid <> 153 AND webinar_list.cid <> 155 AND webinar_list.cid <> 160 AND webinar_list.cid <> 128 AND webinar_list.cid <> 144 AND webinar_list.cid <> 147 AND webinar_list.cid <> 183 AND webinar_list.cid <> 191 AND webinar_list.cid <> 203 AND webinar_list.cid <> 150 AND webinar_list.cid <> 126 AND webinar_list.cid <> 162 AND webinar_list.cid <> 174 AND webinar_list.cid <> 127 AND webinar_list.cid <> 104 AND webinar_list.cid <> 92 AND webinar_list.cid <> 93 AND webinar_list.cid <> 175 AND webinar_list.cid <> 256 AND webinar_list.cid <> 255 AND webinar_list.cid <> 257 AND webinar_list.cid <> 209 AND webinar_list.cid <> 115 AND webinar_list.cid <> 163 AND webinar_list.cid <> 166 AND webinar_list.cid <> 181 AND webinar_list.cid <> 186 AND webinar_list.cid <> 188 AND webinar_list.cid <> 198 AND webinar_list.cid <> 96 AND webinar_list.cid <> 207 AND webinar_list.cid <> 229 AND webinar_list.cid <> 90 AND webinar_list.cid <> 165 AND webinar_list.cid <> 121 AND webinar_list.cid <> 99 AND webinar_list.cid <> 187 AND webinar_list.cid <> 149 AND webinar_list.cid <> 248 AND webinar_list.cid <> 170 AND webinar_list.cid <> 343 AND webinar_list.cid <> 193 AND webinar_list.cid <> 215 AND webinar_list.cid <> 233 AND webinar_list.cid <> 261 AND webinar_list.cid <> 275 AND webinar_list.cid <> 391 AND webinar_list.cid <> 238 AND webinar_list.cid <> 223 AND webinar_list.cid <> 371 AND webinar_list.cid <> 332 AND webinar_list.cid <> 156 AND webinar_list.cid <> 154 AND webinar_list.cid <> 189 AND webinar_list.cid <> 164 AND webinar_list.cid <> 74 AND webinar_list.cid <> 151 AND webinar_list.cid <> 105 AND webinar_list.cid <> 169 AND webinar_list.cid <> 195 AND webinar_list.cid <> 211 AND webinar_list.cid <> 249 AND webinar_list.cid <> 194 AND webinar_list.cid <> 228 AND webinar_list.cid <> 277 AND webinar_list.cid <> 290 AND webinar_list.cid <> 328 AND webinar_list.cid <> 336 AND webinar_list.cid <> 270 AND webinar_list.cid <> 266 AND webinar_list.cid <> 452 AND webinar_list.cid <> 280 AND webinar_list.cid <> 465 AND webinar_list.cid <> 253 AND webinar_list.cid <> 354 AND webinar_list.cid <> 326 AND webinar_list.cid <> 295 AND webinar_list.cid <> 324 AND webinar_list.cid <> 420 AND webinar_list.cid <> 278 AND webinar_list.cid <> 267 AND webinar_list.cid <> 345 AND webinar_list.cid <> 279 AND webinar_list.cid <> 383 AND webinar_list.cid <> 322 AND webinar_list.cid <> 436 AND webinar_list.cid <> 301 AND webinar_list.cid <> 366 AND webinar_list.cid <> 433 AND webinar_list.cid <> 444 AND webinar_list.cid <> 388 AND webinar_list.cid <> 445 AND webinar_list.cid <> 374 AND webinar_list.cid <> 407 AND webinar_list.cid <> 410 AND webinar_list.cid <> 423 AND webinar_list.cid <> 455 AND webinar_list.cid <> 453 AND webinar_list.cid <> 507 AND webinar_list.cid <> 504 AND webinar_list.cid <> 539 AND webinar_list.cid <> 377 AND webinar_list.cid <> 511 AND webinar_list.cid <> 538 AND webinar_list.cid <> 474 AND webinar_list.cid <> 543 AND webinar_list.cid <> 526 AND webinar_list.cid <> 512 AND webinar_list.cid <> 482 AND webinar_list.cid <> 529 AND webinar_list.cid <> 440 AND webinar_list.cid <> 473 AND webinar_list.cid <> 454 AND webinar_list.cid <> 498 AND webinar_list.cid <> 531 AND webinar_list.cid <> 447 AND webinar_list.cid <> 545 AND webinar_list.cid <> 437 AND webinar_list.cid <> 568 AND webinar_list.cid <> 621 AND webinar_list.cid <> 607 AND webinar_list.cid <> 478 AND webinar_list.cid <> 685 AND webinar_list.cid <> 597 AND webinar_list.cid <> 628 AND webinar_list.cid <> 506 AND webinar_list.cid <> 528 AND webinar_list.cid <> 549 AND webinar_list.cid <> 524 AND webinar_list.cid <> 686 AND webinar_list.cid <> 633 AND webinar_list.cid <> 601 AND webinar_list.cid <> 723 AND webinar_list.cid <> 711 AND webinar_list.cid <> 734 AND webinar_list.cid <> 593 AND webinar_list.cid <> 533 AND webinar_list.cid <> 622 AND webinar_list.cid <> 662 AND webinar_list.cid <> 657 AND webinar_list.cid <> 692 AND webinar_list.cid <> 684 AND webinar_list.cid <> 424 AND webinar_list.cid <> 519 AND webinar_list.cid <> 770 AND webinar_list.cid <> 632 AND webinar_list.cid <> 574 AND webinar_list.cid <> 310 AND webinar_list.cid <> 479 AND webinar_list.cid <> 534 AND webinar_list.cid <> 421 AND webinar_list.cid <> 485 AND webinar_list.cid <> 462 AND webinar_list.cid <> 644 AND webinar_list.cid <> 520 AND webinar_list.cid <> 562 AND webinar_list.cid <> 575 AND webinar_list.cid <> 505 AND webinar_list.cid <> 429 AND webinar_list.cid <> 445 AND webinar_list.cid <> 694 AND webinar_list.cid <> 497 AND webinar_list.cid <> 719 AND webinar_list.cid <> 708 AND webinar_list.cid <> 578 AND webinar_list.cid <> 683 AND webinar_list.cid <> 546 AND webinar_list.cid <> 808 AND webinar_list.cid <> 739 AND webinar_list.cid <> 675 AND webinar_list.cid <> 736 AND webinar_list.cid <> 572 AND webinar_list.cid <> 799 AND webinar_list.cid <> 727 AND webinar_list.cid <> 802 AND webinar_list.cid <> 698 AND webinar_list.cid <> 785 AND webinar_list.cid <> 772 AND webinar_list.cid <> 829 AND webinar_list.cid <> 820 AND webinar_list.cid <> 809 AND webinar_list.cid <> 788 AND webinar_list.cid <> 805 AND webinar_list.cid <> 724 AND webinar_list.cid <> 812 AND webinar_list.cid <> 881 AND webinar_list.cid <> 643 AND webinar_list.cid <> 699 AND webinar_list.cid <> 893 AND webinar_list.cid <> 858 AND webinar_list.cid <> 850 AND webinar_list.cid <> 855 AND webinar_list.cid <> 863 AND webinar_list.cid <> 876 AND webinar_list.cid <> 856 AND webinar_list.cid <> 10901 AND webinar_list.cid <> 860 AND webinar_list.cid <> 456 AND webinar_list.cid <> 741 AND webinar_list.cid <> 616 AND webinar_list.cid <> 862 AND webinar_list.cid <> 707 AND webinar_list.cid <> 701 AND webinar_list.cid <> 868 AND webinar_list.cid <> 10920 AND cl.isFree = 0 AND wl.webinar_dt < GETDATE() AND ( cl.cauthorid = 9994 OR cl.cauthoridadditional LIKE '%9994%' ) AND NOT EXISTS ( SELECT 1 FROM webinarPackage_Webinars wpw WHERE wpw.wid_fk = wl.wid ) ORDER BY wl.webinar_dt DESC;
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: The multi-part identifier "webinar_list.cid" could not be bound. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:582) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128) at lucee.runtime.tag.Query._doEndTag(Query.java:695) at lucee.runtime.tag.Query.doEndTag(Query.java:560) at cfc.courses_cfc$cf.udfCall2(/cfc/Courses.cfc:473) at cfc.courses_cfc$cf.udfCall(/cfc/Courses.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984) at ceu.dietitian_webinar_cfm$cf.call(/ceu/dietitian_webinar.cfm:115) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921) at application_cfc$cf.udfCall_000002(/Application.cfc:523) at application_cfc$cf.udfCall(/Application.cfc:486) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string471: <br> 472: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORDER&nbsp;BY&nbsp;wl.webinar_dt&nbsp;DESC;<br> <b>473: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 474: <br> 475: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string471: 472: ORDER BY wl.webinar_dt DESC; 473: </cfquery> 474: 475: <!---
column
number0
id
string??
line
number473
Raw_Trace
stringcfc.courses_cfc$cf.udfCall2(/cfc/Courses.cfc:473)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Courses.cfc
type
stringcfml
2
Struct
codePrintHTML
string113: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.HideList&nbsp;=&nbsp;application.coursesObject.getHideList()&gt;<br> 114: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;HideListList&nbsp;=&nbsp;ValueList(HideList.related_cid)&gt;<br> <b>115: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.GetCourseListOnDemand&nbsp;=&nbsp;application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','lt')&gt;</b><br> 116: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.GetCourseListLIVE&nbsp;=&nbsp;application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','gt')&gt;<br> 117: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Variables.AllowStudentsRegister&nbsp;=&nbsp;application.coursesObject.allowStudentRegister(cid&nbsp;=&nbsp;url.cid)&gt;<br>
codePrintPlain
string113: <cfset Variables.HideList = application.coursesObject.getHideList()> 114: <cfset HideListList = ValueList(HideList.related_cid)> 115: <cfset Variables.GetCourseListOnDemand = application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','lt')> 116: <cfset Variables.GetCourseListLIVE = application.coursesObject.getCourseList(HideListList,GetCourseList.cauthorid,'','','','gt')> 117: <cfset Variables.AllowStudentsRegister = application.coursesObject.allowStudentRegister(cid = url.cid)>
column
number0
id
string??
line
number115
Raw_Trace
stringceu.dietitian_webinar_cfm$cf.call(/ceu/dietitian_webinar.cfm:115)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/dietitian_webinar.cfm
type
stringcfml
3
Struct
codePrintHTML
string521: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#ARGUMENTS.targetPage#&quot;&gt;<br> 522: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelse&gt;<br> <b>523: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#ARGUMENTS.targetPage#&quot;&gt;</b><br> 524: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 525: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string521: <cfinclude template="#ARGUMENTS.targetPage#"> 522: <cfelse> 523: <cfinclude template="#ARGUMENTS.targetPage#"> 524: </cfif> 525: </cffunction>
column
number0
id
string??
line
number523
Raw_Trace
stringapplication_cfc$cf.udfCall_000002(/Application.cfc:523)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
4
Struct
codePrintHTML
string484: <br> 485: &nbsp;&nbsp;&nbsp;&lt;cffunction&nbsp;name=&quot;onRequest&quot;&gt;<br> <b>486: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;targetPage&quot;&nbsp;type=&quot;String&quot;&nbsp;required=true/&gt;</b><br> 487: <br> 488: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;cgi.remote_addr&nbsp;NEQ&nbsp;'127.0.0.1'&gt;<br>
codePrintPlain
string484: 485: <cffunction name="onRequest"> 486: <cfargument name="targetPage" type="String" required=true/> 487: 488: <cfif cgi.remote_addr NEQ '127.0.0.1'>
column
number0
id
string??
line
number486
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:486)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
type
stringdatabase
where
string