SELECT upload_id, IF( LENGTH(upload_name) > 31, CONCAT( SUBSTRING(upload_name,1,29), '...'), upload_name ) as upload_name_chop, CONCAT( 'https://ccmixter.org/files/', user_name, '/', upload_id ) as file_page_url, IF( LENGTH(user_image) > 0, CONCAT( 'https://ccmixter.org/content/', user_name, '/', user_image ), 'https://ccmixter.org/mixter-files/images/mixter-default.gif' ) as user_avatar_url, user_real_name, user_name, upload_score, upload_num_scores, upload_extra, 1 as thumbs_up, 1 as ratings_enabled, CONCAT( 'https://ccmixter.org/people/', user_name ) as artist_page_url, license_img_small as license_logo_url, license_url, license_name, CONCAT( 'https://ccmixter.org/reviews/', user_name, '/', upload_id ) as reviews_url, IF( upload_tags LIKE '%,audio,%', CONCAT( 'https://ccmixter.org/api/query/stream.m3u?f=m3u&ids=', upload_id ) , '' ) as stream_url, DATE_FORMAT( upload_date, '%a, %b %e, %Y @ %l:%i %p' ) as upload_date_format, upload_contest, upload_name, upload_num_remixes, upload_num_sources, upload_num_pool_sources, upload_num_pool_remixes , , upload_extra FROM cc_tbl_uploads JOIN cc_tbl_user ON upload_user = user_id JOIN cc_tbl_licenses ON upload_license = license_id WHERE ((upload_banned = 0 AND upload_published = 1)) AND ((upload_user = '3223')) AND ((CONCAT(',',upload_tags,',') LIKE '%,www,%' ) AND (CONCAT(',',upload_tags,',') LIKE '%,www,%' ) AND (CONCAT(',',upload_tags,',') LIKE '%,diversityroundtable,%' ) AND (CONCAT(',',upload_tags,',') LIKE '%,net,%' )) ORDER BY upload_date DESC LIMIT 12 OFFSET 0

SELECT upload_id, IF( LENGTH(upload_name) > 31, CONCAT( SUBSTRING(upload_name,1,29), '...'), upload_name ) as upload_name_chop, CONCAT( 'https://ccmixter.org/files/', user_name, '/', upload_id ) as file_page_url, IF( LENGTH(user_image) > 0, CONCAT( 'https://ccmixter.org/content/', user_name, '/', user_image ), 'https://ccmixter.org/mixter-files/images/mixter-default.gif' ) as user_avatar_url, user_real_name, user_name, upload_score, upload_num_scores, upload_extra, 1 as thumbs_up, 1 as ratings_enabled, CONCAT( 'https://ccmixter.org/people/', user_name ) as artist_page_url, license_img_small as license_logo_url, license_url, license_name, CONCAT( 'https://ccmixter.org/reviews/', user_name, '/', upload_id ) as reviews_url, IF( upload_tags LIKE '%,audio,%', CONCAT( 'https://ccmixter.org/api/query/stream.m3u?f=m3u&ids=', upload_id ) , '' ) as stream_url, DATE_FORMAT( upload_date, '%a, %b %e, %Y @ %l:%i %p' ) as upload_date_format, upload_contest, upload_name, upload_num_remixes, upload_num_sources, upload_num_pool_sources, upload_num_pool_remixes , upload_extra FROM cc_tbl_uploads JOIN cc_tbl_user ON upload_user = user_id JOIN cc_tbl_licenses ON upload_license = license_id WHERE ((upload_banned = 0 AND upload_published = 1)) AND ((upload_user = '3223')) AND ((CONCAT(',',upload_tags,',') LIKE '%,www,%' ) AND (CONCAT(',',upload_tags,',') LIKE '%,www,%' ) AND (CONCAT(',',upload_tags,',') LIKE '%,diversityroundtable,%' ) AND (CONCAT(',',upload_tags,',') LIKE '%,net,%' )) ORDER BY upload_date DESC LIMIT 12 OFFSET 0

weed201:

weed201 (www.www.diversityroundtable.net)

clear see results Edit tags

goog style

Search

weed201 (www.www.diversityroundtable.net)