Pořadí (aktuální měsíc)

Pořadí v aktuálním měsíci 

          

                                                                                  aktuální možný stav bodů v 3. etapě k 20.5.2012 :  144

SELECT  SQL_CALC_FOUND_ROWS `user`.`id` as `user_id`, `user`.`zip` as `user_zip`, `user`.`region_id` as `user_region_id`, `user`.`hash` as `user_hash`, `user`.`password` as `user_password`, `user`.`confirmed` as `user_confirmed`, `user`.`updated` as `user_updated`, `user`.`referer_used` as `user_referer_used`, `user`.`stage_1` as `user_stage_1`, `user`.`stage_2` as `user_stage_2`, `user`.`stage_3` as `user_stage_3`, `user`.`email` as `user_email`, `user`.`stage_4` as `user_stage_4`, `user`.`stage_5` as `user_stage_5`, `user`.`stage_6` as `user_stage_6`, `user`.`stage_1_pos` as `user_stage_1_pos`, `user`.`stage_2_pos` as `user_stage_2_pos`, `user`.`stage_3_pos` as `user_stage_3_pos`, `user`.`stage_4_pos` as `user_stage_4_pos`, `user`.`stage_5_pos` as `user_stage_5_pos`, `user`.`stage_6_pos` as `user_stage_6_pos`, `user`.`vip` as `user_vip`, `user`.`username` as `user_username`, `user`.`created` as `user_created`, `user`.`referer` as `user_referer`, `user`.`name` as `user_name`, `user`.`surname` as `user_surname`, `user`.`phone` as `user_phone`, `user`.`street` as `user_street`, `user`.`city` as `user_city`
 
 , `user_points`.`id` as `user_points_id`, `user_points`.`user_id` as `user_points_user_id`, `user_points`.`bonus_id` as `user_points_bonus_id`, `user_points`.`voucher_id` as `user_points_voucher_id`, `user_points`.`item_id` as `user_points_item_id`, `user_points`.`points` as `user_points_points`, `user_points`.`cycle` as `user_points_cycle`, `user_points`.`created` as `user_points_created`
 , SUM(`user_points`.`points`) as `bodu`
 FROM ta_user AS `user`
  LEFT JOIN `ta_user_points` AS `user_points` ON 1 AND (`user_points`.`created` <= (CONCAT(LAST_DAY(NOW()), ' ', '23:59:59')) AND `user_points`.`created` >= (DATE_FORMAT( NOW(), '%Y-%m-01 00:00:00' )) AND `user`.`id` = `user_points`.`user_id`)
 
 GROUP BY `user`.`id`
 
 ORDER BY (bodu) DESC  LIMIT 0,100
pořadí uživatel body VIP
1 jojco 144
2 sompotvorka 140
3 lesi20 138
4 mischo2002 132
5 kvetka 126
6 Jameska 120
7 citron 120 VIP
8 danus 120
9 senza 120
10 renca 120
11 spageta 120
12 vipka 120
13 mangos 120 VIP
14 toto 120
15 alice 120 VIP
16 gumik 120
17 mila 120
18 vorech 120
19 topik 120
20 bzum 120
21 martini 120 VIP
22 solaris 120
23 bezdak 120
24 kamila 120 VIP
25 jirik 120
26 shark 120
27 panda 120
28 cecilka 120
29 xnadruhou 120
30 bodlinka 120 VIP
31 ajinka 120 VIP
32 sirena 120 VIP
33 argefa 120
34 jeje 120
35 cudla 120
36 zenac 120 VIP
37 ajax2 120
38 chlad 120
39 Kubajs 120
40 DANDII 120
41 chlup 120
42 Janek 120
43 Cenkov 120
44 jone 120
45 didi2 120
46 Ajax-6 120
47 Emil-3 120
48 Herakles 120
49 BOHNICE 120
50 hrabos64 120
51 Kroko 120
52 deda2 120
53 cassttello 120
54 fiser 120
55 dodo8 120
56 Bask 120
57 doktorka 120
58 gorecki 120
59 FidoA 120
60 Kolaj 120
61 CERT13 120
62 Ferka 120
63 Dava 72 120
64 Czechtip 120
65 Honza-18 120
66 bagristka 120
67 ANDY13 120
68 Davca 120
69 laksii 120
70 ACHYL 120
71 Janicka 120
72 CID 120
73 Josef.S 120
74 fandynho 120
75 Mates5 120
76 kaprivec 120
77 hame 120
78 Edson 120
79 jirzi 120
80 KAWI 120
81 Dudus 120
82 franta-13 120
83 Lukyno 120
84 kaba 120
85 Hlaska 120
86 bond 120
87 Mates6 120
88 hudal 120
89 jirda 120
90 charlie-1 120
91 bronik 120
92 Favorit-2 120
93 josef4 120
94 Falcao 120
95 JOHAN89 120
96 J.R. 120
97 havlos 120
98 DAFF11 120
99 janevim 120
100 FRIML 120
Zobrazeny záznamy od 1 - 100 z 118305
12  3  4  5  6  7  8  9  10  11   … >

Novinky

2. etapa Top ligy 2012

03.5.2012
vrtule

2. etapa TOP ligy 2012 byla ukončena.

Vítězem se stává uživatel " deda2 " a získává jako dárek hru "kostky a žulíky".

Na druhém místě se umístn…

1. etapa TOP ligy 2012

02.3.2012
vrtule

1. etapa nového ročníku TOP ligy 2012 byla ukončena.

Vítězkou se stala uživatelka " perfekta " a jako VIP uživatelka získává bonusovou

poukázku v hodnotě…

Další novinky »

Zpravodaj

Pro přihlášení či odhlášení zpravodaje zadejte email