- Code
select
user_id,
username,
SUBSTRING_INDEX(user_profileviews, '/', 1)+0 as views
from users
where user_profileviews != '0/00000000'
order by views desc
limit 40;
+---------+--------------+-------+
| user_id | username | views |
+---------+--------------+-------+
| 3494 | parouscha | 198 |
| 4218 | Mr_X | 183 |
| 1 | BartVB | 181 |
| 3820 | 15happy16 | 172 |
| 711 | Manda | 161 |
| 152 | Thirza | 143 |
| 541 | Mirte | 140 |
| 2385 | XoNo | 137 |
| 20 | Nimber | 126 |
| 240 | Sundancer | 121 |
| 370 | GribaldiFAN | 118 |
| 32 | Nathalie | 112 |
| 18 | Steef | 111 |
| 3413 | Pipo | 109 |
| 29 | Karin | 107 |
| 7 | Sonja | 106 |
| 514 | Clautje | 106 |
| 1494 | Buitenzorg | 98 |
| 1865 | Tinne | 98 |
| 485 | Jurga | 96 |
| 715 | r0b1n | 96 |
| 4 | stef | 95 |
| 102 | lonneke | 90 |
| 213 | Pinky_girl | 87 |
| 476 | Zep | 86 |
| 1100 | macario | 85 |
| 1108 | *Marije* | 84 |
| 19 | orri | 83 |
| 694 | annemieke | 82 |
| 1538 | Naomi | 82 |
| 3204 | SuperPepeijn | 80 |
| 4082 | chantal21 | 77 |
| 3580 | Jordy | 76 |
| 43 | Lovely | 75 |
| 121 | Merilyn | 75 |
| 305 | Honeybee | 74 |
| 125 | Marsje | 73 |
| 52 | runningkawa | 71 |
| 3460 | pebblientje | 70 |
| 97 | Jippie | 69 |
+---------+--------------+-------+