Lista de Usuários Destaques do Fórum Ubuntu Linux

Lista de usuários que estão concorrendo aos prêmios da categoria Destaques.

SELECT @rownum:=@rownum+1 rank, s.`ID_MEMBER`, s.`posts`, s.`lastLogin`, s.`memberName` FROM (SELECT * FROM smf_members m WHERE m.`ID_MEMBER` NOT IN (94,95, 1325,4653,3149,12,9,11126,6381,524)) AS s, (SELECT @rownum:=0) r WHERE s.`posts` >= 100 AND s.`lastLogin` > 1256101200 ORDER BY s.`ID_MEMBER`

rank	ID_MEMBER	posts	lastLogin	memberName
1	49	416	1259959541	KubLin
2	58	127	1259711666	ricardorrm
3	168	1073	1259974076	Darcamo
4	226	675	1259933589	Joseph
5	273	523	1258481357	biohazard
6	436	175	1256823764	casainho
7	465	355	1257852721	Marcus VBP
8	509	410	1258118562	carlosfrancoba
9	545	153	1258163250	ArKanjo
10	574	538	1259277602	gony64
11	618	112	1259715366	csilva
12	628	817	1259748442	RC2006
13	715	437	1259882484	lfernandosg
14	736	312	1259198240	usifoto
15	807	121	1259933633	Luiz Antonio
16	953	124	1259977743	LNAS90
17	954	115	1257451046	migraineboy
18	1039	126	1257766091	wagnerluis1982
19	1115	214	1259938839	Intruder_A6
20	1263	497	1259940884	dudu_ubuntun
21	1480	435	1259801816	JeffersonX
22	1714	238	1257279202	crixtiano
23	1833	362	1259962856	danpos
24	1933	110	1258286574	santos
25	2178	118	1259973141	Franco Almeida
26	2234	111	1257109793	marciovinicius
27	2335	115	1258058294	Daniel Neves
28	2417	626	1258891848	arsolto
29	2511	3263	1258058640	alarcon
30	2518	641	1259703218	Madrigal
31	3197	151	1259639456	Éderson
32	3278	167	1259965489	yzarc
33	3327	158	1259790110	Mitzgitari
34	3338	468	1257545785	vitor
35	3612	898	1259959037	Kamei Hyoga
36	3633	118	1259505306	jcao
37	3786	307	1256703771	KurtKraut
38	3795	477	1259599742	maudy
39	3815	110	1259170655	MaRxMR
40	3829	770	1259976195	k7br
41	3903	428	1259957074	Polaco
42	3904	157	1258293878	gilbertosilva
43	4181	140	1259962984	plynott
44	4222	332	1259971299	Coiote
45	4307	659	1259945642	Nossile
46	4645	197	1258732300	e.daniel-ct
47	4716	545	1259974007	lueneberg
48	4951	294	1259933106	aniquilator
49	5273	344	1259849830	coyoterj
50	5478	113	1259947482	antoniodosantosor
51	5736	144	1258606187	naldin
52	5983	135	1259769042	martinho_junior
53	6038	1052	1259972179	velox256
54	6171	489	1259976977	glaubergoncalves
55	6216	176	1259946866	Leonardo C
56	6288	173	1257628410	advogama
57	6388	192	1259777871	teles
58	6479	1716	1259959199	pintinho
59	6856	160	1259926161	wildner
60	6880	248	1256764574	celsofaf
61	6981	111	1259969936	flsantos
62	7022	115	1259955691	pedrotf
63	7105	394	1259972509	Glauco Hass
64	7252	180	1259970023	ctavares
65	7406	176	1259971886	jrkamil
66	7508	2461	1259949350	pinduvoz
67	7550	349	1256831728	RxDx
68	7799	779	1259979369	Versuri
69	7898	792	1258251802	alexmatos
70	8076	226	1259795288	felipeett
71	8111	1521	1259536963	rjbgbo
72	8149	249	1259947167	lr.gamito
73	8154	439	1258199247	fabiovalinhos
74	8195	202	1257897694	Evandro Abu Kamel
75	8259	385	1259059945	Akuhn
76	8330	209	1257959156	nuno_nunes
77	8460	168	1259710070	fchevitarese
78	8622	103	1258140741	Josely
79	8746	133	1259798382	adilson bts
80	8851	432	1258511130	paozinho
81	9130	192	1259278824	CGaldino
82	9210	175	1259015508	RodrigoFSS
83	9480	445	1259973909	Cláudio Novais
84	9573	311	1257185774	DouglasCaixeta
85	9689	133	1258681594	twelvetribes
86	9743	110	1258862869	minho
87	9788	129	1259101557	rayabusa
88	10526	131	1258325158	ataias
89	10594	160	1259950672	alexandrerio
90	11216	259	1259838655	sottam
91	11328	131	1258428545	Chucknoris
92	11539	107	1259359282	MadOrL
93	12147	366	1259894699	mstr
94	12157	280	1259972230	ucastrobr
95	12318	114	1259696024	marcos_vargens
96	12614	363	1259978602	asghan
97	12634	854	1259967581	vinicius_aleao
98	12702	173	1259897216	Legendario
99	12868	388	1259803459	Nelson Quintanilha
100	12947	108	1259539297	Arthur Cruz
101	13102	327	1259963567	Manoboy
102	13171	693	1259962898	Ioca100
103	13233	529	1259604152	PRSC
104	13240	547	1256653920	sylvester
105	13335	188	1258714101	vampire_thunder
106	13342	129	1259030053	akaihen
107	13395	164	1258717910	jpzm56
108	13539	625	1257707934	Marcopolo
109	13724	525	1259958760	carlosaluisio
110	13795	147	1258962354	dom diniz
111	14080	133	1259798475	Ricardo Ferreira
112	14154	109	1257560949	Thorn Striff
113	14645	210	1257122444	alexcunha
114	14717	144	1259960730	rruella
115	14783	167	1259970576	rodrigo.miguel
116	14964	117	1256675814	cholletao
117	15434	184	1259603369	diego_maciel
118	15536	230	1259788358	Skid Vicious
119	15644	161	1259947288	sboorbou
120	15684	338	1259701448	lunga
121	15815	190	1259972400	marcosalvesps
122	15929	306	1259974232	Junior_Sampa
123	15933	125	1257015051	Master_
124	15970	208	1259959392	achteutis
125	16382	101	1258851879	snell
126	16444	117	1259721164	carioca
127	16533	148	1259951094	SergioJP
128	16634	165	1259937667	marcospinho
129	16878	311	1258668996	gean gustavo
130	17723	116	1256222662	Warlike Wolf
131	18026	494	1259582868	Hqxriven
132	18798	208	1259977143	ErickSantos
133	18861	191	1256485700	Oni-BR-
134	19171	248	1259884238	elio7769
135	19533	301	1259900596	bred81
136	19602	133	1258308636	daquinho
137	20187	403	1259979363	0tacon
138	21184	490	1259963317	raidicar
139	21704	123	1259717617	HelderC
140	21881	111	1259949774	navegantesdailusao
141	23706	253	1259971270	JFMMão de Ferro
142	23833	119	1259976987	clebson
143	23886	117	1259297124	joao_z
144	23944	223	1259978939	niquelnausea
145	24408	209	1259888476	Luciano Gardim
146	26511	106	1259869117	lightboy
147	26858	198	1259747342	dtomadon
148	27287	734	1259935103	Alakazan
149	28153	146	1259540884	livre1
150	28796	187	1257874113	cadubts
151	29167	203	1259788344	Becker
152	29474	235	1259970335	pigdin
153	29640	140	1259883961	Adriano R.N.
154	29763	103	1259919114	nicolas braz
155	30060	271	1259974322	platao
156	31487	130	1259705645	Carlos Ivan
157	32962	171	1259715501	RamonB
158	33241	232	1259540979	Riccardo Petrillo
159	33461	133	1259314478	slkslk
160	33494	108	1259949257	theoldpunk
161	33605	164	1259962698	Mikael
162	33854	297	1259851214	renatokrause
163	36294	255	1259964510	mpmoraes
164	36421	110	1259970929	Jone Metal
165	36985	138	1259914509	GTamtM
166	37043	158	1259956421	GuidjeLeGamba
167	37360	128	1259691635	Raptor Tricolor
168	37974	112	1259925885	yeticannotski
169	39195	173	1259977337	Darth Vader
170	39801	165	1259763847	rcn
171	41918	107	1259883222	musinet
172	44491	135	1259689097	luiscarlos
173	46820	140	1259979176	Alyscom
174	47724	213	1259974812	zekkerj
175	48066	100	1259972249	jeflui