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 `sconciliacion`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts _recno FAC_BANCO FAC_AUTO FAC_FECHA FAC_DESCRIPCION FAC_SALDOANTERIOR FAC_SALDOFINAL FAC_CHEQUESEMITIDOS FAC_CHEQUESEMITIDOSMONTO FAC_NDEBITO FAC_NDEBITOMONTO FAC_NCREDITO FAC_NCREDITOMONTO FAC_DEPOSITOS FAC_DEPOSITOSMONTO FAC_DEBITOSTRANSITO FAC_CREDITOSTRANSITO FAC_USER FAC_ESTACION FAC_HORA FAC_DIRDATOS FAC_NOOPERACION
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 1
1 0108-0029-3601-0046-8865 1 2023-12-15 Conciliación Mes de : OCTUBRE 2023 150500.23 6028.84 0 0 144 2874257.72 4 2218368 13 511418.33 0 0 MSEVILLA ADMON-MSEVILLA 10:26:55 NULL 986090298
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 2
2 0134-0363-5336-3130-6986 2 2023-12-18 Conciliación Mes de : OCTUBRE 2023 84606.3 788279.17 0 0 184 3599927.8 8 190060.21 73 4113540.46 0 0 MSEVILLA ADMON-MSEVILLA 13:06:46 NULL 160623954
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 3
3 0174-0131-9912-1436-8158 3 2023-12-19 Conciliación Mes de : OCTUBRE 2023 38353.11 9411.22 0 0 11 100363.88 0 0 2 71421.99 0 0 MSEVILLA MSEVILLA-ADMON- 07:19:56 NULL 6728735
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 4
4 0163-0903-6490-3300-6791 4 2023-12-19 Conciliación Mes de : OCTUBRE 2023 33686.86 302861.08 0 0 6 311.64 0 0 4 269485.86 0 0 MSEVILLA MSEVILLA-ADMON- 07:40:12 NULL 88825653
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 5
5 0102-0645-6300-0018-9976 5 2023-12-19 Conciliación Mes de : OCTUBRE 2023 12.45 62.75 0 0 18 257361.62 2 0.56 6 257411.36 0 0 MSEVILLA MSEVILLA-ADMON- 12:22:08 NULL 373031063
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 6
6 0102-0645-6100-0010-4838 6 2023-12-19 Conciliación Mes de : OCTUBRE 2023 0 0 0 0 6 27520.27 1 26602.4 1 917.87 0 0 MSEVILLA MSEVILLA-ADMON- 12:22:27 NULL 517491661
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 7
7 0102-0645-6300-0018-9976 7 2023-12-19 Conciliación Mes de : NOVIEMBRE 2023 62.75 33.5 0 0 16 306982.18 4 890.24 3 306062.69 0 0 MSEVILLA MSEVILLA-ADMON- 14:27:29 NULL 1102494713
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 8
8 0102-0645-6100-0010-4838 8 2023-12-19 Conciliación Mes de : NOVIEMBRE 2023 0 0 0 0 8 262454.14 0 0 2 262454.14 0 0 MSEVILLA MSEVILLA-ADMON- 14:29:03 NULL 755277922
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 9
9 0134-0363-5336-3130-6986 9 2024-01-18 Conciliación Mes de : NOVIEMBRE 2023 788279.17 119165.4 0 0 84 5963216.34 1 0.46 70 5294102.11 0 0 MSEVILLA MSEVILLA-ADMON- 09:44:34 NULL 1736405521
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 10
10 0191-0106-1921-0002-0338 10 2024-01-18 Conciliación Mes de : OCTUBRE 2023 239045.54 2083.34 0 0 619 8364961.39 21 1093809.61 10 7034189.58 0 0 MSEVILLA MSEVILLA-ADMON- 09:46:34 NULL 1257785542
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 11
11 0163-0903-6490-3300-6791 11 2024-01-19 Conciliación Mes de : NOVIEMBRE 2023 302861.08 9632.09 0 0 8 1113639.58 0 0 1 820410.59 0 0 MSEVILLA MSEVILLA-ADMON- 16:25:22 NULL 380361088
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 12
12 0134-0363-5336-3130-6986 12 2024-01-23 Conciliación Mes de : DICIEMBRE 2023 119165.4 1204621.93 0 0 182 10534295.26 10 61265.87 84 11558485.92 0 0 MSEVILLA MSEVILLA-ADMON- 13:38:12 NULL 1398615711
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 13
13 0108-0029-3601-0046-8865 13 2024-01-26 Conciliación Mes de : NOVIEMBRE 2023 6028.84 108.98 0 0 68 3335060.55 8 2555999.99 18 773140.7 0 0 MSEVILLA MSEVILLA-ADMON- 13:46:00 NULL 1786510832
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 14
14 0191-0106-1921-0002-0338 14 2024-01-26 Conciliación Mes de : NOVIEMBRE 2023 2083.34 148343.84 0 0 713 8565712.69 17 4901812.42 10 3810160.77 0 0 MSEVILLA MSEVILLA-ADMON- 13:47:26 NULL 1668411660
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 15
15 INV. PESCARINA C,A 15 2024-01-27 Conciliación Mes de : 30/11/2023 0 0 0 0 284 11917430.54 1 11917430.54 0 0 0 0 SCARABALLO SCARABALLO-ADMO 11:01:28 NULL 555265045
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 16
16 0108-0029-3601-0046-8865 16 2024-01-29 Conciliación Mes de : DICIEMBRE 2023 108.98 53262.05 0 0 85 4539378.77 5 3170000 27 1422531.84 0 0 MSEVILLA MSEVILLA-ADMON- 10:09:54 NULL 731455976
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 17
17 0163-0903-6490-3300-6791 17 2024-01-29 Conciliación Mes de : DICIEMBRE 2023 9632.09 9521.42 0 0 4 110.67 0 0 0 0 0 0 MSEVILLA MSEVILLA-ADMON- 14:02:46 NULL 106375147
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 18
18 0174-0131-9912-1436-8158 18 2024-01-29 Conciliación Mes de : NOVIEMBRE 2023 9411.22 9382.28 0 0 3 28.94 0 0 0 0 0 0 MSEVILLA MSEVILLA-ADMON- 16:55:15 NULL 1550875266
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 19
19 0191-0106-1921-0002-0338 19 2024-02-08 Conciliación Mes de : 31122023 DICIEMBRE 148343.84 36066.84 0 0 784 22351779.31 25 4899367.17 16 17340135.14 0 0 SCARABALLO SCARABALLO-ADMO 16:04:09 NULL 963971184
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 20
20 0102-0645-6300-0018-9976 20 2024-02-14 Conciliación Mes de : DICIEMBRE 2023 33.5 73.02 0 0 24 497715.84 1 0.01 11 497755.35 0 0 SCARABALLO SCARABALLO-ADMO 15:44:50 NULL 1516319797
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 21
21 0102-0645-6100-0010-4838 21 2024-02-15 Conciliación Mes de : DICIEMBRE 2023 0 0 0 0 12 288363.72 2 93.09 3 288270.63 0 0 SCARABALLO SCARABALLO-ADMO 10:47:26 NULL 1115985575
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 22
22 INV. PESCARINA C,A 22 2024-02-19 Conciliación Mes de : DICIEMBRE 2023 0 0 0 0 103 5817783.58 1 5817783.58 0 0 0 0 SCARABALLO SCARABALLO-ADMO 09:56:33 NULL 892131914
Edit Edit Copy Copy Delete Delete
DELETE FROM sconciliacion WHERE `sconciliacion`.`_recno` = 23
23 TRANSPORTE MAFER, C.A 23 2024-02-19 Conciliación Mes de : DICIEMBRE 2023 0 0 0 0 14 8404.38 1 8404.38 0 0 0 0 SCARABALLO SCARABALLO-ADMO 09:57:40 NULL 1932983606
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