synex.uk / 127.0.0.1 / superbrands_dashboard / competitor_hourly_rows

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Table navigation bar

Use only icons, only text or both.

How to display various action links

Use only icons, only text or both.

Allow to display all the rows

Whether a user should be displayed a "show all (rows)" button.

Maximum number of rows to display

Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.

Default sorting order

SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.

Highlight pointer

Highlight row pointed by the mouse cursor.

Row marker

Highlight selected rows.

Grid editing: trigger action

Grid editing: save all edited cells at once

Repeat headers

Repeat the headers every X cells, 0 deactivates this feature.

Limit column characters

Maximum number of characters shown in any non-numeric column on browse view.

Where to show the table row links

These are Edit, Copy and Delete links.

Show row links anyway

Whether to show row links even in the absence of a unique key.

Primary key default sort order

Default sort order for tables with a primary key.

Remember table's sorting

When browsing tables, the sorting of each table is remembered.

Relational display

For display Options

			id	snapshot_id	project_id	project_name	brand	group_name	currency	deposit_count	deposit_amount	withdrawal_count	withdrawal_amount	unique_player	turnover	bonus	today_deposit_count	today_deposit_amount	today_withdrawal_count 1	today_withdrawal_amount	today_unique_player	today_turnover	today_bonus
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 32410	32410	263	mcd	C1	MCW	MCW	BDT	134120	229669957.180000	41797	196336229.090000	89285	2077301802.666700	25457550.760000	134143	229725622.180000	41807	196379112.090000	89295	2082214990.814300	25460727.460000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 50424	50424	405	mcd	C1	MCW	MCW	BDT	112660	194754626.640000	41245	197416871.150000	85880	1809313399.999300	26987083.510000	112683	194813296.640000	41260	197483524.150000	85884	1809313399.999300	26989993.230000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 32277	32277	262	mcd	C1	MCW	MCW	BDT	123325	214833721.900000	39289	187145845.200000	85782	1952939455.508700	24072488.140000	123351	214878497.900000	39297	187179745.200000	85787	1952939455.508700	24075410.740000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 11704	11704	95	mcd	C1	MCW	MCW	BDT	113954	185712732.490000	38795	179830519.410000	78237	1714151970.613000	21516485.880000	113970	185733062.490000	38803	179850435.410000	78294	1714151970.613000	21518733.650000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 50297	50297	404	mcd	C1	MCW	MCW	BDT	105200	183423233.700000	38763	186837108.360000	83014	1718978330.890200	25813041.000000	105236	183457757.700000	38766	186854713.360000	83025	1722946359.840300	25814225.310000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 35532	35532	287	mcd	C1	MCW	MCW	BDT	122302	209705442.970000	38447	181300646.790000	93483	1833046366.505100	24586900.480000	122340	209758408.970000	38455	181347746.790000	93486	1833046366.505100	24589897.870000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 29402	29402	239	mcd	C1	MCW	MCW	BDT	123001	211443000.040000	38172	179320826.050000	83423	1848583645.853600	24794947.490000	123030	211467788.040000	38178	179368626.050000	83423	1848583645.853600	24796473.700000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 26407	26407	215	mcd	C1	MCW	MCW	BDT	114640	195142305.780000	38144	179690894.490000	77020	1659972497.618600	25388698.590000	114655	195155185.780000	38148	179710084.490000	77031	1659972497.618600	25391409.330000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 38620	38620	311	mcd	C1	MCW	MCW	BDT	120507	209322436.820000	38118	175125382.810000	87280	1717428620.163600	23651322.620000	120523	209351331.820000	38124	175142989.810000	87283	1717428620.163600	23661348.100000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 23437	23437	191	mcd	C1	MCW	MCW	BDT	115630	200141011.520000	37148	176600158.670000	77019	1731060096.823200	21438382.120000	115662	200191621.520000	37157	176634923.670000	77024	1731060096.823200	21442031.730000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 56835	56835	453	mcd	C1	MCW	MCW	BDT	113231	196093336.240000	37014	177650993.270000	82212	1758024054.903300	22438543.630000	113256	196135359.240000	37025	177675533.270000	82220	1758401305.903300	22440612.970000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 11568	11568	94	mcd	C1	MCW	MCW	BDT	105485	173266569.490000	36873	172103167.840000	75677	1630513043.154600	20340493.300000	105497	173307579.490000	36877	172106187.840000	75685	1630513043.154600	20344716.690000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 2755	2755	23	mcd	C1	MCW	MCW	BDT	115276	193863811.320000	36819	162571056.920000	78703	1693753171.835000	21388483.470000	115295	193903771.320000	36831	162599395.920000	78703	1696417604.990100	21392804.030000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 32145	32145	261	mcd	C1	MCW	MCW	BDT	113223	198861339.900000	36817	176460337.760000	82849	1856437478.455500	22654579.240000	113248	198897659.900000	36825	176471087.760000	82849	1856437478.455500	22658131.710000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 59851	59851	477	mcd	C1	MCW	MCW	BDT	117035	202551356.160000	36809	167435539.700000	82666	1772923616.404600	23749008.120000	117085	202601921.160000	36818	167509226.700000	82685	1773383514.434600	23755447.100000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 50170	50170	403	mcd	C1	MCW	MCW	BDT	97609	171162119.350000	36574	176739607.390000	76673	1626806021.067600	24223981.310000	97628	171163586.350000	36576	176787808.390000	76689	1626806021.067600	24225831.180000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 38577	38577	311	mcd	C1	CX	CX	BDT	115120	204598452.160000	36551	161601434.410000	90595	1523360574.159500	18500503.440000	115136	204617289.160000	36554	161635534.410000	90597	1523360574.159500	18503330.550000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 53715	53715	429	mcd	C1	MCW	MCW	BDT	105408	195247705.160000	36366	177621104.640000	81200	1754521988.839800	26500086.400000	105422	195263588.160000	36368	177644724.640000	81214	1754521988.839800	26502727.140000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 35396	35396	286	mcd	C1	MCW	MCW	BDT	111597	193352076.970000	36078	170877538.350000	89809	1584490457.330000	23117191.030000	111637	193406998.970000	36089	170914009.350000	89829	1584490457.330000	23122392.340000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 29271	29271	238	mcd	C1	MCW	MCW	BDT	112989	197499631.540000	36012	170932886.880000	80168	1752407630.199400	23503619.020000	113025	197543191.540000	36024	170972405.880000	80177	1752407630.199400	23504254.170000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 47407	47407	381	mcd	C1	MCW	MCW	BDT	113538	198682343.420000	35994	172412217.830000	79490	1769162201.503900	30421569.440000	113567	198754408.420000	35994	172400725.830000	79498	1769162201.503900	30425334.060000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 26279	26279	214	mcd	C1	MCW	MCW	BDT	106067	181825753.260000	35974	170487853.370000	74242	1573950659.838700	24159738.620000	106086	181843928.260000	35977	170490491.370000	74243	1573950659.838700	24162424.910000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 38488	38488	310	mcd	C1	MCW	MCW	BDT	110873	194504886.830000	35921	167233931.850000	84044	1674730072.857900	22269140.450000	110889	194542121.830000	35930	167247166.850000	84045	1674730072.857900	22271548.020000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 41610	41610	335	mcd	C1	MCW	MCW	BDT	111553	197894719.190000	35902	167987519.090000	81829	1741015997.958100	21982906.670000	111585	197961809.190000	35910	168009323.090000	81836	1741015997.958100	21989125.530000
Edit	Copy	Delete DELETE FROM competitor_hourly_rows WHERE `competitor_hourly_rows`.`id` = 32366	32366	263	mcd	C1	CX	CX	BDT	103173	187244958.480000	35745	176477589.320000	76680	1396008918.434800	16069823.840000	103191	187280886.480000	35757	176531194.320000	76677	1396008918.434800	16072111.920000

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.