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
Customise 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 `rce_blogwsm_datewisebouncerate` ORDER BY `bounce` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts recordDate bounce Descending Ascending 1 pageViews visitors bRatePageViews bRateVisitors
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-04-22' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 112 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 153 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 113 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 73.2026 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 99.1150 LIMIT 1
2023-04-22 112 153 113 73.2026 99.1150
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-21' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 97 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 279 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 117 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 34.7670 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 82.9060 LIMIT 1
2023-05-21 97 279 117 34.7670 82.9060
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-04-28' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 90 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 374 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 114 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 24.0642 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 78.9474 LIMIT 1
2023-04-28 90 374 114 24.0642 78.9474
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-07' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 75 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 159 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 81 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 47.1698 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 92.5926 LIMIT 1
2023-05-07 75 159 81 47.1698 92.5926
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-03-29' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 75 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 141 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 76 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 53.1915 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 98.6842 LIMIT 1
2023-03-29 75 141 76 53.1915 98.6842
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-16' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 70 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 192 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 73 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 36.4583 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 95.8904 LIMIT 1
2023-05-16 70 192 73 36.4583 95.8904
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-20' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 68 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 174 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 78 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 39.0805 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 87.1795 LIMIT 1
2023-05-20 68 174 78 39.0805 87.1795
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-06-08' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 67 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 372 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 72 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 18.0108 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 93.0556 LIMIT 1
2023-06-08 67 372 72 18.0108 93.0556
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-27' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 65 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 168 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 77 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 38.6905 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 84.4156 LIMIT 1
2023-05-27 65 168 77 38.6905 84.4156
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-19' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 63 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 236 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 73 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 26.6949 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 86.3014 LIMIT 1
2023-05-19 63 236 73 26.6949 86.3014
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-22' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 60 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 251 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 72 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 23.9044 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 83.3333 LIMIT 1
2023-05-22 60 251 72 23.9044 83.3333
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-24' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 55 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 243 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 71 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 22.6337 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 77.4648 LIMIT 1
2023-05-24 55 243 71 22.6337 77.4648
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2024-07-17' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 54 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 90 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 55 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 60.0000 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 98.1818 LIMIT 1
2024-07-17 54 90 55 60.0000 98.1818
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-23' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 51 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 265 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 65 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 19.2453 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 78.4615 LIMIT 1
2023-05-23 51 265 65 19.2453 78.4615
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-26' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 50 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 143 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 56 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 34.9650 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 89.2857 LIMIT 1
2023-05-26 50 143 56 34.9650 89.2857
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-06-10' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 50 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 220 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 58 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 22.7273 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 86.2069 LIMIT 1
2023-06-10 50 220 58 22.7273 86.2069
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-06-11' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 48 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 124 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 57 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 38.7097 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 84.2105 LIMIT 1
2023-06-11 48 124 57 38.7097 84.2105
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-06-09' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 45 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 177 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 58 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 25.4237 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 77.5862 LIMIT 1
2023-06-09 45 177 58 25.4237 77.5862
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-06-01' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 44 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 148 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 53 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 29.7297 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 83.0189 LIMIT 1
2023-06-01 44 148 53 29.7297 83.0189
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-02-03' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 43 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 57 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 45 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 75.4386 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 95.5556 LIMIT 1
2023-02-03 43 57 45 75.4386 95.5556
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2024-06-05' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 42 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 132 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 43 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 31.8182 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 97.6744 LIMIT 1
2024-06-05 42 132 43 31.8182 97.6744
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-04-17' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 41 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 91 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 43 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 45.0549 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 95.3488 LIMIT 1
2023-04-17 41 91 43 45.0549 95.3488
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-03-28' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 40 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 140 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 42 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 28.5714 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 95.2381 LIMIT 1
2023-03-28 40 140 42 28.5714 95.2381
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2023-05-13' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 40 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 115 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 49 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 34.7826 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 81.6327 LIMIT 1
2023-05-13 40 115 49 34.7826 81.6327
Edit Edit Copy Copy Delete Delete
DELETE FROM rce_blogwsm_datewisebouncerate WHERE `rce_blogwsm_datewisebouncerate`.`recordDate` = '2024-08-18' AND `rce_blogwsm_datewisebouncerate`.`bounce` = 38 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`pageViews`) = 54 AND `rce_blogwsm_datewisebouncerate`.`visitors` = 38 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRatePageViews`) = 70.3704 AND CONCAT(`rce_blogwsm_datewisebouncerate`.`bRateVisitors`) = 100.0000 LIMIT 1
2024-08-18 38 54 38 70.3704 100.0000
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