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 `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` = '0190R0020124K000001'
2024/01/01/000002 0003125309376 2024-01-01 0190R0020124K000001 2024-01-01 389 dr. Rofi Budiyanto Athar, Sp. A ANA Anak R50.0 - Fever with chills -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000004'
2024/01/01/000007 0000700248352 2024-01-01 0190R0020124K000004 2024-01-01 374 dr. Indah Reviati Kusuma, Sp. PD INT Penyakit Dalam R55 - Syncope and collapse -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000006'
2024/01/01/000012 0001536048257 2024-01-01 0190R0020124K000006 2024-01-01 399 dr. Indah Ari Handayani, Sp.S SAR Saraf I63.9 - Cerebral infarction, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000007'
2024/01/01/000013 0000701199854 2024-01-01 0190R0020124K000007 2024-01-01 444393 dr. DODI TRI OKTAFIANTO, Sp.OG OBG obgyn O03.9 - Spontaneous abortion, complete or unspecif... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000008'
2024/01/01/000014 0002805815068 2024-01-01 0190R0020124K000008 2024-01-01 374 dr. Indah Reviati Kusuma, Sp. PD INT Penyakit Dalam K30 - Dyspepsia -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000009'
2024/01/01/000015 0003544546667 2024-01-01 0190R0020124K000009 2024-01-01 389 dr. Rofi Budiyanto Athar, Sp. A ANA Anak R50.9 - Fever, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000010'
2024/01/01/000016 0001832322688 2024-01-01 0190R0020124K000010 2024-01-01 341201 dr. HANANDHA PUTRA LUQMANA, Sp.PD. INT Penyakit Dalam R06.0 - Dyspnoea -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000011'
2024/01/01/000018 0003236711128 2024-01-01 0190R0020124K000011 2024-01-01 412136 dr. YULIAN SALIS PATRIAWAN Sp.U URO Urologi N40 - Hyperplasia of prostate -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000012'
2024/01/01/000019 0001473572193 2024-01-01 0190R0020124K000012 2024-01-01 341201 dr. HANANDHA PUTRA LUQMANA, Sp.PD. INT Penyakit Dalam R50.9 - Fever, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000013'
2024/01/01/000020 0003288622307 2024-01-01 0190R0020124K000013 2024-01-01 341201 dr. HANANDHA PUTRA LUQMANA, Sp.PD. INT Penyakit Dalam R10.0 - Acute abdomen -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000014'
2024/01/01/000021 0000701995105 2024-01-01 0190R0020124K000014 2024-01-01 408 dr. Caryl Augustine J, Sp.B BED Bedah C18.9 - Malignant neoplasm of colon, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000015'
2024/01/01/000023 0000697524445 2024-01-01 0190R0020124K000015 2024-01-01 341201 dr. HANANDHA PUTRA LUQMANA, Sp.PD. INT Penyakit Dalam R11 - Nausea and vomiting -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000016'
2024/01/01/000025 0000699056155 2024-01-01 0190R0020124K000016 2024-01-01 412136 dr. YULIAN SALIS PATRIAWAN Sp.U URO Urologi N40 - Hyperplasia of prostate -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000017'
2024/01/02/000075 0003062997944 2024-01-02 0190R0020124K000017 2024-01-02 389 dr. Rofi Budiyanto Athar, Sp. A ANA Anak J40 - Bronchitis, not specified as acute or chroni... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000019'
2024/01/02/000079 0000700682747 2024-01-02 0190R0020124K000019 2024-01-02 341201 dr. HANANDHA PUTRA LUQMANA, Sp.PD. INT Penyakit Dalam R50.9 - Fever, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000020'
2024/01/02/000081 0003174487751 2024-01-02 0190R0020124K000020 2024-01-02 444393 dr. DODI TRI OKTAFIANTO, Sp.OG OBG obgyn N93 - Other abnormal uterine and vaginal bleeding -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000021'
2024/01/02/000082 0000698948526 2024-01-02 0190R0020124K000021 2024-01-02 412136 dr. YULIAN SALIS PATRIAWAN Sp.U URO Urologi N35.9 - Urethral stricture, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000022'
2024/01/02/000084 0002241662163 2024-01-02 0190R0020124K000022 2024-01-02 412136 dr. YULIAN SALIS PATRIAWAN Sp.U URO Urologi N13.0 - Hydronephrosis with ureteropelvic junction... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000035'
2024/01/02/000105 0000699996655 2024-01-02 0190R0020124K000035 2024-01-02 412136 dr. YULIAN SALIS PATRIAWAN Sp.U URO Urologi N30 - Cystitis -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000040'
2024/01/02/000118 0000114990311 2024-01-02 0190R0020124K000040 2024-01-02 374 dr. Indah Reviati Kusuma, Sp. PD INT Penyakit Dalam R50 - Fever of other and unknown origin -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000041'
2024/01/02/000122 0003108515253 2024-01-02 0190R0020124K000041 2024-01-02 389 dr. Rofi Budiyanto Athar, Sp. A ANA Anak R50.9 - Fever, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000045'
2024/01/02/000126 0003551065716 2024-01-02 0190R0020124K000045 2024-01-02 389 dr. Rofi Budiyanto Athar, Sp. A ANA Anak R50 - Fever of other and unknown origin -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000080'
2024/01/02/000036 0003552941709 2024-01-02 0190R0020124K000080 2024-01-02 444393 dr. DODI TRI OKTAFIANTO, Sp.OG OBG obgyn D25.9 - Leiomyoma of uterus, unspecified -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000085'
2024/01/02/000181 0003340277717 2024-01-02 0190R0020124K000085 2024-01-02 444393 dr. DODI TRI OKTAFIANTO, Sp.OG OBG obgyn O42.9 - Premature rupture of membranes, unspecifie... -
Edit Edit Copy Copy Delete Delete
DELETE FROM bridging_surat_pri_bpjs WHERE `bridging_surat_pri_bpjs`.`no_surat` = '0190R0020124K000089'
2024/01/02/000169 0000699639017 2024-01-02 0190R0020124K000089 2024-01-02 444393 dr. DODI TRI OKTAFIANTO, Sp.OG OBG obgyn O32.9 - Maternal care for malpresentation of fetus... -
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