Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by MX ( 16 years ago )
SELECT DISTINCT bands.Band FROM band_album JOIN bands JOIN alben ON band_album.Band = bands.ID AND band_album.Album = alben.ID WHERE alben.Genre = ".$genre." AND bands.Band LIKE '0%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '1%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '2%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '3%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '4%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '5%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '6%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '7%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '8%' AND alben.Status = 1 OR alben.Genre = ".$genre." AND bands.Band LIKE '9%' AND alben.Status = 1 ORDER BY bands.Band ASC"
Revise this Paste
Parent: 18047