Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `lots`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id lot_code barcode_value product_name category supplier purchase_date received_date received_by_name received_by_user_id initial_qty current_qty unit location_id notes status approval_status approved_by_name approved_at created_at supplier_id supplier_rep_id supplier_rep_name attachment_path
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 1
1 CAC-CONV-001 CAC-CONV-001 Cacao Convencional Fermentado (Saco 50kg) Cacao Convencional Asociación Productores de Oriente 2026-11-19 2026-11-19 María López (Ingreso) 3 120 95 Sacos (50 kg) 481 Humedad 7.2%, fermentación 85% ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T01:40:34+01:00 2026-11-19T01:40:34+01:00 1 1 Luis Marcano att_20261119_031508_mov001_a07051.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 2
2 CAC-ORG-001 CAC-ORG-001 Cacao Orgánico Certificado (Saco 50kg) Cacao Orgánico Cooperativa Agrícola Verde 2026-11-19 2026-11-19 María López (Ingreso) 3 80 80 Sacos (50 kg) 628 Certificado orgánico vigente ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T01:40:34+01:00 2026-11-19T01:40:34+01:00 2 3 José Bermúdez att_20261119_031508_mov003_a9e57a.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 3
3 CAC-JAS-001 CAC-JAS-001 Cacao JAS Calidad Exportación (Saco 50kg) Cacao JAS Finca San José 2026-11-19 2026-11-19 María López (Ingreso) 3 60 45 Sacos (50 kg) 583 Grano seleccionado sin impurezas ACTIVO APROBADO Gregoris Bolivar (Admin) 2026-11-19T01:40:34+01:00 2026-11-19T01:40:34+01:00 3 4 Ramón Salazar att_20261119_031508_mov005_c71a03.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 4
4 CAC-FTS-001 CAC-FTS-001 Cacao FTS Comercio Justo (Saco 50kg) Cacao FTS Productores Unidos FTS 2026-11-19 2026-11-19 María López (Ingreso) 3 50 50 Sacos (50 kg) 652 Sacos sellados y etiquetados ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T01:40:34+01:00 2026-11-19T01:40:34+01:00 4 5 Elena Brito att_20261119_031508_mov007_3ed4bd.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 5
5 CAC-CONV-002 CAC-CONV-002 Cacao Convencional Secado al Sol (Saco 50kg) Cacao Convencional Asociación Productores de Oriente 2026-11-19 2026-11-19 María López (Ingreso) 3 90 90 Sacos (50 kg) 499 Lote seco al sol, lote #2 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 1 1 Luis Marcano att_20261119_031508_mov008_1c1e05.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 6
6 CAC-CONV-003 CAC-CONV-003 Cacao Convencional Fermentado Premium (Saco 50kg) Cacao Convencional Asociación Productores de Oriente 2026-11-19 2026-11-19 María López (Ingreso) 3 100 70 Sacos (50 kg) 517 Entregado por representante 2 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 1 2 Carmen Rivas att_20261119_031508_mov009_d6c103.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 7
7 CAC-CONV-004 CAC-CONV-004 Cacao Convencional Corriente (Saco 50kg) Cacao Convencional Asociación Productores de Oriente 2026-11-19 2026-11-19 María López (Ingreso) 3 75 75 Sacos (50 kg) 530 Segunda entrega de la semana ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 1 2 Carmen Rivas att_20261119_031508_mov011_2ddb2c.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 8
8 CAC-CONV-005 CAC-CONV-005 Cacao Convencional Selección Especial (Saco 50kg) Cacao Convencional Asociación Productores de Oriente 2026-11-19 2026-11-19 María López (Ingreso) 3 60 40 Sacos (50 kg) 556 Para molienda fina ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 1 1 Luis Marcano att_20261119_031508_mov012_5f6c12.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 9
9 CAC-ORG-002 CAC-ORG-002 Cacao Orgánico Criollo (Saco 50kg) Cacao Orgánico Cooperativa Agrícola Verde 2026-11-19 2026-11-19 María López (Ingreso) 3 55 55 Sacos (50 kg) 634 Área orgánica lote 2 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 2 3 José Bermúdez att_20261119_031508_mov014_8f9dbd.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 10
10 CAC-ORG-003 CAC-ORG-003 Cacao Orgánico Trinitario (Saco 50kg) Cacao Orgánico Cooperativa Agrícola Verde 2026-11-19 2026-11-19 María López (Ingreso) 3 45 30 Sacos (50 kg) 631 Certificado orgánico UE ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 2 3 José Bermúdez att_20261119_031508_mov015_6956b0.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 11
11 CAC-JAS-002 CAC-JAS-002 Cacao JAS Cosecha Tardía (Saco 50kg) Cacao JAS Finca San José 2026-11-19 2026-11-19 María López (Ingreso) 3 65 65 Sacos (50 kg) 640 Calidad exportación Japón ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 3 4 Ramón Salazar att_20261119_031508_mov017_a3313e.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 12
12 CAC-JAS-003 CAC-JAS-003 Cacao JAS Grano Fino (Saco 50kg) Cacao JAS Finca San José 2026-11-19 2026-11-19 María López (Ingreso) 3 50 35 Sacos (50 kg) 646 Listo para embarque ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T02:44:11+01:00 2026-11-19T02:44:11+01:00 3 4 Ramón Salazar att_20261119_031508_mov018_52d404.pdf
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 13
13 LOT-20261119-013 LOT-20261119-013 CACAO SECO General Cooperativa Agrícola Verde 2026-11-13 2026-11-19 Miguel Fuentes (Supervisor) 2 80 80 Sacos (50 kg) 567 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:48:10+01:00 2026-11-19T03:48:10+01:00 2 3 José Bermúdez
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 14
14 LOT-20261119-014 LOT-20261119-014 CACAO SECO General Asociación Productores de Oriente 2026-11-19 2026-11-19 Miguel Fuentes (Supervisor) 2 100 100 Sacos (60 kg) 629 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:48:48+01:00 2026-11-19T03:48:48+01:00 1 1 Luis Marcano
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 15
15 LOT-20261119-015 LOT-20261119-015 CACAO SECO General Finca San José 2026-11-13 2026-11-19 Miguel Fuentes (Supervisor) 2 20 20 Sacos (60 kg) 566 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:51:05+01:00 2026-11-19T03:51:05+01:00 3 4 Ramón Salazar
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 16
16 LOT-20261119-016 LOT-20261119-016 CACAO SECO General Asociación Productores de Oriente 2026-11-19 2026-11-19 Miguel Fuentes (Supervisor) 2 20 20 Sacos (60 kg) 630 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:52:19+01:00 2026-11-19T03:52:19+01:00 1 1 Luis Marcano att_20261119_035219_3ee93659df.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 17
17 LOT-20261119-017 LOT-20261119-017 CACAO SECO General Asociación Productores de Oriente 2026-11-15 2026-11-19 Miguel Fuentes (Supervisor) 2 100 100 Sacos (6000 kg) 570 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:54:34+01:00 2026-11-19T03:54:34+01:00 1 1 Luis Marcano
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 18
18 LOT-20261119-018 LOT-20261119-018 CACAO SECO General Asociación Productores de Oriente 2026-11-19 2026-11-19 Miguel Fuentes (Supervisor) 2 100 100 Sacos (6000 kg) 632 ACTIVO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:54:58+01:00 2026-11-19T03:54:58+01:00 1 1 Luis Marcano
Edit Edit Copy Copy Delete Delete
DELETE FROM lots WHERE `lots`.`id` = 19
19 2475 2475 CACAO SECO General Cooperativa Agrícola Verde 2026-11-14 2026-11-19 Miguel Fuentes (Supervisor) 2 32 0 Sacos (1850 kg) 573 AGOTADO APROBADO Miguel Fuentes (Supervisor) 2026-11-19T03:57:48+01:00 2026-11-19T03:57:48+01:00 2 3 José Bermúdez att_20261119_035747_3c00be2faa.jpg
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query