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

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