"MySQL Query to Build Mockup Vue.js UserCP Timeline Page"

Post #303031198 by Neo on Saturday 23rd of February 2019 11:04:13 AM

OK... update! The query above had a bug.... should be firstpostid not lastpostid (stupid me!)

Code:
mysql> select thread.threadid, post.userid, post.username, thread.title, post.dateline,post.postid, thread.firstpostid from thread inner join post ON post.threadid = thread.threadid  order by dateline desc limit 100;
+----------+-----------+-----------------+--------------------------------------------------------------------------------+------------+-----------+-------------+
| threadid | userid    | username        | title                                                                          | dateline   | postid    | firstpostid |
+----------+-----------+-----------------+--------------------------------------------------------------------------------+------------+-----------+-------------+
|   281237 | 302122047 | RudiC           | Combining multiple greps                                                       | 1550932276 | 303031197 |   303031161 |
|   281080 |         1 | Neo             | Bug in ?                                                        | 1550930556 | 303031196 |   303030308 |
|   281241 |         1 | Neo             | MySQL Query to Build Mockup Vue.js UserCP Timeline Page                        | 1550929298 | 303031195 |   303031192 |
|   281237 | 302181753 | Xubuntu56       | Combining multiple greps                                                       | 1550928864 | 303031194 |   303031161 |
|   281241 |         1 | Neo             | MySQL Query to Build Mockup Vue.js UserCP Timeline Page                        | 1550927982 | 303031193 |   303031192 |
|   281241 |         1 | Neo             | MySQL Query to Build Mockup Vue.js UserCP Timeline Page                        | 1550927675 | 303031192 |   303031192 |
|   281237 | 302116191 | MadeInGermany   | Combining multiple greps                                                       | 1550927210 | 303031191 |   303031161 |
|   281237 | 302181753 | Xubuntu56       | Combining multiple greps                                                       | 1550924266 | 303031190 |   303031161 |
|   281240 | 302122047 | RudiC           | Need help with how to search a file for a variable string and delete that line | 1550917274 | 303031189 |   303031186 |
|   281239 |         1 | Neo             | Vue.js UserCP Mockup Version 0.20 - Badge Notifications                        | 1550912808 | 303031188 |   303031184 |
|   281240 | 302122727 | Don Cragun      | Need help with how to search a file for a variable string and delete that line | 1550905657 | 303031187 |   303031186 |
|   281240 | 302061468 | newbie_01       | Need help with how to search a file for a variable string and delete that line | 1550899316 | 303031186 |   303031186 |
|   281239 |         1 | Neo             | Vue.js UserCP Mockup Version 0.20 - Badge Notifications                        | 1550898573 | 303031185 |   303031184 |
|   281239 |         1 | Neo             | Vue.js UserCP Mockup Version 0.20 - Badge Notifications                        | 1550894775 | 303031184 |   303031184 |
|   281237 | 302052697 | Scrutinizer     | Combining multiple greps                                                       | 1550892712 | 303031183 |   303031161 |
|   280896 | 302130619 | baris35         | How to remove everything after a word containing string?                       | 1550881379 | 303031182 |   303029361 |
|   281155 | 302136317 | wisecracker     | Hearing Aid for OSX 10.12.x and greater.                                       | 1550876067 | 303031181 |   303030697 |
|   281238 | 302136317 | wisecracker     | Apple looking to switch to using in-house ARM chips for their HW.              | 1550864937 | 303031180 |   303031180 |
|   281233 |     43551 | Corona688       | Command line overwrite                                                         | 1550857767 | 303031179 |   303031104 |
|   281233 | 302181427 | steveo314       | Command line overwrite                                                         | 1550855904 | 303031178 |   303031104 |
|   281237 | 302181753 | Xubuntu56       | Combining multiple greps                                                       | 1550854881 | 303031177 |   303031161 |
|   281219 | 302122047 | RudiC           | Massive ftp                                                                    | 1550852841 | 303031176 |   303031020 |
|   281219 |     43551 | Corona688       | Massive ftp                                                                    | 1550852747 | 303031175 |   303031020 |
|   281219 | 302161273 | tricampeon81    | Massive ftp                                                                    | 1550850948 | 303031174 |   303031020 |
|   281233 |     43551 | Corona688       | Command line overwrite                                                         | 1550850337 | 303031173 |   303031104 |
|   281233 | 302181427 | steveo314       | Command line overwrite                                                         | 1550850038 | 303031172 |   303031104 |
|   281233 |     43551 | Corona688       | Command line overwrite                                                         | 1550849924 | 303031171 |   303031104 |
|   281219 |     43551 | Corona688       | Massive ftp                                                                    | 1550849569 | 303031170 |   303031020 |
|   281233 | 302181427 | steveo314       | Command line overwrite                                                         | 1550849260 | 303031168 |   303031104 |
|   281233 |     43551 | Corona688       | Command line overwrite                                                         | 1550849127 | 303031167 |   303031104 |
|   281233 | 302122727 | Don Cragun      | Command line overwrite                                                         | 1550848580 | 303031166 |   303031104 |
|   281235 | 302181968 | danielshell     | Mtime or the equivalent for HP-UX                                              | 1550847600 | 303031165 |   303031131 |
|   281237 |     41441 | bakunin         | Combining multiple greps                                                       | 1550846538 | 303031164 |   303031161 |
|   281237 | 302170346 | stomp           | Combining multiple greps                                                       | 1550845986 | 303031163 |   303031161 |
|   281233 | 302181427 | steveo314       | Command line overwrite                                                         | 1550845706 | 303031162 |   303031104 |
|   281237 | 302181753 | Xubuntu56       | Combining multiple greps                                                       | 1550845443 | 303031161 |   303031161 |
|   281231 | 302154737 | cmccabe         | Bash variable available for use outside loop                                   | 1550844711 | 303031160 |   303031101 |
|   281186 | 302182075 | Naina2019       | Unable to establish connection over TLS 1.2 on AIX 7.1/7.2                     | 1550844406 | 303031159 |   303030871 |
|   281219 | 302161273 | tricampeon81    | Massive ftp                                                                    | 1550843864 | 303031158 |   303031020 |
|   281236 | 302180382 | maya3           | Remove lines ending with a certain character                                   | 1550843499 | 303031157 |   303031145 |
|   281236 | 302122727 | Don Cragun      | Remove lines ending with a certain character                                   | 1550843379 | 303031156 |   303031145 |
|   281213 | 302102414 | Azrael          | Combine GetOpt And Variadic Function In C                                      | 1550841256 | 303031155 |   303030978 |
|   281236 | 302122047 | RudiC           | Remove lines ending with a certain character                                   | 1550840761 | 303031154 |   303031145 |
|   281236 | 302180382 | maya3           | Remove lines ending with a certain character                                   | 1550839294 | 303031153 |   303031145 |
|   281236 | 302122727 | Don Cragun      | Remove lines ending with a certain character                                   | 1550838067 | 303031152 |   303031145 |
|   281236 | 302122047 | RudiC           | Remove lines ending with a certain character                                   | 1550837907 | 303031151 |   303031145 |
|   281236 |     21292 | milhan          | Remove lines ending with a certain character                                   | 1550837864 | 303031150 |   303031145 |
|   281230 | 302182108 | LouisLakoute    | Sun fire x2270                                                                 | 1550837452 | 303031148 |   303031097 |
|   281219 | 302161273 | tricampeon81    | Massive ftp                                                                    | 1550836895 | 303031147 |   303031020 |
|   281235 | 302024200 | drl             | Mtime or the equivalent for HP-UX                                              | 1550836737 | 303031146 |   303031131 |
|   281236 | 302180382 | maya3           | Remove lines ending with a certain character                                   | 1550836350 | 303031145 |   303031145 |
|   281235 | 302122047 | RudiC           | Mtime or the equivalent for HP-UX                                              | 1550831404 | 303031144 |   303031131 |
|   281235 |         1 | Neo             | Mtime or the equivalent for HP-UX                                              | 1550830225 | 303031143 |   303031131 |
|   281193 | 302116191 | MadeInGermany   | "sudo su -" showing lot of information on OpenLDAP                   | 1550829217 | 303031142 |   303030887 |
|   281229 | 302122047 | RudiC           | awk Script Output Help                                                         | 1550828438 | 303031141 |   303031095 |
|   281233 |     21292 | milhan          | Command line overwrite                                                         | 1550828168 | 303031140 |   303031104 |
|   281233 | 302122047 | RudiC           | Command line overwrite                                                         | 1550827042 | 303031139 |   303031104 |
|   281219 | 302122047 | RudiC           | Massive ftp                                                                    | 1550826581 | 303031138 |   303031020 |
|   281230 | 302116191 | MadeInGermany   | Sun fire x2270                                                                 | 1550823294 | 303031137 |   303031097 |
|   281207 | 302181242 | nezabudka       | Help building a variable string from a keyword - character replacements!       | 1550819198 | 303031136 |   303030946 |
|   281233 | 302052697 | Scrutinizer     | Command line overwrite                                                         | 1550816093 | 303031135 |   303031104 |
|   281207 | 302148617 | RavinderSingh13 | Help building a variable string from a keyword - character replacements!       | 1550814489 | 303031134 |   303030946 |
|   281207 | 302181242 | nezabudka       | Help building a variable string from a keyword - character replacements!       | 1550813803 | 303031133 |   303030946 |
|   281234 |         1 | Neo             | Help to remove malware                                                         | 1550811877 | 303031132 |   303031113 |
|   281235 | 302181968 | danielshell     | Mtime or the equivalent for HP-UX                                              | 1550808466 | 303031131 |   303031131 |
|   281230 | 302182108 | LouisLakoute    | Sun fire x2270                                                                 | 1550799421 | 303031130 |   303031097 |
|   281219 | 302161273 | tricampeon81    | Massive ftp                                                                    | 1550797928 | 303031128 |   303031020 |
|   281229 |     37898 | vgersh99        | awk Script Output Help                                                         | 1550792040 | 303031127 |   303031095 |
|   281207 | 302116191 | MadeInGermany   | Help building a variable string from a keyword - character replacements!       | 1550791764 | 303031126 |   303030946 |
|   281229 | 302122727 | Don Cragun      | awk Script Output Help                                                         | 1550791451 | 303031125 |   303031095 |
|   281232 |     43551 | Corona688       | Queue enabler for Solaris 11.3                                                 | 1550790171 | 303031124 |   303031103 |
|   281219 |     43551 | Corona688       | Massive ftp                                                                    | 1550790098 | 303031123 |   303031020 |
|   281232 | 302165712 | feroccimx       | Queue enabler for Solaris 11.3                                                 | 1550789433 | 303031122 |   303031103 |
|   281229 | 302182107 | Marquez3105     | awk Script Output Help                                                         | 1550789370 | 303031120 |   303031095 |
|   281230 | 302116191 | MadeInGermany   | Sun fire x2270                                                                 | 1550788506 | 303031119 |   303031097 |
|   281219 |     43551 | Corona688       | Massive ftp                                                                    | 1550787798 | 303031118 |   303031020 |
|   281234 |     43551 | Corona688       | Help to remove malware                                                         | 1550787757 | 303031117 |   303031113 |
|   281229 | 302122047 | RudiC           | awk Script Output Help                                                         | 1550787072 | 303031116 |   303031095 |
|   281232 | 302116191 | MadeInGermany   | Queue enabler for Solaris 11.3                                                 | 1550786232 | 303031115 |   303031103 |
|   281219 | 302122047 | RudiC           | Massive ftp                                                                    | 1550785992 | 303031114 |   303031020 |
|   281234 | 302182064 | asoh65          | Help to remove malware                                                         | 1550784585 | 303031113 |   303031113 |
|   281229 |     37898 | vgersh99        | awk Script Output Help                                                         | 1550783445 | 303031112 |   303031095 |
|   281219 | 302161273 | tricampeon81    | Massive ftp                                                                    | 1550783020 | 303031111 |   303031020 |
|   281233 | 302181427 | steveo314       | Command line overwrite                                                         | 1550781867 | 303031110 |   303031104 |
|   281232 |     43551 | Corona688       | Queue enabler for Solaris 11.3                                                 | 1550781623 | 303031109 |   303031103 |
|   281231 |     43551 | Corona688       | Bash variable available for use outside loop                                   | 1550781393 | 303031108 |   303031101 |
|   281233 | 302052697 | Scrutinizer     | Command line overwrite                                                         | 1550780787 | 303031107 |   303031104 |
|   281231 | 302136317 | wisecracker     | Bash variable available for use outside loop                                   | 1550780492 | 303031106 |   303031101 |
|   281229 | 302182107 | Marquez3105     | awk Script Output Help                                                         | 1550779805 | 303031105 |   303031095 |
|   281233 | 302181427 | steveo314       | Command line overwrite                                                         | 1550779477 | 303031104 |   303031104 |
|   281232 | 302165712 | feroccimx       | Queue enabler for Solaris 11.3                                                 | 1550778090 | 303031103 |   303031103 |
|   281229 | 302126107 | rdrtx1          | awk Script Output Help                                                         | 1550778034 | 303031102 |   303031095 |
|   281231 | 302154737 | cmccabe         | Bash variable available for use outside loop                                   | 1550777016 | 303031101 |   303031101 |
|   281207 | 302126107 | rdrtx1          | Help building a variable string from a keyword - character replacements!       | 1550775920 | 303031100 |   303030946 |
|   281229 | 302182107 | Marquez3105     | awk Script Output Help                                                         | 1550774371 | 303031099 |   303031095 |
|   281207 | 302182084 | ghaniba         | Help building a variable string from a keyword - character replacements!       | 1550773723 | 303031098 |   303030946 |
|   281230 | 302182108 | LouisLakoute    | Sun fire x2270                                                                 | 1550773021 | 303031097 |   303031097 |
|   281229 |     37898 | vgersh99        | awk Script Output Help                                                         | 1550772924 | 303031096 |   303031095 |
|   281229 | 302182107 | Marquez3105     | awk Script Output Help                                                         | 1550771178 | 303031095 |   303031095 |
|   281222 |         1 | Neo             | Forum Advisor MySQL Query for New UserCP Table Mockup                          | 1550769939 | 303031094 |   303031047 |
+----------+-----------+-----------------+--------------------------------------------------------------------------------+------------+-----------+-------------+
100 rows in set (0.00 sec)

 
Related Linux and UNIX Technical Support
Vue.js UserCP Mockup Version 0.20 - Badge Notifications
Neo
Vue.js UserCP Mockup Version 0.20 - Badge Notifications https://www.unix.com/cp/index.php#/dashboardIn this mockup release: Badge Notifications are working with live data: Upper Right (see image) Added Axios to Vue and changed large table updates to axios (ajax) Note: Will reformat...... Web Development
2
Web Development
New Discussion Timeline in Vue.js UserCP Mockup
Neo
Well, thanks to the amazing power of Vue.js, we now have a new timeline in version 0.23 of the UserCP Mockup: Wow! I'm really impressed with Vue.js. https://www.unix.com/cp/index.php#/pages/timeline In this version: Created database, and PHP model for the remote AJAX (Axios) call to...... Web Development
1
Web Development
New Badge Timeline in Vue.js UserCP Mockup
Neo
Continuing to think Vue.js is AWESOME, we now have a new badges timeline in version 0.26 of the UserCP Mockup: https://www.unix.com/cp/index.php#/pages/badges Changes: Added Mockup from Badges timeline. Changed notifications (upper right) to use v-for: bindings. Fixes minor vue routing...... Web Development
0
Web Development
New UserCP Update Profile Image Page (UserCP Screeching Frog 0.7485)
Neo
Update! UserCP Screeching Frog 0.7485 Created a new page for uploaded a profile picture (profile pictures are different than avatar pictures). https://www.unix.com/usercp/#/settings/other https://www.unix.com/members/1-albums225-picture1158.png ...... What is on Your Mind?
0
What is on Your Mind?
MYSQLDUMPSLOW(1)					       MySQL Database System						  MYSQLDUMPSLOW(1)

NAME
mysqldumpslow - Summarize slow query log files
SYNOPSIS
mysqldumpslow [options] [log_file ...]
DESCRIPTION
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.2.5, "The Slow Query Log"). mysqldumpslow parses MySQL slow query log files and prints a summary of their contents. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It "abstracts" these values to N and 'S' when displaying summary output. The -a and -n options can be used to modify value abstracting behavior. Invoke mysqldumpslow like this: shell> mysqldumpslow [options] [log_file ...] mysqldumpslow supports the following options. o --help Display a help message and exit. o -a Do not abstract all numbers to N and strings to 'S'. o --debug, -d Run in debug mode. o -g pattern Consider only queries that match the (grep-style) pattern. o -h host_name Host name of MySQL server for *-slow.log file name. The value can contain a wildcare. The default is * (match all). o -i name Name of server instance (if using mysql.server startup script). o -l Do not subtract lock time from total time. o -n N Abstract numbers with at least N digits within names. o -r Reverse the sort order. o -s sort_type How to sort the output. The value of sort_type should be chosen from the following list: o t, at: Sort by query time or average query time o l, al: Sort by lock time or average lock time o s, as: Sort by rows sent or average rows sent o c: Sort by count o -t N Display only the first N queries in the output. o --verbose, -v Verbose mode. Print more information about what the program does. Example of usage: shell> mysqldumpslow Reading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1 Count: 3 Time=2.53s (7s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1 limit N Count: 3 Time=2.13s (6s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t1 select * from t1
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/). MySQL 5.1 04/06/2010 MYSQLDUMPSLOW(1)

Featured Tech Videos