| 1 | SHOW FULL COLUMNS FROM `pos` | | 41 | 41 | 2 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 |
| 3 | SHOW FULL COLUMNS FROM `suppliers` | | 14 | 14 | 1 |
| 4 | SHOW FULL COLUMNS FROM `npbs` | | 17 | 17 | 1 |
| 5 | SHOW FULL COLUMNS FROM `departments` | | 4 | 4 | 1 |
| 6 | SHOW FULL COLUMNS FROM `aydas` | | 35 | 35 | 1 |
| 7 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_general_ci'; | | 1 | 1 | 1 |
| 8 | SHOW FULL COLUMNS FROM `ayda_statuses` | | 4 | 4 | 1 |
| 9 | SHOW FULL COLUMNS FROM `ayda_types` | | 2 | 2 | 1 |
| 10 | SHOW FULL COLUMNS FROM `ayda_insurances` | | 2 | 2 | 0 |
| 11 | SHOW FULL COLUMNS FROM `ayda_docs` | | 4 | 4 | 1 |
| 12 | SHOW FULL COLUMNS FROM `locations` | | 5 | 5 | 1 |
| 13 | SHOW FULL COLUMNS FROM `assets` | | 79 | 79 | 3 |
| 14 | SHOW FULL COLUMNS FROM `purchases` | | 19 | 19 | 1 |
| 15 | SHOW FULL COLUMNS FROM `warranties` | | 14 | 14 | 1 |
| 16 | SHOW FULL COLUMNS FROM `requesters` | | 3 | 3 | 1 |
| 17 | SHOW FULL COLUMNS FROM `asset_categories` | | 13 | 13 | 1 |
| 18 | SHOW FULL COLUMNS FROM `accounts` | | 8 | 8 | 1 |
| 19 | SHOW FULL COLUMNS FROM `account_types` | | 3 | 3 | 1 |
| 20 | SHOW FULL COLUMNS FROM `account_globals` | | 6 | 6 | 1 |
| 21 | SHOW FULL COLUMNS FROM `asset_details` | | 74 | 74 | 3 |
| 22 | SHOW FULL COLUMNS FROM `conditions` | | 3 | 3 | 1 |
| 23 | SHOW FULL COLUMNS FROM `movement_details` | | 11 | 11 | 1 |
| 24 | SHOW FULL COLUMNS FROM `movements` | | 15 | 15 | 1 |
| 25 | SHOW FULL COLUMNS FROM `movement_statuses` | | 2 | 2 | 1 |
| 26 | SHOW FULL COLUMNS FROM `currencies` | | 6 | 6 | 1 |
| 27 | SHOW FULL COLUMNS FROM `currency_details` | | 5 | 5 | 1 |
| 28 | SHOW FULL COLUMNS FROM `users` | | 7 | 7 | 2 |
| 29 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
| 30 | SHOW FULL COLUMNS FROM `groups` | | 4 | 4 | 1 |
| 31 | SHOW FULL COLUMNS FROM `menus` | | 6 | 6 | 1 |
| 32 | SHOW FULL COLUMNS FROM `groups_menus` | | 2 | 2 | 0 |
| 33 | SHOW FULL COLUMNS FROM `journal_transactions` | | 13 | 13 | 1 |
| 34 | SHOW FULL COLUMNS FROM `journal_templates` | | 4 | 4 | 1 |
| 35 | SHOW FULL COLUMNS FROM `journal_groups` | | 2 | 2 | 0 |
| 36 | SHOW FULL COLUMNS FROM `journal_template_details` | | 6 | 6 | 1 |
| 37 | SHOW FULL COLUMNS FROM `journal_positions` | | 2 | 2 | 0 |
| 38 | SHOW FULL COLUMNS FROM `invoices` | | 28 | 28 | 1 |
| 39 | SHOW FULL COLUMNS FROM `invoice_statuses` | | 3 | 3 | 1 |
| 40 | SHOW FULL COLUMNS FROM `bank_account_types` | | 3 | 3 | 1 |
| 41 | SHOW FULL COLUMNS FROM `invoice_details` | | 32 | 32 | 2 |
| 42 | SHOW FULL COLUMNS FROM `invoices_pos` | | 3 | 3 | 1 |
| 43 | SHOW FULL COLUMNS FROM `invoices_purchases` | | 3 | 3 | 1 |
| 44 | SHOW FULL COLUMNS FROM `npb_statuses` | | 2 | 2 | 1 |
| 45 | SHOW FULL COLUMNS FROM `request_types` | | 3 | 3 | 1 |
| 46 | SHOW FULL COLUMNS FROM `npb_details` | | 19 | 19 | 1 |
| 47 | SHOW FULL COLUMNS FROM `items` | | 10 | 10 | 1 |
| 48 | SHOW FULL COLUMNS FROM `units` | | 2 | 2 | 0 |
| 49 | SHOW FULL COLUMNS FROM `npb_fulfillments` | | 3 | 3 | 0 |
| 50 | SHOW FULL COLUMNS FROM `npb_suppliers` | | 5 | 5 | 1 |
| 51 | SHOW FULL COLUMNS FROM `npbs_pos` | | 3 | 3 | 0 |
| 52 | SHOW FULL COLUMNS FROM `po_statuses` | | 3 | 3 | 1 |
| 53 | SHOW FULL COLUMNS FROM `po_details` | | 28 | 28 | 1 |
| 54 | SHOW FULL COLUMNS FROM `disposals` | | 14 | 14 | 2 |
| 55 | SHOW FULL COLUMNS FROM `disposal_statuses` | | 2 | 2 | 1 |
| 56 | SHOW FULL COLUMNS FROM `disposal_types` | | 2 | 2 | 1 |
| 57 | SHOW FULL COLUMNS FROM `disposal_details` | | 11 | 11 | 1 |
| 58 | SHOW FULL COLUMNS FROM `configs` | | 2 | 2 | 0 |
| 59 | SELECT `Config`.`key`, `Config`.`value` FROM `configs` AS `Config` WHERE 1 = 1 | | 7 | 7 | 0 |
| 60 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`title`, `Menu`.`url`, `Menu`.`help`, `Menu`.`urutan`, `ParentMenu`.`id`, `ParentMenu`.`parent_id`, `ParentMenu`.`title`, `ParentMenu`.`url`, `ParentMenu`.`help`, `ParentMenu`.`urutan` FROM `menus` AS `Menu` LEFT JOIN `menus` AS `ParentMenu` ON (`Menu`.`parent_id` = `ParentMenu`.`id`) WHERE 1 = 1 ORDER BY `Menu`.`urutan` asc | | 90 | 90 | 0 |
| 61 | SELECT `ChildMenu`.`id`, `ChildMenu`.`parent_id`, `ChildMenu`.`title`, `ChildMenu`.`url`, `ChildMenu`.`help`, `ChildMenu`.`urutan` FROM `menus` AS `ChildMenu` WHERE `ChildMenu`.`parent_id` IN (73, 86, 74, 131, 138, 132, 110, 106, 70, 68, 69, 72, 87, 107, 98, 109, 129, 127, 76, 125, 123, 13, 80, 88, 128, 91, 99, 130, 122, 126, 108, 39, 77, 75, 2, 82, 104, 85, 124, 81, 111, 92, 112, 78, 105, 113, 114, 89, 62, 63, 64, 79, 29, 90, 100, 30, 7, 116, 101, 8, 102, 9, 115, 103, 10, 93, 4, 117, 24, 94, 67, 142, 95, 96, 97, 38, 66, 58, 3, 49, 141, 50, 133, 134, 136, 137, 139, 140, 143, 28) ORDER BY `ChildMenu`.`urutan` asc | | 81 | 81 | 0 |
| 62 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 1 | | 1 | 1 | 0 |
| 63 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 2 | | 1 | 1 | 1 |
| 64 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 3 | | 1 | 1 | 0 |
| 65 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 4 | | 1 | 1 | 0 |
| 66 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 5 | | 1 | 1 | 0 |
| 67 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 6 | | 1 | 1 | 0 |
| 68 | SELECT COUNT(*) AS `count` FROM `pos` AS `Po` LEFT JOIN `suppliers` AS `Supplier` ON (`Po`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `po_statuses` AS `PoStatus` ON (`Po`.`po_status_id` = `PoStatus`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Po`.`currency_id` = `Currency`.`id`) LEFT JOIN `departments` AS `Department` ON (`Po`.`department_id` = `Department`.`id`) WHERE `Po`.`po_status_id` = 7 | | 1 | 1 | 0 |
| 69 | SELECT COUNT(*) AS `count` FROM `npbs` AS `Npb` LEFT JOIN `departments` AS `Department` ON (`Npb`.`department_id` = `Department`.`id`) LEFT JOIN `npb_statuses` AS `NpbStatus` ON (`Npb`.`status_id` = `NpbStatus`.`id`) LEFT JOIN `request_types` AS `RequestTypes` ON (`Npb`.`request_type_id` = `RequestTypes`.`id`) LEFT JOIN `suppliers` AS `Supplier` ON (`Npb`.`supplier_id` = `Supplier`.`id`) WHERE `Npb`.`status_id` = 'draft' | | 1 | 1 | 0 |
| 70 | SELECT COUNT(*) AS `count` FROM `npbs` AS `Npb` LEFT JOIN `departments` AS `Department` ON (`Npb`.`department_id` = `Department`.`id`) LEFT JOIN `npb_statuses` AS `NpbStatus` ON (`Npb`.`status_id` = `NpbStatus`.`id`) LEFT JOIN `request_types` AS `RequestTypes` ON (`Npb`.`request_type_id` = `RequestTypes`.`id`) LEFT JOIN `suppliers` AS `Supplier` ON (`Npb`.`supplier_id` = `Supplier`.`id`) WHERE `Npb`.`status_id` = 'branch_approved' | | 1 | 1 | 0 |
| 71 | SELECT COUNT(*) AS `count` FROM `npbs` AS `Npb` LEFT JOIN `departments` AS `Department` ON (`Npb`.`department_id` = `Department`.`id`) LEFT JOIN `npb_statuses` AS `NpbStatus` ON (`Npb`.`status_id` = `NpbStatus`.`id`) LEFT JOIN `request_types` AS `RequestTypes` ON (`Npb`.`request_type_id` = `RequestTypes`.`id`) LEFT JOIN `suppliers` AS `Supplier` ON (`Npb`.`supplier_id` = `Supplier`.`id`) WHERE `Npb`.`status_id` = 'sent_to_branch_head' | | 1 | 1 | 0 |
| 72 | SELECT COUNT(*) AS `count` FROM `invoices` AS `Invoice` LEFT JOIN `suppliers` AS `Supplier` ON (`Invoice`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Invoice`.`currency_id` = `Currency`.`id`) LEFT JOIN `invoice_statuses` AS `InvoiceStatus` ON (`Invoice`.`status_invoice_id` = `InvoiceStatus`.`id`) LEFT JOIN `departments` AS `Department` ON (`Invoice`.`department_id` = `Department`.`id`) LEFT JOIN `bank_account_types` AS `BankAccountType` ON (`Invoice`.`paid_bank_account_type_id` = `BankAccountType`.`id`) WHERE `Invoice`.`status_invoice_id` = 1 | | 1 | 1 | 0 |
| 73 | SELECT COUNT(*) AS `count` FROM `invoices` AS `Invoice` LEFT JOIN `suppliers` AS `Supplier` ON (`Invoice`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Invoice`.`currency_id` = `Currency`.`id`) LEFT JOIN `invoice_statuses` AS `InvoiceStatus` ON (`Invoice`.`status_invoice_id` = `InvoiceStatus`.`id`) LEFT JOIN `departments` AS `Department` ON (`Invoice`.`department_id` = `Department`.`id`) LEFT JOIN `bank_account_types` AS `BankAccountType` ON (`Invoice`.`paid_bank_account_type_id` = `BankAccountType`.`id`) WHERE `Invoice`.`status_invoice_id` = 2 | | 1 | 1 | 0 |
| 74 | SELECT COUNT(*) AS `count` FROM `invoices` AS `Invoice` LEFT JOIN `suppliers` AS `Supplier` ON (`Invoice`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Invoice`.`currency_id` = `Currency`.`id`) LEFT JOIN `invoice_statuses` AS `InvoiceStatus` ON (`Invoice`.`status_invoice_id` = `InvoiceStatus`.`id`) LEFT JOIN `departments` AS `Department` ON (`Invoice`.`department_id` = `Department`.`id`) LEFT JOIN `bank_account_types` AS `BankAccountType` ON (`Invoice`.`paid_bank_account_type_id` = `BankAccountType`.`id`) WHERE `Invoice`.`status_invoice_id` = 3 | | 1 | 1 | 0 |
| 75 | SELECT COUNT(*) AS `count` FROM `invoices` AS `Invoice` LEFT JOIN `suppliers` AS `Supplier` ON (`Invoice`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`Invoice`.`currency_id` = `Currency`.`id`) LEFT JOIN `invoice_statuses` AS `InvoiceStatus` ON (`Invoice`.`status_invoice_id` = `InvoiceStatus`.`id`) LEFT JOIN `departments` AS `Department` ON (`Invoice`.`department_id` = `Department`.`id`) LEFT JOIN `bank_account_types` AS `BankAccountType` ON (`Invoice`.`paid_bank_account_type_id` = `BankAccountType`.`id`) WHERE `Invoice`.`status_invoice_id` = 6 | | 1 | 1 | 0 |
| 76 | SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` LEFT JOIN `departments` AS `Department` ON (`Movement`.`source_department_id` = `Department`.`id`) LEFT JOIN `movement_statuses` AS `MovementStatus` ON (`Movement`.`movement_status_id` = `MovementStatus`.`id`) WHERE `Movement`.`movement_status_id` = '1' | | 1 | 1 | 0 |
| 77 | SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` LEFT JOIN `departments` AS `Department` ON (`Movement`.`source_department_id` = `Department`.`id`) LEFT JOIN `movement_statuses` AS `MovementStatus` ON (`Movement`.`movement_status_id` = `MovementStatus`.`id`) WHERE `Movement`.`movement_status_id` = '2' | | 1 | 1 | 0 |
| 78 | SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` LEFT JOIN `departments` AS `Department` ON (`Movement`.`source_department_id` = `Department`.`id`) LEFT JOIN `movement_statuses` AS `MovementStatus` ON (`Movement`.`movement_status_id` = `MovementStatus`.`id`) WHERE `Movement`.`movement_status_id` = '3' | | 1 | 1 | 0 |
| 79 | SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` LEFT JOIN `departments` AS `Department` ON (`Movement`.`source_department_id` = `Department`.`id`) LEFT JOIN `movement_statuses` AS `MovementStatus` ON (`Movement`.`movement_status_id` = `MovementStatus`.`id`) WHERE `Movement`.`movement_status_id` = '4' | | 1 | 1 | 0 |
| 80 | SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` LEFT JOIN `departments` AS `Department` ON (`Movement`.`source_department_id` = `Department`.`id`) LEFT JOIN `movement_statuses` AS `MovementStatus` ON (`Movement`.`movement_status_id` = `MovementStatus`.`id`) WHERE `Movement`.`movement_status_id` = '5' | | 1 | 1 | 0 |
| 81 | SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` LEFT JOIN `departments` AS `Department` ON (`Movement`.`source_department_id` = `Department`.`id`) LEFT JOIN `movement_statuses` AS `MovementStatus` ON (`Movement`.`movement_status_id` = `MovementStatus`.`id`) WHERE `Movement`.`movement_status_id` = '6' | | 1 | 1 | 0 |
| 82 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '1' AND `Disposal`.`disposal_type_id` = '1' | | 1 | 1 | 0 |
| 83 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '1' AND `Disposal`.`disposal_type_id` = '2' | | 1 | 1 | 0 |
| 84 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '2' AND `Disposal`.`disposal_type_id` = '1' | | 1 | 1 | 0 |
| 85 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '2' AND `Disposal`.`disposal_type_id` = '2' | | 1 | 1 | 0 |
| 86 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '3' AND `Disposal`.`disposal_type_id` = '1' | | 1 | 1 | 0 |
| 87 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '3' AND `Disposal`.`disposal_type_id` = '2' | | 1 | 1 | 0 |
| 88 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '4' AND `Disposal`.`disposal_type_id` = '1' | | 1 | 1 | 0 |
| 89 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '4' AND `Disposal`.`disposal_type_id` = '2' | | 1 | 1 | 0 |
| 90 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '5' AND `Disposal`.`disposal_type_id` = '1' | | 1 | 1 | 0 |
| 91 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '5' AND `Disposal`.`disposal_type_id` = '2' | | 1 | 1 | 0 |
| 92 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '6' AND `Disposal`.`disposal_type_id` = '1' | | 1 | 1 | 0 |
| 93 | SELECT COUNT(*) AS `count` FROM `disposals` AS `Disposal` LEFT JOIN `departments` AS `Department` ON (`Disposal`.`department_id` = `Department`.`id`) LEFT JOIN `disposal_statuses` AS `DisposalStatus` ON (`Disposal`.`disposal_status_id` = `DisposalStatus`.`id`) LEFT JOIN `disposal_types` AS `DisposalType` ON (`Disposal`.`disposal_type_id` = `DisposalType`.`id`) WHERE `Disposal`.`disposal_status_id` = '6' AND `Disposal`.`disposal_type_id` = '2' | | 1 | 1 | 0 |
Loading, please wait ....