it's generally cheaper to other anything from germany/uk than buy something here
2009-09-29 27206, 2009
luks
*order
2009-09-29 27252, 2009
outsidecontext has quit
2009-09-29 27254, 2009
nikki
it used to be like that here for stuff that wasn't released here... I wouldn't know now though
2009-09-29 27214, 2009
nikki
like I would go into shops and find albums for £20 to £25 just because they were imports
2009-09-29 27220, 2009
warp
it really depends on how well the dollar and pound are doing for me.
2009-09-29 27219, 2009
warp
nikki: that's scarily expensive.
2009-09-29 27223, 2009
outsidecontext1 has quit
2009-09-29 27212, 2009
_Tsk_ joined the channel
2009-09-29 27234, 2009
_Tsk_ has quit
2009-09-29 27216, 2009
ruaok joined the channel
2009-09-29 27254, 2009
_Tsk_ joined the channel
2009-09-29 27241, 2009
_Tsk_ has quit
2009-09-29 27216, 2009
gnu_andrew has quit
2009-09-29 27244, 2009
nikki
warp: indeed
2009-09-29 27205, 2009
_Tsk_ joined the channel
2009-09-29 27214, 2009
gnu_andrew joined the channel
2009-09-29 27219, 2009
_Tsk_ has quit
2009-09-29 27203, 2009
_Tsk_ joined the channel
2009-09-29 27213, 2009
chefkoch joined the channel
2009-09-29 27224, 2009
aCiD2 joined the channel
2009-09-29 27209, 2009
omgyja has left the channel
2009-09-29 27223, 2009
outsidecontext joined the channel
2009-09-29 27252, 2009
_Tsk_ has quit
2009-09-29 27250, 2009
chefkoch_ joined the channel
2009-09-29 27200, 2009
chefkoch has quit
2009-09-29 27202, 2009
chefkoch_
chefkoch_ is now known as chefkoch
2009-09-29 27214, 2009
_Tsk_ joined the channel
2009-09-29 27222, 2009
intrados4 has quit
2009-09-29 27256, 2009
_Tsk_ has quit
2009-09-29 27239, 2009
xlotlu joined the channel
2009-09-29 27209, 2009
ijabz joined the channel
2009-09-29 27222, 2009
_Tsk_ joined the channel
2009-09-29 27201, 2009
mr_maxis has quit
2009-09-29 27215, 2009
_Tsk_ has quit
2009-09-29 27231, 2009
_Tsk_ joined the channel
2009-09-29 27209, 2009
bts- joined the channel
2009-09-29 27207, 2009
bts-
hi everyone. i should be able to get releases from a release_group using mbdump, right? i'm using mb_mysql and i can go from artists to release_groups just fine, but i can't seem to locate any of the information i need to join release_groups with releases
2009-09-29 27211, 2009
_Tsk_ has quit
2009-09-29 27231, 2009
luks
the database mixes different terminologies
2009-09-29 27250, 2009
luks
I'm assuming you are looking at the release table, but you want album instead
2009-09-29 27240, 2009
luks
(and of course you can go from a release group to releases via albums)
2009-09-29 27250, 2009
bts-
(thanks for the help..) well right now I am starting with release_group, mostly because I want to work with a canonical album rather than 10 dupe releases for an album
2009-09-29 27248, 2009
bts-
and from there, i was planning to get the most authorative release for the given release group, so i could ultimately get a track list for a release group (i know this is inherently a little lossy)
2009-09-29 27255, 2009
bts-
and i was having trouble getting an album (sorry: i mistakenly said 'release' above) for a release_group
2009-09-29 27234, 2009
bts-
or rather, getting the list of albums for a release_group
2009-09-29 27248, 2009
luks
select * from album where release_group = ?
2009-09-29 27231, 2009
chefkoch_ joined the channel
2009-09-29 27235, 2009
bts-
hm, my album doesn't have release_group
2009-09-29 27241, 2009
chefkoch has quit
2009-09-29 27243, 2009
chefkoch_
chefkoch_ is now known as chefkoch
2009-09-29 27247, 2009
_Tsk_ joined the channel
2009-09-29 27204, 2009
_Tsk_ has quit
2009-09-29 27220, 2009
BurgessShale joined the channel
2009-09-29 27244, 2009
luks
it does in the original database
2009-09-29 27249, 2009
luks
maybe there is a bug in mb_mysql
2009-09-29 27258, 2009
bts-
i think mb_mysql is OK for the artist table though, because i see it has the same number of columns as mbdump for artist
2009-09-29 27212, 2009
bts-
both have 12
2009-09-29 27255, 2009
bts-
oops, sorry. meant to look at 'album'. did 'artist' by mistake
2009-09-29 27203, 2009
bts-
let me back to you in a sec
2009-09-29 27208, 2009
luks
I don't see the release_group in mb_mysql at all
2009-09-29 27213, 2009
luks
where did you get it from?
2009-09-29 27213, 2009
bts-
i had to write my own "create table" for that one. i contacted chancey about it, but haven't yet received a response
