http://www.naturalnews.com/034289_Afgha ... trade.html
Lawdy.
A free-for-all thread
- Prometherion91
- Denim Demon
- Posts: 7754
- Joined: Sun May 25, 2008 7:45 pm
- Location: Leeds
Re: A free-for-all thread
Womble wrote:Petri isn't fat. He's just ribbed for her pleasure.
- corrupt_toolbox
- Denim Demon
- Posts: 3572
- Joined: Wed Apr 28, 2010 8:08 pm
- Location: Bangor
- Contact:
Re: A free-for-all thread
Prometherion91 wrote:http://www.naturalnews.com/034289_Afghanistan_opium_trade.html
Lawdy.
Sources are Alex Jones and a random YouTube video?
- fitz
- Knight of the Eemerald Svord
- Posts: 649
- Joined: Fri Aug 05, 2011 1:38 pm
- Location: Abertawe
- Contact:
Re: A free-for-all thread
Hey I've started playing bass guitar again, I was wondering if there was a 'playing/tab thread' on the forum where musicians can discuss songs, techniques and stuff. I did a quick search but don't think I saw anything. I'm sure a lot of people on here play an instrument of some sort, was just wondering if anyone could point me to any good forums or good tab sites (preferably with a fair amount of metal tabs) to discuss and learn songs?
They say the pen is mightier than the sword... well, I say fuck the pen! Cause you're gonna die by the sword!
Re: A free-for-all thread
fitz wrote:Hey I've started playing bass guitar again, I was wondering if there was a 'playing/tab thread' on the forum where musicians can discuss songs, techniques and stuff. I did a quick search but don't think I saw anything. I'm sure a lot of people on here play an instrument of some sort, was just wondering if anyone could point me to any good forums or good tab sites (preferably with a fair amount of metal tabs) to discuss and learn songs?
http://www.ultimate-guitar.com/
Freyja wrote:I never used to be able to fit a whole one in my mouth. But now I can with ease.
TheLotusEater193 wrote:WHY IS IT SO TINY?!
TheLotusEater193 wrote:To be fair 1 and a half minutes is really good if you've never done it before.
http://www.facebook.com/Danroush1
- Jim
- Denim Demon
- Posts: 11912
- Joined: Sun Dec 03, 2006 11:43 pm
- Location: Alfreton, Derbyshire
- Contact:
Re: A free-for-all thread
corrupt_toolbox wrote:FAO Jim or anyone else who knows:
I'm struggling to put together some SQL statements I need since I haven't done it in a while. Specifically, in a university database, I'm asked to write a statement that returns a list of the modules (Module Id and Module Name) taught by a specified member of staff, say for this example Bob with the ID of '1'.
The relevant tables are:
Staff (staffId, staffName)
Module (moduleId, moduleName)
Teaches (staffId, moduleId)
There are three other questions too, but if I can understand this one I can probably do the others.
Cheers for any help.
Code: Select all
SELECT moduleId, ModuleName
FORM module m
INNER JOIN Teaches t on m.moduleID = t.moduleID
INNER JOIN Staff s on t.staffId = s.staffID
WHERE staffName = ?
This is T-SQL syntax and use of JOINs (and the parameter ?) but if you swap out the parameter it might just work in MySQL too.
Who the hell reads anything in sigs these days, unless it's an animated gif?
Re: A free-for-all thread
http://www.bbc.co.uk/news/uk-england-bi ... m-16002765
One for lovers of those demon-worshipping balls of fur that lick their own arses and call it grooming, then eat with the same filthy mouth.
One for lovers of those demon-worshipping balls of fur that lick their own arses and call it grooming, then eat with the same filthy mouth.
Re: A free-for-all thread
Seriously can't wait to go home for Christmas.
Turbo wrote:One day I'll get around to tasting Pussy.
- keera_envenomed
- Denim Demon
- Posts: 7620
- Joined: Mon Jun 04, 2007 7:54 pm
- Location: Brizzle
Re: A free-for-all thread
jackcake wrote:http://www.bbc.co.uk/news/uk-england-birmingham-16002765
One for lovers of those demon-worshipping balls of fur that lick their own arses and call it grooming, then eat with the same filthy mouth.
You're only jealous because no one would spend 6 grand on you if you fell out of a 4th storey window
2017 Gigs (here so I remember to go)
17/06 - Guns N' Roses - London
15/07 - Saor - London
10/08 - 13/08 - Bloodstock
17/06 - Guns N' Roses - London
15/07 - Saor - London
10/08 - 13/08 - Bloodstock
Re: A free-for-all thread
siliconfury wrote:corrupt_toolbox wrote:FAO Jim or anyone else who knows:
I'm struggling to put together some SQL statements I need since I haven't done it in a while. Specifically, in a university database, I'm asked to write a statement that returns a list of the modules (Module Id and Module Name) taught by a specified member of staff, say for this example Bob with the ID of '1'.
The relevant tables are:
Staff (staffId, staffName)
Module (moduleId, moduleName)
Teaches (staffId, moduleId)
There are three other questions too, but if I can understand this one I can probably do the others.
Cheers for any help.Code: Select all
SELECT moduleId, ModuleName
FORM module m
INNER JOIN Teaches t on m.moduleID = t.moduleID
INNER JOIN Staff s on t.staffId = s.staffID
WHERE staffName = ?
This is T-SQL syntax and use of JOINs (and the parameter ?) but if you swap out the parameter it might just work in MySQL too.
SELECT Module.moduleId, Module.moduleName
FROM Module, Teaches
WHERE Teaches.staffId = 1
AND Module.moduleId = Teaches.moduleId;
Something like that? If you need to search by staff name, you'll have to do something similar but include all 3 tables in the FROM clause. Haven't tested this; not sure if you always need to qualify the column names with the table name like I have, but you certainly do on the AND clause as it's a common column.
Re: A free-for-all thread
I have a query.
Animal eyes reflect light. (dogs and cats anyway)
How come human eyes don't?
Animal eyes reflect light. (dogs and cats anyway)
How come human eyes don't?
- Jim
- Denim Demon
- Posts: 11912
- Joined: Sun Dec 03, 2006 11:43 pm
- Location: Alfreton, Derbyshire
- Contact:
Re: A free-for-all thread
JECP wrote:siliconfury wrote:corrupt_toolbox wrote:FAO Jim or anyone else who knows:
I'm struggling to put together some SQL statements I need since I haven't done it in a while. Specifically, in a university database, I'm asked to write a statement that returns a list of the modules (Module Id and Module Name) taught by a specified member of staff, say for this example Bob with the ID of '1'.
The relevant tables are:
Staff (staffId, staffName)
Module (moduleId, moduleName)
Teaches (staffId, moduleId)
There are three other questions too, but if I can understand this one I can probably do the others.
Cheers for any help.Code: Select all
SELECT moduleId, ModuleName
FORM module m
INNER JOIN Teaches t on m.moduleID = t.moduleID
INNER JOIN Staff s on t.staffId = s.staffID
WHERE staffName = ?
This is T-SQL syntax and use of JOINs (and the parameter ?) but if you swap out the parameter it might just work in MySQL too.
SELECT Module.moduleId, Module.moduleName
FROM Module, Teaches
WHERE Teaches.staffId = 1
AND Module.moduleId = Teaches.moduleId;
Something like that? If you need to search by staff name, you'll have to do something similar but include all 3 tables in the FROM clause. Haven't tested this; not sure if you always need to qualify the column names with the table name like I have, but you certainly do on the AND clause as it's a common column.
It's faster to use joins. Basically if you put multiple tables in the FROM clause, the database engine will typically do a cartesian product before filtering with WHERE. Use JOINs and it only matches up the rows in the FROM table first to the others, picks out what columns it needs, and finally filters by the WHERE.
Also in T-SQL you will need to fully qualify the table names in SELECT if there is ambiguity across tables.
Last edited by Jim on Fri Dec 02, 2011 7:27 pm, edited 3 times in total.
Who the hell reads anything in sigs these days, unless it's an animated gif?
- Jim
- Denim Demon
- Posts: 11912
- Joined: Sun Dec 03, 2006 11:43 pm
- Location: Alfreton, Derbyshire
- Contact:
Re: A free-for-all thread
Big D wrote:I have a query.
Animal eyes reflect light. (dogs and cats anyway)
How come human eyes don't?
Pupils aren't open wide enough relative to the size of the eyeball.
Who the hell reads anything in sigs these days, unless it's an animated gif?
Re: A free-for-all thread
siliconfury wrote:
It's faster to use joins. Basically if you put multiple tables in the FROM clause, the database engine will typically do a cartesian product before filtering with WHERE. Use JOINs and it only matches up the rows in the FROM table first to the others, picks out what columns it needs, and finally filters by the WHERE.
Not according to this:
http://stackoverflow.com/questions/1216 ... n-vs-where
I always used the WHERE method at university and never lost any marks.
Re: A free-for-all thread
siliconfury wrote:Big D wrote:I have a query.
Animal eyes reflect light. (dogs and cats anyway)
How come human eyes don't?
Pupils aren't open wide enough relative to the size of the eyeball.
would I be right in saying that red-eye in photos is the same effect?
- Jim
- Denim Demon
- Posts: 11912
- Joined: Sun Dec 03, 2006 11:43 pm
- Location: Alfreton, Derbyshire
- Contact:
Re: A free-for-all thread
Hmm, strange, I always thought the SQL Server Query Profiler showed a massive cartesian half way through the query when using WHERE.JECP wrote:siliconfury wrote:
It's faster to use joins. Basically if you put multiple tables in the FROM clause, the database engine will typically do a cartesian product before filtering with WHERE. Use JOINs and it only matches up the rows in the FROM table first to the others, picks out what columns it needs, and finally filters by the WHERE.
Not according to this:
http://stackoverflow.com/questions/1216 ... n-vs-where
I always used the WHERE method at university and never lost any marks.
I've always used JOINs though in my 7 years of using Databases (mostly SQL Server since 2000 version), as they are far more readable and more controllable than joining with WHEREs.
Last edited by Jim on Fri Dec 02, 2011 7:55 pm, edited 3 times in total.
Who the hell reads anything in sigs these days, unless it's an animated gif?