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 :
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 `members`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
Filter rows:
Sort by key:
Full texts id company salutation briefanrede title dateOfBirth firstname surname addressBlock street postcode city telephoneNo mobileNo email areas notNeedMoreInforming
0- No 1- Yes 		noEmailCheck
0- No 1- Yes 		emailCheckedDate MemberType MemberFinalType BearbeitungsStatus BriefSex MoneyPayerID CountOfBed NewsletterLanguage StartExt StartFile TillDate FromDate FinishFile FinishExt StillToEdit BankInfoForStiillToEdit status
0- Deactivate 1- Activate 		deleted
0- No 1- Yes 		addedOn addedBy modifiedBy modifiedOn
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 1
 		1 Cognito Informationssysteme GmbH & Co. K 5 3 -1 1961-09-21 Matthias Ketteler Firma Cognito GmbH & Co.KG
Herrn Matthias Kettele...		 Hasenwinkeler Str. 184 44879 Bochum 0172 - 2804503 technik@cognito-ambulant.de 0 0 0000-00-00 member member 4 Sehr geehrter Herr Ketteler -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 2
 		2 Haupt & Linnemann GbR 3 4 -1 0000-00-00 Haupt & Linnemann GbR Firma Haupt & Linnemann GbR
Geschäftsleitung
Röm...		 Niederstraße 1 46509 Xanten / Niederrhein 02801 780 info@hotel-nibelungenhof.de 0 0 0000-00-00 member member 4 Sehr geehrte Damen und Herren -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 3
 		3 Haupt GmbH (Hotel Nibelungen Hof) 1 4 -1 0000-00-00 Firma Haupt GmbH
Geschäftsleitung
Römerstr. 18
...		 Niederstr. 1 46509 Xanten 02801 780 info@hotel-nibelungenhof.de 0 0 0000-00-00 member member 4 Sehr geehrte Damen und Herren -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 4
 		4 Technische Bürosysteme GmbH 5 3 -1 0000-00-00 Thomas Wybranietz Firma Technische Bürosysteme GmbH
Geschäftsleitun...		 Leusbergstraße 42 45663 Herne 0163 8638694 t.wybranietz@tbg-herne.de 0 0 0000-00-00 member member 4 Sehr geehrte Damen und Herren -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 6
 		6 5 3 -1 0000-00-00 Achim Raab Kassenberger Str. 150 44879 Bochum 0234 - 2982696 0172 2351130 achimraab@gmx.net 0 0 0000-00-00 member member 1 Sehr geehrter Herr Raab -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 7
 		7 4 4 -1 0000-00-00 Agnes Gerdemann Tönisheider Str. 56 42553 Velbert 02324 52118 agnes.gerdemann@t-online.de 0 0 0000-00-00 member member 1 Sehr geehrte Frau Gerdemann -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 8
 		8 2 4 -1 0000-00-00 Aloys und Annemarie Hartmann Auf dem Loh 11 45289 Essen 0201 578745 0 0 0000-00-00 member member 4 Sehr geehrte Eheleute Hartmann -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 9
 		9 5 3 -1 0000-00-00 Andre Heuer Kohlenstraße 67 45289 Essen 0173 5152649 andreheuer@gmx.de 0 0 0000-00-00 member member 1 Sehr geehrter Herr Heuer -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 10
 		10 5 3 -1 0000-00-00 Andreas Kernebeck Kohlenstr. 39 45289 Essen 0201 5718561 akernebeck63@web.de 0 0 0000-00-00 member member 4 Sehr geehrter Herr Kernebeck -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 11
 		11 5 3 -1 0000-00-00 Andreas Klink Buschstr. 31a 45276 Essen 0201 513571 Andreas.Klink@t-online.de 0 0 0000-00-00 member member 1 Sehr geehrter Herr Klink -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 12
 		12 5 3 -1 0000-00-00 Andreas Zander Monstadtstr.25 44866 Bochum ??????????? 0 0 0000-00-00 member member 4 Sehr geehrter Herr Zander -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 13
 		13 4 4 -1 0000-00-00 Angelika Michelitsch Dalhauser Str. 152b 45279 Essen 0201 539141 angelika.michelitsch@web.de 0 0 0000-00-00 member member 1 Sehr geehrte Frau Michelitsch -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 14
 		14 4 4 1 0000-00-00 Anke Kampschulte Selbsthilfeweg 15 44799 Bochum 0234 866467 anke.kampschulte@ruhr-uni-bochum.de 0 0 0000-00-00 member member 1 Sehr geehrte Frau Kampschulte -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 15
 		15 4 4 -1 0000-00-00 Annette Oehl Totilastr. 17 44803 Bochum 0234 352719 0 1 0000-00-00 member member 4 Sehr geehrte Frau Oehl -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 16
 		16 5 3 -1 0000-00-00 Günther Steinbrink Mönkhoffstr. 55 45277 Essen 0163 - 2341436 guenther.steinbrink@gmx.de 0 0 2022-11-02 member member 1 Sehr geehrte Eheleute Steinbrink -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 17
 		17 5 3 -1 0000-00-00 Armin Lökenhoff Selbsthilfeweg 15 44799 Bochum 0234 594724 praxis@kinderarzt-wetter.de 0 0 0000-00-00 member member 1 Sehr geehrter Herr Lökenhoff -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 18
 		18 5 3 -1 0000-00-00 Arthur Janitzek Littgenloh 36 44379 Dortmund 0231-9638958 0177-5802669 arthurjanitzek@web.de 0 0 0000-00-00 member member 1 Sehr geehrter Herr Janitzek -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 19
 		19 4 4 -1 0000-00-00 Bianca Frick Gartenstr. 15 45468 Mülheim an der Ruhr 0176 24412197 0 0 0000-00-00 member member 4 Sehr geehrte Frau Frick -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 20
 		20 4 4 -1 0000-00-00 Birgit Fabbian Voltastr. 27 44879 Bochum 0234 411242 birgit@consult42.de 0 0 0000-00-00 member member 4 Liebe Birgit -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 21
 		21 4 4 -1 0000-00-00 Birgit Neu/Lins Auf der Bochumer Landwehr 39 44791 Bochum 0234 3252552 udolins@unitybox.de 0 0 0000-00-00 member member 4 Sehr geehrte Frau Lins -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 22
 		22 4 4 -1 0000-00-00 Birgit Schneider Handwerksweg 17 44805 Essen 0234 860927 0151 11807602 bschneider59@icloud.com 0 0 0000-00-00 member member 1 Sehr geehrte Frau Schneider -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 23
 		23 4 4 -1 0000-00-00 Birgit Schrowange Petersbergstr. 46 50939 Köln 0 1 2022-11-22 member member 4 Sehr geehrte Frau Schrowange -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 24
 		24 4 4 -1 0000-00-00 Brigitte Lieken Mittenfelder Weg 12 26935 Stadland 04732-921154 ilonal58@yahoo.de 0 0 0000-00-00 member member 1 Sehr geehrte Frau Lieken -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 25
 		25 5 3 -1 0000-00-00 Detlef Arndt Bogenstr. 76 45527 Hattingen 02324 33702 debr.arndt@gmx.de 3 0 0 2022-11-13 member member 4 Sehr geehrte Eheleute Arndt -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM members WHERE `members`.`id` = 26
 		26 5 3 -1 0000-00-00 Heinz - Jürgen Friemann Hermann-Duesmann-Str. 12 45289 Essen 0201 571410 brigitte.friemann@gmx.de 0 0 0000-00-00 member member 1 Sehr geehrte Eheleute Friemann -1 0 german 0000-00-00 0000-00-00 Nein 1 0 0000-00-00 00:00:00 0 0 2024-12-03 08:14:16
With selected: With selected:
|
|
|
Filter rows:
Sort by key:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view