[SELECT A1.`closed` AS `closed`, A3.`staff_id` AS `lock__staff_id`, A1.`staff_id` AS `staff_id`, A1.`isoverdue` AS `isoverdue`, A1.`team_id` AS `team_id`, A1.`ticket_id` AS `ticket_id`, A1.`number` AS `number`, A4.`subject` AS `cdata__subject`, A6.`address` AS `user__default_email__address`, A7.`name` AS `user__org__name`, A8.`cmto` AS `user__org__cdata__cmto`, A1.`source` AS `source`, B0.`priority_color` AS `cdata__:priority__priority_color`, B0.`priority_desc` AS `cdata__:priority__priority_desc`, A1.`status_id` AS `status_id`, B1.`name` AS `status__name`, B1.`state` AS `status__state`, A1.`dept_id` AS `dept_id`, B2.`name` AS `dept__name`, A5.`name` AS `user__name`, A1.`lastupdate` AS `lastupdate`, A1.`isanswered` AS `isanswered`, B3.`firstname` AS `staff__firstname`, B3.`lastname` AS `staff__lastname`, B4.`name` AS `team__name`, (SELECT COUNT(R0.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_collaborator` R0 ON (Q7.`id` = R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id`) AS collab_count, (SELECT COUNT(R1.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`) LEFT JOIN `ost_attachment` R1 ON (R1.`type` = 'H' AND R0.`id` = R1.`object_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND R1.`inline` = 0) AS attachment_count, (SELECT COUNT(R0.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND NOT R0.`flags` & 4 != 0) AS thread_count FROM `ost_ticket` A1 JOIN (SELECT Q7.`ticket_id` FROM `ost_ticket` Q7 JOIN `ost_ticket_status` Q8 ON (Q7.`status_id` = Q8.`id`) WHERE Q8.`state` = 'closed' AND ((Q8.`state` = 'open' AND (Q7.`staff_id` = 1 OR Q7.`team_id` IN (1, 3, 4, 5))) OR Q7.`dept_id` IN ('1', '4', '5', '6')) ORDER BY Q7.`closed` DESC LIMIT 25) A2 LEFT JOIN `ost_lock` A3 ON (A1.`lock_id` = A3.`lock_id` AND A3.`expire` > NOW()) LEFT JOIN `ost_ticket__cdata` A4 ON (A1.`ticket_id` = A4.`ticket_id`) JOIN `ost_user` A5 ON (A1.`user_id` = A5.`id`) LEFT JOIN `ost_user_email` A6 ON (A5.`default_email_id` = A6.`id`) LEFT JOIN `ost_organization` A7 ON (A5.`org_id` = A7.`id`) LEFT JOIN `ost_organization__cdata` A8 ON (A7.`id` = A8.`org_id`) LEFT JOIN `ost_ticket_priority` B0 ON (A4.`priority` = B0.`priority_id`) JOIN `ost_ticket_status` B1 ON (A1.`status_id` = B1.`id`) JOIN `ost_department` B2 ON (A1.`dept_id` = B2.`id`) LEFT JOIN `ost_staff` B3 ON (A1.`staff_id` = B3.`staff_id`) LEFT JOIN `ost_team` B4 ON (A1.`team_id` = B4.`team_id`) WHERE A1.`ticket_id` = A2.`ticket_id` GROUP BY A1.`closed`, A3.`staff_id`, A1.`staff_id`, A1.`isoverdue`, A1.`team_id`, A1.`ticket_id`, A1.`number`, A4.`subject`, A6.`address`, A7.`name`, A8.`cmto`, A1.`source`, B0.`priority_color`, B0.`priority_desc`, A1.`status_id`, B1.`name`, B1.`state`, A1.`dept_id`, B2.`name`, A5.`name`, A1.`lastupdate`, A1.`isanswered`, B3.`firstname`, B3.`lastname`, B4.`name` ORDER BY A1.`closed` DESC]

Table 'ticketspec.ost_organization__cdata' doesn't exist<br /> <br />
---- Recular ----<br />
#0 C:\inetpub\wwwroot\ticketspec\upload\include\mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.`clo...')<br />
#1 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(3133): db_query('SELECT A1.`clos...', true, true)<br />
#2 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(3180): MySqlExecutor->execute()<br />
#3 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1865): MySqlExecutor->getArray()<br />
#4 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1815): HashArrayIterator->{closure}()<br />
#5 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1794): CallbackSimpleIterator->next()<br />
#6 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1803): CallbackSimpleIterator->rewind()<br />
#7 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1463): CallbackSimpleIterator->valid()<br />
#8 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1480): CachedResultSet->fillTo(2147483647)<br />
#9 C:\inetpub\wwwroot\ticketspec\upload\include\class.orm.php(1489): CachedResultSet->asArray()<br />
#10 C:\inetpub\wwwroot\ticketspec\upload\include\staff\tickets.inc.php(516): CachedResultSet->getIterator()<br />
#11 C:\inetpub\wwwroot\ticketspec\upload\scp\tickets.php(492): require_once('C:\\inetpub\\wwwr...')<br />
#12 C:\inetpub\wwwroot\ticketspec\upload\scp\index.php(17): require('C:\\inetpub\\wwwr...')<br />
#13 {main}