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 `bridging_surat_pri_bpjs`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts no_rawat no_kartu tgl_surat no_surat tgl_rencana kd_dokter_bpjs nm_dokter_bpjs kd_poli_bpjs nm_poli_bpjs diagnosa no_sep
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0022R0031123K000349'
2023/11/05/000002 0002039338078 2023-11-06 0022R0031123K000349 2023-11-06 371513 dr. ZULFAHRI LUBIS, M.Ked.(Oph) Sp.M MAT Mata A01.1 - Paratyphoid fever A -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0022R0031123K000434'
2023/11/06/000003 0001852163313 2023-11-06 0022R0031123K000434 2023-11-06 430 dr. Indah Prianti Sp.PD. M.Kes INT Penyakit Dalam K30 - Dyspepsia 0022R0031123V000534
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0022R0031123K000495'
2023/11/06/000003 0001852163313 2023-11-07 0022R0031123K000495 2023-11-07 430 dr. Indah Prianti Sp.PD. M.Kes INT Penyakit Dalam A01.3 - Paratyphoid fever C 0022R0031123V000534
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000001'
2025/01/01/000006 0001480318806 2025-01-01 0475R0000125K000001 2025-01-01 3007 dr. Reni Hayati Hsb,M.Ked(OG),Sp.OG OBG obgyn O80.9 - Single spontaneous delivery, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000014'
2025/01/01/000013 0002147516324 2025-01-01 0475R0000125K000014 2025-01-01 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam R10 - Abdominal and pelvic pain -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000015'
2025/01/01/000009 0000258672194 2025-01-01 0475R0000125K000015 2025-01-01 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam J45 - Asthma -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000021'
2025/01/01/000014 0002888404457 2025-01-01 0475R0000125K000021 2025-01-01 3007 dr. Reni Hayati Hsb,M.Ked(OG),Sp.OG OBG obgyn O80 - Single spontaneous delivery -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000022'
2025/01/01/000019 0000259506268 2025-01-01 0475R0000125K000022 2025-01-01 3007 dr. Reni Hayati Hsb,M.Ked(OG),Sp.OG OBG obgyn O34 - Maternal care for known or suspected abnorma... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000036'
2025/01/02/000035 0000259334065 2025-01-02 0475R0000125K000036 2025-01-02 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam E11 - Non-insulin-dependent diabetes mellitus -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000037'
2025/01/02/000031 0000259324222 2025-01-02 0475R0000125K000037 2025-01-02 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam R10 - Abdominal and pelvic pain -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000056'
2025/01/02/000059 0001493640729 2025-01-02 0475R0000125K000056 2025-01-02 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam E11 - Non-insulin-dependent diabetes mellitus -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000057'
2025/01/02/000053 0002782816716 2025-01-02 0475R0000125K000057 2025-01-02 3007 dr. Reni Hayati Hsb,M.Ked(OG),Sp.OG OBG obgyn O82 - Single delivery by caesarean section -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000061'
2025/01/02/000039 0003086427014 2025-01-02 0475R0000125K000061 2025-01-02 3815 dr. Barry Winaldy Siregar., Sp.B BED Bedah K40 - Inguinal hernia -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000069'
2025/01/02/000066 0000258579112 2025-01-02 0475R0000125K000069 2025-01-02 3007 dr. Reni Hayati Hsb,M.Ked(OG),Sp.OG OBG obgyn O34 - Maternal care for known or suspected abnorma... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000070'
2025/01/02/000068 0000233331153 2025-01-02 0475R0000125K000070 2025-01-02 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam A01 - Typhoid and paratyphoid fevers -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000071'
2025/01/02/000069 0001396174252 2025-01-02 0475R0000125K000071 2025-01-02 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam A15 - Respiratory tuberculosis, bacteriologically ... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000072'
2025/01/02/000070 0001808929675 2025-01-02 0475R0000125K000072 2025-01-02 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam R10 - Abdominal and pelvic pain -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000073'
2025/01/03/000002 0000014148988 2025-01-03 0475R0000125K000073 2025-01-03 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam J45 - Asthma -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000083'
2025/01/03/000008 0003639049479 2025-01-03 0475R0000125K000083 2025-01-03 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam A01 - Typhoid and paratyphoid fevers -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000084'
2025/01/03/000025 0003180128005 2025-01-03 0475R0000125K000084 2025-01-03 3815 dr. Barry Winaldy Siregar., Sp.B BED Bedah K40 - Inguinal hernia -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000088'
2025/01/03/000033 0000259236674 2025-01-03 0475R0000125K000088 2025-01-03 3815 dr. Barry Winaldy Siregar., Sp.B BED Bedah S39 - Other and unspecified injuries of abdomen, l... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000090'
2025/01/03/000030 0002473658324 2025-01-03 0475R0000125K000090 2025-01-03 3815 dr. Barry Winaldy Siregar., Sp.B BED Bedah D21 - Other benign neoplasms of connective and oth... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000095'
2025/01/03/000041 0000165676882 2025-01-03 0475R0000125K000095 2025-01-03 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam A01 - Typhoid and paratyphoid fevers -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000100'
2025/01/03/000046 0001190882294 2025-01-03 0475R0000125K000100 2025-01-03 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam R10 - Abdominal and pelvic pain -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0475R0000125K000101'
2025/01/03/000048 0000258970048 2025-01-03 0475R0000125K000101 2025-01-03 416206 dr. WIKA LYDIA, M.Ked (PD), Sp.PD INT Penyakit Dalam A01 - Typhoid and paratyphoid fevers -
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view