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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling 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 `vprelstpagoshoy`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts Partida Cliente descripcion Comprobante Codigo Fecha Recibo Comentario Importe UserName
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 42948 AND `vprelstpagoshoy`.`descripcion` = 'AGUILERA SILVANA ALEJANDRA ' AND `vprelstpagoshoy`.`Comprobante` = 152872 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -450 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
X 42948 AGUILERA SILVANA ALEJANDRA   152872 12 2015-03-27 -450 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 32298 AND `vprelstpagoshoy`.`descripcion` = 'SANCHEZ MARTINEZ RAMON ' AND `vprelstpagoshoy`.`Comprobante` = 90912 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -390 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 32298 SANCHEZ MARTINEZ RAMON   90912 12 2015-03-27 -390 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 41799 AND `vprelstpagoshoy`.`descripcion` = 'YÑIGUEZ EUSEBIO ' AND `vprelstpagoshoy`.`Comprobante` = 155499 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -560 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
X 41799 YÑIGUEZ EUSEBIO 155499 12 2015-03-27 -560 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 12549 AND `vprelstpagoshoy`.`descripcion` = 'ESCOBAR ROJAS CARLOS' AND `vprelstpagoshoy`.`Comprobante` = 90625 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -570 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 12549 ESCOBAR ROJAS CARLOS 90625 12 2015-03-27 -570 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 43135 AND `vprelstpagoshoy`.`descripcion` = 'DUARTE PEREIRA LAURA ' AND `vprelstpagoshoy`.`Comprobante` = 153693 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -200 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
X 43135 DUARTE PEREIRA LAURA   153693 12 2015-03-27 C -200 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'C' AND `vprelstpagoshoy`.`Cliente` = 13552 AND `vprelstpagoshoy`.`descripcion` = 'ACOSTA JAVIER DARIO' AND `vprelstpagoshoy`.`Comprobante` = 156079 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -400 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
C 13552 ACOSTA JAVIER DARIO 156079 12 2015-03-27 -400 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 14640 AND `vprelstpagoshoy`.`descripcion` = 'DIAZ GLADYS MARCIANA' AND `vprelstpagoshoy`.`Comprobante` = 91120 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-03-27' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -300 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 14640 DIAZ GLADYS MARCIANA 91120 12 2015-03-27 -300 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 31590 AND `vprelstpagoshoy`.`descripcion` = 'CORONEL GARCETE MARCELINA ' AND `vprelstpagoshoy`.`Comprobante` = 89051 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -600 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 31590 CORONEL GARCETE MARCELINA 89051 12 2015-04-04 C -600 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 11370 AND `vprelstpagoshoy`.`descripcion` = 'MIÑO FELICIANO' AND `vprelstpagoshoy`.`Comprobante` = 92590 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -420 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 11370 MIÑO FELICIANO 92590 12 2015-04-04 -420 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 33010 AND `vprelstpagoshoy`.`descripcion` = 'IRALA FLORENTINO CARMEN ' AND `vprelstpagoshoy`.`Comprobante` = 93108 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -800 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 33010 IRALA FLORENTINO CARMEN   93108 12 2015-04-04 C -800 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 33077 AND `vprelstpagoshoy`.`descripcion` = 'CACERES JOSE LEONARDO ' AND `vprelstpagoshoy`.`Comprobante` = 93306 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -960 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 33077 CACERES JOSE LEONARDO   93306 12 2015-04-04 C -960 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'C' AND `vprelstpagoshoy`.`Cliente` = 39297 AND `vprelstpagoshoy`.`descripcion` = 'GONZALEZ JESICA ALEJANDRA ' AND `vprelstpagoshoy`.`Comprobante` = 157217 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -200 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
C 39297 GONZALEZ JESICA ALEJANDRA 157217 12 2015-04-04 C -200 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 31859 AND `vprelstpagoshoy`.`descripcion` = 'GOMEZ GERARDO DAVID ' AND `vprelstpagoshoy`.`Comprobante` = 89745 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -200 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
M 31859 GOMEZ GERARDO DAVID   89745 12 2015-04-04 C -200 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 40284 AND `vprelstpagoshoy`.`descripcion` = 'SALINAS GONZALEZ MARCELINA ' AND `vprelstpagoshoy`.`Comprobante` = 157557 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-04-04' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -750 AND `vprelstpagoshoy`.`UserName` = 'suc62' LIMIT 1
X 40284 SALINAS GONZALEZ MARCELINA 157557 12 2015-04-04 C -750 suc62
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'C' AND `vprelstpagoshoy`.`Cliente` = 23463 AND `vprelstpagoshoy`.`descripcion` = 'ESCOBAR MARTA VERONICA' AND `vprelstpagoshoy`.`Comprobante` = 69897 AND `vprelstpagoshoy`.`Codigo` = 50 AND `vprelstpagoshoy`.`Fecha` = '2015-06-15' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = 2385 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
C 23463 ESCOBAR MARTA VERONICA 69897 50 2015-06-15 C 2385 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'C' AND `vprelstpagoshoy`.`Cliente` = 23463 AND `vprelstpagoshoy`.`descripcion` = 'ESCOBAR MARTA VERONICA' AND `vprelstpagoshoy`.`Comprobante` = 66910 AND `vprelstpagoshoy`.`Codigo` = 40 AND `vprelstpagoshoy`.`Fecha` = '2015-06-15' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -35 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
C 23463 ESCOBAR MARTA VERONICA 66910 40 2015-06-15 -35 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'C' AND `vprelstpagoshoy`.`Cliente` = 23463 AND `vprelstpagoshoy`.`descripcion` = 'ESCOBAR MARTA VERONICA' AND `vprelstpagoshoy`.`Comprobante` = 69982 AND `vprelstpagoshoy`.`Codigo` = 40 AND `vprelstpagoshoy`.`Fecha` = '2015-06-15' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -600 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
C 23463 ESCOBAR MARTA VERONICA 69982 40 2015-06-15 -600 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 44246 AND `vprelstpagoshoy`.`descripcion` = 'BUSTOS WALTER ENRIQUE ' AND `vprelstpagoshoy`.`Comprobante` = 158489 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2015-05-13' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -500 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
X 44246 BUSTOS WALTER ENRIQUE   158489 12 2015-05-13 C -500 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 21570 AND `vprelstpagoshoy`.`descripcion` = 'SANCHEZ VERONICA CLAUDIA' AND `vprelstpagoshoy`.`Comprobante` = 80105 AND `vprelstpagoshoy`.`Codigo` = 50 AND `vprelstpagoshoy`.`Fecha` = '2015-06-15' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = 1200 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
M 21570 SANCHEZ VERONICA CLAUDIA 80105 50 2015-06-15 C 1200 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 96 AND `vprelstpagoshoy`.`descripcion` = 'TORREZ ANTONIO JUVENAL' AND `vprelstpagoshoy`.`Comprobante` = 1 AND `vprelstpagoshoy`.`Codigo` = 50 AND `vprelstpagoshoy`.`Fecha` = '2015-06-15' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = 780 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
X 96 TORREZ ANTONIO JUVENAL 1 50 2015-06-15 C 780 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 25004 AND `vprelstpagoshoy`.`descripcion` = 'GONZALEZ PERLA MARINA' AND `vprelstpagoshoy`.`Comprobante` = 151625 AND `vprelstpagoshoy`.`Codigo` = 50 AND `vprelstpagoshoy`.`Fecha` = '2015-06-15' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = 284 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
X 25004 GONZALEZ PERLA MARINA 151625 50 2015-06-15 C 284 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'C' AND `vprelstpagoshoy`.`Cliente` = 31178 AND `vprelstpagoshoy`.`descripcion` = 'MORALES CARMEN' AND `vprelstpagoshoy`.`Comprobante` = 131456 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2014-03-10' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -50 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
C 31178 MORALES CARMEN 131456 12 2014-03-10 -50 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'M' AND `vprelstpagoshoy`.`Cliente` = 17284 AND `vprelstpagoshoy`.`descripcion` = 'LEZCANO MARIA AZUCENA' AND `vprelstpagoshoy`.`Comprobante` = 88743 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2014-05-06' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -880 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
M 17284 LEZCANO MARIA AZUCENA 88743 12 2014-05-06 C -880 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 14757 AND `vprelstpagoshoy`.`descripcion` = 'GONZALEZ RODRIGUEZ JULIA' AND `vprelstpagoshoy`.`Comprobante` = 149730 AND `vprelstpagoshoy`.`Codigo` = 50 AND `vprelstpagoshoy`.`Fecha` = '2015-06-17' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = 'C' AND CONCAT(`vprelstpagoshoy`.`Importe`) = 300 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
X 14757 GONZALEZ RODRIGUEZ JULIA 149730 50 2015-06-17 C 300 july
Edit Edit Copy Copy Delete Delete
DELETE FROM vprelstpagoshoy WHERE `vprelstpagoshoy`.`Partida` = 'X' AND `vprelstpagoshoy`.`Cliente` = 18511 AND `vprelstpagoshoy`.`descripcion` = 'GALEANO CLEMENTINA' AND `vprelstpagoshoy`.`Comprobante` = 122254 AND `vprelstpagoshoy`.`Codigo` = 12 AND `vprelstpagoshoy`.`Fecha` = '2012-04-23' AND `vprelstpagoshoy`.`Recibo` = ' ' AND `vprelstpagoshoy`.`Comentario` = '' AND CONCAT(`vprelstpagoshoy`.`Importe`) = -200 AND `vprelstpagoshoy`.`UserName` = 'july' LIMIT 1
X 18511 GALEANO CLEMENTINA 122254 12 2012-04-23 -200 july
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view