Skip to content

Instantly share code, notes, and snippets.

View oleander's full-sized avatar
🇸🇪

Linus Oleander oleander

🇸🇪
80 followers · 7 following
View GitHub Profile
@oleander
oleander / gist:389835
Created May 4, 2010 19:13
[[0,0],[0,1],[1,0],[1,1],[1,2],[2,1],[2,2],[3,2]]
@oleander
oleander / gist:389853
Created May 4, 2010 19:29
[[0,0,0],[0,0,1],[0,0,2],[0,0,3],[0,0,4],[0,0,5],[0,1,0],[0,1,1],[0,1,2],[0,1,3],[0,1,4],[0,1,5],[0,2,0],[0,2,1],[0,2,2],[0,2,3],[0,2,4],[0,2,5],[0,3,0],[0,3,1],[0,3,2],[0,3,3],[0,3,4],[0,3,5],[0,4,0],[0,4,1],[0,4,2],[0,4,3],[0,4,4],[0,4,5],[0,5,0],[0,5,1],[0,5,2],[0,5,3],[0,5,4],[0,5,5],[1,0,0],[1,0,1],[1,0,2],[1,0,3],[1,0,4],[1,0,5],[1,1,0],[1,1,1],[1,1,2],[1,1,3],[1,1,4],[1,1,5],[1,2,0],[1,2,1],[1,2,2],[1,2,3],[1,2,4],[1,2,5],[1,3,0],[1,3,1],[1,3,2],[1,3,3],[1,3,4],[1,3,5],[1,4,0],[1,4,1],[1,4,2],[1,4,3],[1,4,4],[1,4,5],[1,5,0],[1,5,1],[1,5,2],[1,5,3],[1,5,4],[1,5,5],[2,0,0],[2,0,1],[2,0,2],[2,0,3],[2,0,4],[2,0,5],[2,1,0],[2,1,1],[2,1,2],[2,1,3],[2,1,4],[2,1,5],[2,2,0],[2,2,1],[2,2,2],[2,2,3],[2,2,4],[2,2,5],[2,3,0],[2,3,1],[2,3,2],[2,3,3],[2,3,4],[2,3,5],[2,4,0],[2,4,1],[2,4,2],[2,4,3],[2,4,4],[2,4,5],[2,5,0],[2,5,1],[2,5,2],[2,5,3],[2,5,4],[2,5,5],[3,0,0],[3,0,1],[3,0,2],[3,0,3],[3,0,4],[3,0,5],[3,1,0],[3,1,1],[3,1,2],[3,1,3],[3,1,4],[3,1,5],[3,2,0],[3,2,1],[3,2,2],[3,2,3],[3,2,4],[3,2,5],[3,3,0],[3,3,1]
@oleander
oleander / gist:389855
Created May 4, 2010 19:31
[[a, b, c] | a <- [0..5] , b <- [0..5], c <- [0..5]]
@oleander
oleander / gist:391279
Created May 5, 2010 19:11
SELECT *
FROM `channels`
LEFT OUTER JOIN `gigs` ON `gigs`.`channel_id` = `channels`.`id`
LEFT OUTER JOIN `songs` ON `songs`.`id` = `gigs`.`song_id`
GROUP BY channels.id ORDER BY channels.id
@oleander
oleander / gist:391307
Created May 5, 2010 19:29
SELECT *
FROM `gigs`
LEFT OUTER JOIN `songs` ON `songs`.`id` = `gigs`.`song_id`
ORDER BY gigs.channel_id
@oleander
oleander / gist:391343
Created May 5, 2010 19:57
SELECT *
FROM
`gigs`
JOIN(
SELECT *,COUNT(gigs.channel_id) as theCount
FROM `gigs`
LEFT OUTER JOIN `songs` ON `songs`.`id` = `gigs`.`song_id`
ORDER BY gigs.channel_id
HAVING theCount < 5)
AS dt USING (gigs.channel_id);
@oleander
oleander / gist:391346
Created May 5, 2010 20:00
SELECT *
FROM
`gigs`
JOIN(
SELECT *,COUNT(gigs.channel_id) as theCount
FROM `gigs`
LEFT OUTER JOIN `songs` ON `songs`.`id` = `gigs`.`song_id`
HAVING theCount < 5
ORDER BY gigs.channel_id )
AS dt USING (channel_id);
@oleander
oleander / gist:391350
Created May 5, 2010 20:04
SELECT gigs.id, gigs.channel_id
FROM
`gigs`
JOIN(
SELECT gigs.id,COUNT(gigs.channel_id) as theCount
FROM `gigs`
LEFT OUTER JOIN `songs` ON `songs`.`id` = `gigs`.`song_id`
HAVING theCount < 5
ORDER BY gigs.channel_id )
AS dt USING (gigs.channel_id);
@oleander
oleander / gist:391367
Created May 5, 2010 20:23
SELECT gigs.*
FROM `gigs`
LEFT OUTER JOIN `songs` ON `songs`.`id` = `gigs`.`song_id`
@oleander
oleander / gist:391444
Created May 5, 2010 21:15
select artists.* from artists left join (select * from songs limit 10) as s on s.artist_id = artists.id;