if(geek) tweet( #songsincode );

jum4 · 21-08-2009 2:42pm #1

what's the best 1 you've seen so far?

or post your own

$who = mysql_query ( 'SELECT name FROM people WHERE letDogsOut=true' );

Gone Drinking · 21-08-2009 2:43pm

Get out of the normal people forums, now.

Cookie_Monster · 21-08-2009 2:43pm

Songs in SQL, why would anyone ever do that?

Hail 2 Da Chimp · 21-08-2009 2:44pm

Nerrrrrd!

abouttobebanned · 21-08-2009 2:46pm

In this village of Nerds, this nerd is King.

Bill-e · 21-08-2009 2:46pm

Oh dear god that's bad!

Boxfresh · 21-08-2009 2:48pm

The best one I saw was

$YOU = mysql_query ( 'JUM4 FROM people Is a GEEK=true' );

Long Onion · 21-08-2009 2:49pm

$who = mysql_query ( 'SELECT name FROM people WHERE wereyoudroppedasachild?=true' );

LadyMayBelle · 21-08-2009 2:51pm

wtf?

jum4 · 21-08-2009 2:52pm

video@radio ~ $ kill -9 star

mikom · 21-08-2009 2:52pm

Forget the code....... just go NES style.

https://www.youtube.com/watch?v=I_iLIH_nyo0

Boxfresh · 21-08-2009 2:52pm

Fail!

petes · 21-08-2009 3:05pm

Thank fcuk I don't know anyhing that is going on in this thread. It's Friday afternoon ffs. I don't need to be thinking!!

Wazdakka · 21-08-2009 3:10pm

[PHP] I >> You[/PHP]

Am I doing it right?

Overheal · 21-08-2009 3:12pm

jum4 wrote: »

what's the best 1 you've seen so far?

or post your own

$who = mysql_query ( 'SELECT name FROM people WHERE letDogsOut=true' );

return fail; //**** syntax

Carsinian Thau · 21-08-2009 3:12pm

I thought I knew what was going on here.

But then I realised that I didn't...

JennyMaguire · 21-08-2009 3:13pm

Hail 2 Da Chimp wrote: »

Nerrrrrd!

Hey, did you see that nerd?

Cookie_Monster · 21-08-2009 3:14pm

You have to rap it to make sense

select
yrwk1,
store1,
dept1,
desc1,
sub1,
tpnb,
desc4,
sum(zeroifnull(cnt)) AS "Picks",
sum(zeroifnull(cnt2)) AS "Failed Picks"
FROM
(SELECT
year_week_number,
retail_outlet_number,
RSD.RS_22_department_code,
RS_22_DEPARTMENT_DESCRIPTION,
psg.product_sub_group_code,
bpr.base_product_number,
bpr.long_description,
count(bbb.base_product_number)
FROM VWI0pav_ghs_product_available bbb
INNER JOIN VWI0BPr_BASE_PRODuct bpr
on (bbb.base_product_number=bpr.base_product_number)
INNER JOIN VWI0psg_prodUCT_sub_group psg
on (bpr.product_sub_group_code = psg.product_sub_group_code)
INNER JOIN VWI0RSD_RS22_DEPARTMENT rsd
on (psg.rs_22_department_code = rsd.rs_22_department_Code)
INNER JOIN VWI0cal_small_calendar cal
on (cal.calendar_date = bbb.checkout_date)
WHERE checkout_date in
(SELECT calendar_date from VWI0cal_small_calendar
WHERE year_week_number between 200746 and 200803)
and RSD.RS_22_department_code in ('f')
and retail_outlet_number in ('3677')
GROUP BY 1,2,3,4,5,6,7 )
sh1 (yrwk1,store1,dept1,desc1,sub1,tpnb,desc4,cnt)
LEFT OUTER JOIN
(SELECT
year_week_number,
retail_outlet_number,
RSD.RS_22_department_code,
bpr.base_product_number,
count(bbb.base_product_number)
FROM VWI0pav_ghs_product_available bbb
INNER JOIN VWI0BPR_BASE_PRODUCT bpr
on (bbb.base_product_number=bpr.base_product_number)
INNER JOIN VWI0psg_prodUCT_sub_group psg
on (bpr.product_sub_group_code = psg.product_sub_group_code)
INNER JOIN VWI0RSD_RS22_DEPARTMENT rsd
on (psg.rs_22_department_code = rsd.rs_22_department_Code)
INNER JOIN VWI0cal_small_calendar cal
on (cal.calendar_date = bbb.checkout_date)
WHERE checkout_date in
(SELECT calendar_date FROM VWI0cal_small_calendar
WHERE year_week_number between 200746 and 200803)
AND picker_comment_code = 'O'
and RSD.RS_22_department_code in ('f')
and retail_outlet_number in ('3677')
GROUP BY 1,2,3,4)
sh2 (yrwk2,store2,dept2,tpnb2,cnt2)
on
(sh2.dept2 = sh1.dept1)
AND (sh2.tpnb2 = sh1.tpnb)
AND (sh1.yrwk1=sh2.yrwk2)
and (sh1.store1=sh2.store2)
GROUP BY 1,2,3,4,5,6,7