This query is marked as a draft This query has been published by Superzerocool.

SQL

AخA
 
use eswiki_p;
select user_name, user_id, user_registration
   , (case when user_registration between '20150200000000' and '20150331000000' then 'nuevo' else 'viejo' end) as tipo
from user 
where user_id in (3565464,
23251,
3559840,
3557159,
1883529,
3573995,
3560642,
3142131,
759607,
189911,
1122788,
2583432,
3573999,
3565589,
3574010,
3572978,
39094,
1114081,
579111,
2787129,
3565595,
3571883,
3568787,
3572553,
3564630,
15707,
3573984,
3574003,
3572209,
3573994,
3565435)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Query status: complete

Executed on Sat, 24 Sep 2016 21:35:44 UTC.