New DB
SELECT top 40 * from ps_top_of_the_props WHERE [month]=DatePart(month, dateadd(month,-1, getdate())) AND [year]=DatePart(year, dateadd(year, 0, getdate())) order by rank
|
Overall Enquiry Volume for April 2013 |
||||
| Rank |
Country |
Share |
Change |
Comment |
1 |
18.97 |
Non-mover |
1 month in top spot |
|
2 |
10.16 |
Non-mover |
||
3 |
6.78 |
Up 14 |
New to top 10! |
|
4 |
6.6 |
Up 15 |
Highest climber And New to top 10! |
|
5 |
5.69 |
Down 2 |
||
6 |
4.98 |
Down 2 |
||
7 |
4.83 |
Down 2 |
||
8 |
4.47 |
Down 2 |
||
9 |
3.18 |
Up 1 |
||
10 |
2.61 |
Down 1 |
||
11 |
2.19 |
Up 4 |
||
12 |
2.13 |
Down 4 |
||
13 |
1.85 |
Non-mover |
||
14 |
1.81 |
Down 7 |
||
15 |
1.4 |
Up 12 |
||
16 |
1.4 |
Highest New Entry |
||
17 |
1.38 |
Up 1 |
||
18 |
1.29 |
Down 2 |
||
19 |
1.23 |
Down 8 |
||
20 |
1.16 |
Up 6 |
||
21 |
0.92 |
Down 9 |
||
22 |
0.88 |
Down 2 |
||
23 |
0.8 |
Up 2 |
||
24 |
0.76 |
Down 3 |
||
25 |
0.71 |
Down 11 |
||
26 |
0.44 |
Down 4 |
||
27 |
0.4 |
New Entry |
||
28 |
0.33 |
Non-mover |
||
29 |
0.33 |
Down 5 |
||
30 |
0.31 |
New Entry |
||
31 |
0.28 |
Non-mover |
||
32 |
0.23 |
Up 13 |
||
33 |
0.2 |
Up 4 |
||
34 |
0.2 |
Up 1 |
||
35 |
0.19 |
Down 12 |
Biggest faller |
|
36 |
0.17 |
Down 7 |
||
37 |
0.15 |
Up 11 |
||
38 |
0.12 |
Down 8 |
||
39 |
0.11 |
Non-mover |
||
40 |
0.08 |
Down 8 |
||