SELECT SQL_CALC_FOUND_ROWS id from shows where(valid=1 or valid=13) and poster_approval=1 and (is_featured>=1) and ( 1=1 ) and (shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) or global_ad='Y') and type!='banner_ad' and ideal_view_percentage>=0.625598925748 order by (rand() * ad_throttle) limit 100

select type from shows where id=256420

select type from shows where id=257740

select type from shows where id=256565

select type from shows where id=199542

select * from music where 1=0

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid1) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid2) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid3) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid4) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid5) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid6) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid7) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name

select SQL_CALC_FOUND_ROWS bands.display_name as artist_name, music.*, shows.timestamp, shows.venid, shows.venname,shows.id as showid from music,bands,shows where bands.id=music.artistid and (music.artistid=shows.bid8) and music.include_in_audio_section='Y' and music.include_in_profile='Y' and music.valid=1 and shows.valid=1 and 1=1 and shows.loc_id in(120,1,77,126,140,161,328,365,434,1213,3006,11439,517) group by music.id order by shows.timestamp, display_name