couldn't get info SELECT listings.id as id, a_code, a_lname, a_fname, l_title, l_medium, file FROM artists, listings, listings_images WHERE l_status!='S' AND artists.id = listings.artist AND listings.id = listings_images.listing AND l_loopArtist = 1 AND artists.id = '187' AND l_medium IN ('O') AND l_approve=2 ORDER BY RAND() LIMIT 4