maybe that helps?
mysql> select m.member_name, msg.subject, CONCAT("https://www.magiclantern.fm/forum/index.php?topic=",msg.id_topic,".msg",msg.id_msg,"#msg",msg.id_msg) from smf_messages as msg, smf_members as m where msg.body like '%dropbox.com/u/%' and m.id_member = msg.id_member;
+-----------------+--------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------+
| member_name | subject | CONCAT("https://www.magiclantern.fm/forum/index.php?topic=",msg.id_topic,".msg",msg.id_msg,"#msg",msg.id_msg) |
+-----------------+--------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------+
| scrax | OsX: Automate most of ML post task | https://www.magiclantern.fm/forum/index.php?topic=1019.msg1258#msg1258 |
| scrax | Re: Compiling on a Mac | https://www.magiclantern.fm/forum/index.php?topic=1013.msg1359#msg1359 |
| coutts | Re: Compiling on a Mac | https://www.magiclantern.fm/forum/index.php?topic=1013.msg1379#msg1379 |
| scrax | [SOLVED] Err 70 during HDR on 600D, logs attached | https://www.magiclantern.fm/forum/index.php?topic=1095.msg1536#msg1536 |
| scrax | Re: New menu layout | https://www.magiclantern.fm/forum/index.php?topic=1145.msg1930#msg1930 |
| scrax | Re: [CLEANUP] What features are useless and can be removed? | https://www.magiclantern.fm/forum/index.php?topic=1130.msg1974#msg1974 |
| CameraRick | Magic Lantern Logo | https://www.magiclantern.fm/forum/index.php?topic=1325.msg3032#msg3032 |
| benoitvm | Re: Frozen frames with 600D/T3i: Canon, ML or SDHC to blame ? | https://www.magiclantern.fm/forum/index.php?topic=1282.msg3235#msg3235 |
| juantrueno | Color Changes in 600D with ML | https://www.magiclantern.fm/forum/index.php?topic=1361.msg3279#msg3279 |
| Audionut | Bit rate investigation | https://www.magiclantern.fm/forum/index.php?topic=1565.msg3935#msg3935 |
| weldroid | Re: Bit rate investigation - altering ratio between P and I frame sizes | https://www.magiclantern.fm/forum/index.php?topic=1565.msg4201#msg4201 |
| scrax | Re: Design proposals for future ML interface | https://www.magiclantern.fm/forum/index.php?topic=1185.msg4817#msg4817 |
| ilguercio | Re: Bit rate investigation - altering ratio between P and I frame sizes | https://www.magiclantern.fm/forum/index.php?topic=1565.msg4926#msg4926 |
| ilguercio | Re: Bit rate investigation - altering ratio between P and I frame sizes | https://www.magiclantern.fm/forum/index.php?topic=1565.msg4933#msg4933 |
| ilguercio | Re: Bit rate investigation - altering ratio between P and I frame sizes | https://www.magiclantern.fm/forum/index.php?topic=1565.msg4936#msg4936 |
| screamer | Re: Need Some Crop Marks for your shoot/feature? | https://www.magiclantern.fm/forum/index.php?topic=1378.msg5561#msg5561 |
| screamer | creating cromparks in windows and my first cropmark for facebook timeline | https://www.magiclantern.fm/forum/index.php?topic=1752.msg5562#msg5562 |
| weldroid | Re: Exposure (ISO?) problem after FW upgrade | https://www.magiclantern.fm/forum/index.php?topic=1801.msg5889#msg5889 |
| ilguercio | [SOLVED] Magic Zoom going crazy (50D) | https://www.magiclantern.fm/forum/index.php?topic=1962.msg6981#msg6981 |
| ilguercio | Re: JPCORE Hacking 4:2:2? | https://www.magiclantern.fm/forum/index.php?topic=1992.msg7631#msg7631 |
| nanomad | Re: JPCORE Hacking 4:2:2? | https://www.magiclantern.fm/forum/index.php?topic=1992.msg7659#msg7659 |
| doctormord | [550D] Err70 when connecting camera via USB-HOST to android tablet | https://www.magiclantern.fm/forum/index.php?topic=2208.msg8347#msg8347 |
| rc | Compile woes | https://www.magiclantern.fm/forum/index.php?topic=2363.msg9202#msg9202 |
| vijayforvictory | Vijay From Bristol | https://www.magiclantern.fm/forum/index.php?topic=2473.msg9748#msg9748 |
| Marsu42 | Re: Compile ml w/ Linaro gcc? | https://www.magiclantern.fm/forum/index.php?topic=2563.msg10420#msg10420 |
| ilguercio | Re: Compile ml w/ Linaro gcc? | https://www.magiclantern.fm/forum/index.php?topic=2563.msg10406#msg10406 |
| ilguercio | Re: CBR x3 Test video | https://www.magiclantern.fm/forum/index.php?topic=2579.msg10553#msg10553 |
| rogernick | Re: Vijay From Bristol | https://www.magiclantern.fm/forum/index.php?topic=2473.msg10772#msg10772 |
| ilguercio | Re: Menu option disappears if you activate it (2.3.60D.111 / 7fee07c3b461) | https://www.magiclantern.fm/forum/index.php?topic=2730.msg11575#msg11575 |
| Marsu42 | Re: OsX: Automate most of ML post task | https://www.magiclantern.fm/forum/index.php?topic=1019.msg12223#msg12223 |
| ilguercio | Re: Gettings started as developer | https://www.magiclantern.fm/forum/index.php?topic=2899.msg14047#msg14047 |
| ilguercio | Re: Gettings started as developer | https://www.magiclantern.fm/forum/index.php?topic=2899.msg14208#msg14208 |
| ilguercio | Re: Gettings started as developer | https://www.magiclantern.fm/forum/index.php?topic=2899.msg14218#msg14218 |
| ilguercio | Re: Gettings started as developer | https://www.magiclantern.fm/forum/index.php?topic=2899.msg14411#msg14411 |
| feureau | Re: First 7D alpha released! | https://www.magiclantern.fm/forum/index.php?topic=3103.msg15046#msg15046 |
| scrax | MLTools (OsX utility to manage ML install, files import and scripts conversions) | https://www.magiclantern.fm/forum/index.php?topic=3150.msg15081#msg15081 |
| scrax | Re: MLTools (OsX utility to manage ML install, files import and scripts conversions) | https://www.magiclantern.fm/forum/index.php?topic=3150.msg15160#msg15160 |
| scrax | Re: MLTools (OsX utility to manage ML install, files import and scripts conversions) | https://www.magiclantern.fm/forum/index.php?topic=3150.msg15195#msg15195 |
| ilguercio | Re: what am I doing wrong? | https://www.magiclantern.fm/forum/index.php?topic=3157.msg15233#msg15233 |
| ilguercio | Re: Mirror lock-up trick for handheld shots (poor man IS) | https://www.magiclantern.fm/forum/index.php?topic=3236.msg16346#msg16346 |
| ilguercio | Re: Low-level API tests for stubs | https://www.magiclantern.fm/forum/index.php?topic=3419.msg17015#msg17015 |
| ilguercio | Re: Low-level API tests for stubs | https://www.magiclantern.fm/forum/index.php?topic=3419.msg17022#msg17022 |
| coutts | 5dc disassembled - ultra high-res pics | https://www.magiclantern.fm/forum/index.php?topic=3443.msg17204#msg17204 |
| akshayverma1 | Re: 7D at Halloween: The Bitrate-Monster (EXPERIMENTAL) | https://www.magiclantern.fm/forum/index.php?topic=3404.msg17238#msg17238 |
| feureau | Re: 7D at Halloween: The Bitrate-Monster (EXPERIMENTAL) | https://www.magiclantern.fm/forum/index.php?topic=3404.msg17270#msg17270 |
| coutts | Re: 5dc disassembled - ultra high-res pics | https://www.magiclantern.fm/forum/index.php?topic=3443.msg17329#msg17329 |
| nanomad | Re: 5dc disassembled - ultra high-res pics | https://www.magiclantern.fm/forum/index.php?topic=3443.msg17380#msg17380 |
| akshayverma1 | Re: First 7D alpha released! | https://www.magiclantern.fm/forum/index.php?topic=3103.msg17456#msg17456 |
| ecek2 | Re: New canon EOS M mirrorless cameras | https://www.magiclantern.fm/forum/index.php?topic=1618.msg17598#msg17598 |
| ilguercio | [INVALID] What happened? | https://www.magiclantern.fm/forum/index.php?topic=3565.msg18491#msg18491 |
| xmd5a | Re: First 7D alpha released! | https://www.magiclantern.fm/forum/index.php?topic=3103.msg18744#msg18744 |
| coutts | EOS M ** Alpha 1 ** [FIXED][DOWNLOAD] | https://www.magiclantern.fm/forum/index.php?topic=3648.msg19069#msg19069 |
| scrax | Re: ML Universal installer | https://www.magiclantern.fm/forum/index.php?topic=3379.msg19128#msg19128 |
| scrax | Re: MLTools (OsX utility to manage ML install, files import and scripts conversions) | https://www.magiclantern.fm/forum/index.php?topic=3150.msg19374#msg19374 |
| LvP | FPS Override settings - Question - / Canon Menue Flickering | https://www.magiclantern.fm/forum/index.php?topic=3810.msg20437#msg20437 |
| scrax | Re: ICON file | https://www.magiclantern.fm/forum/index.php?topic=3800.msg20493#msg20493 |
| LvP | Re: FPS Override settings - Question - / Canon Menue Flickering | https://www.magiclantern.fm/forum/index.php?topic=3810.msg20527#msg20527 |
| scrax | Re: ICON file | https://www.magiclantern.fm/forum/index.php?topic=3800.msg20753#msg20753 |
| jplxpto | Re: ICON file | https://www.magiclantern.fm/forum/index.php?topic=3800.msg20759#msg20759 |
| scrax | Re: Scroll Wheel and Button control icons as used in Menus for video tutorial | https://www.magiclantern.fm/forum/index.php?topic=3826.msg20783#msg20783 |
| coutts | Canon 6D / Firmware 1.1.3 | https://www.magiclantern.fm/forum/index.php?topic=3904.msg21154#msg21154 |
| coutts | Re: 6D says Hello World!! | https://www.magiclantern.fm/forum/index.php?topic=3904.msg21295#msg21295 |
| scrax | Re: 1100D Crop mark error and lens noise | https://www.magiclantern.fm/forum/index.php?topic=3938.msg21478#msg21478 |
| coutts | Re: Magic Lantern for 6D | Dev kit released | https://www.magiclantern.fm/forum/index.php?topic=3904.msg21560#msg21560 |
| coutts | Re: Magic Lantern for 6D | Dev kit released | https://www.magiclantern.fm/forum/index.php?topic=3904.msg21561#msg21561 |
| scrax | Err 70 during test 600D | https://www.magiclantern.fm/forum/index.php?topic=4058.msg22402#msg22402 |
| LvP | Color Sheme in LiveScreenDisplay | https://www.magiclantern.fm/forum/index.php?topic=4132.msg22849#msg22849 |
| scrax | Re: Main menu design proposal | https://www.magiclantern.fm/forum/index.php?topic=3963.msg22920#msg22920 |
| Derpington | [SCRIPTING] Manual exposure ramping over time | https://www.magiclantern.fm/forum/index.php?topic=4201.msg23329#msg23329 |
| scrax | Re: Development stupid questions | https://www.magiclantern.fm/forum/index.php?topic=1113.msg25413#msg25413 |
| scrax | Re: Security Breach | https://www.magiclantern.fm/forum/index.php?topic=4484.msg25963#msg25963 |
| scrax | Re: Security Breach | https://www.magiclantern.fm/forum/index.php?topic=4484.msg25997#msg25997 |
| tinyenormous | Re: bramping where initial scene is dark - seeking advice | https://www.magiclantern.fm/forum/index.php?topic=4059.msg26039#msg26039 |
| scrax | Re: ML UI rationalization | https://www.magiclantern.fm/forum/index.php?topic=4386.msg26174#msg26174 |
| dlrpgmsvc | Re: Improved vectorscope | https://www.magiclantern.fm/forum/index.php?topic=4541.msg26274#msg26274 |
| scrax | New Home Layout suggestion | https://www.magiclantern.fm/forum/index.php?topic=4570.msg26397#msg26397 |
| coutts | High-quality ML screenshots for new website | https://www.magiclantern.fm/forum/index.php?topic=4576.msg26457#msg26457 |
| coutts | Re: High-quality ML screenshots for new website | https://www.magiclantern.fm/forum/index.php?topic=4576.msg26518#msg26518 |
| Leon | [USER ERR] Hi-Res Silent Pictures ruined by expo jumps (ML v2.3.NEXT.2013Feb18) | https://www.magiclantern.fm/forum/index.php?topic=4625.msg26968#msg26968 |
| wardoost | [LASER DAMAGE?] 550D err70 problem | https://www.magiclantern.fm/forum/index.php?topic=4701.msg27477#msg27477 |
| Malex | Re: Tragic Lantern for 6D | https://www.magiclantern.fm/forum/index.php?topic=9510.msg28294#msg28294 |
| scrax | Re: New Home Layout suggestion | https://www.magiclantern.fm/forum/index.php?topic=4570.msg28627#msg28627 |
| coutts | Re: New Home Layout suggestion | https://www.magiclantern.fm/forum/index.php?topic=4570.msg28652#msg28652 |
| Malex | Re: Tragic Lantern for 6D | https://www.magiclantern.fm/forum/index.php?topic=9510.msg29036#msg29036 |
| Anton2707 | Re: Silent pic 4x5 and 5x5 bad result | https://www.magiclantern.fm/forum/index.php?topic=4909.msg30187#msg30187 |
| Anton2707 | Re: Silent pic 4x5 and 5x5 bad result | https://www.magiclantern.fm/forum/index.php?topic=4909.msg30190#msg30190 |
| Anton2707 | Re: Silent pic 4x5 and 5x5 bad result | https://www.magiclantern.fm/forum/index.php?topic=4909.msg30196#msg30196 |
| Audionut | Re: Motion Detection lightning shots | https://www.magiclantern.fm/forum/index.php?topic=5078.msg30306#msg30306 |
| noisyboy | Re: Motion Detection lightning shots | https://www.magiclantern.fm/forum/index.php?topic=5078.msg33509#msg33509 |
| ThLDQ | Re: HOW TO: A guide to installing ML on the 7D for noobs by a noob. Newbies welcome! | https://www.magiclantern.fm/forum/index.php?topic=7464.msg63813#msg63813 |
| Pileot | Re: HOW TO: A guide to installing ML on the 7D for noobs by a noob. Newbies welcome! | https://www.magiclantern.fm/forum/index.php?topic=7464.msg63892#msg63892 |
| dariSSight | Re: 3K+ RAW video on Canon 5d Mark II | https://www.magiclantern.fm/forum/index.php?topic=8554.msg79447#msg79447 |
| a1ex | Re: Dropbox changing public folder to private | https://www.magiclantern.fm/forum/index.php?topic=19164.msg181563#msg181563 |
| Audionut | Re: h264.ini - how it really works? | https://www.magiclantern.fm/forum/index.php?topic=8949.msg109844#msg109844 |
+-----------------+--------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+
94 rows in set (0.81 sec)