how lame that you have to try to hunt down edits :P
brianfreud
well, I knew there had to be a VA merge... trying to pull up VA’s edits is both suicidal and error 500, so it took some digging via advanced search to find it
hi folks. is there any machine interface (or otherwise html) for searching on URLs in an advanced relationship field? eg. find the html or xml page for the band who has a MySpace AR = http://www.myspace.com/jarvspace
I don't see such on the search pages...
kruq
why encourage them
i know nothing sorry shouldn't have said anything :)
dalen joined the channel
danbri
for myspace users, it's potentially a nice shorthand for identifying their favourite bands
Kerensky97 has left the channel
MrQwerty has quit
foolip joined the channel
brianfreud
danbri, not that I’m aware of
foolip
greetings all
danbri
thanks
danbri rummaging in the sql instead then
Igor_666736 has quit
foolip
is there a formal time limit for a RFV on MB-Style?
brianfreud
wouldn’t simply searching on the artist’s name be simpler?
foolip, not really, but it tends to be ~14 days, I think
foolip
ok
so I'll just keep waiting
danbri
not if i'm starting with a fan's myspace url, which can get me band's myspace urls ... potentially a nice tight join on IDs
rather than a murky string match
brianfreud
yes, but the myspace url we would have, if we have it, would be the band’s, not the fan’s
danbri
yep - i should've spelled it out ... would also using be Perl WWW::Myspace module or similar (or a web service if they ever get with the 21st century :)
brianfreud
:P
still sounds much easier to search on the artist’s name :D
ok all, I am finding a SERIOUS soundtrack deficiency. ADD MORE SOUNDTRACKS (and save me from having to keep adding more!) LOL
danbri
ok an SQL question now --- mb1=# select * from l_artist_url where link_type ='19' AND link0='170817';
i can't see where link1 gets expanded back into myspace URLs
ah doh, url table
thanks for listening ;)
fyi, finished product is select url from l_artist_url,url, artist where artist.id = link0 AND url.id=link1 AND link_type ='19' AND name like 'Jarvis Cocker';