SELECT distinct atadverts_live.make FROM atadverts_live LEFT JOIN manufacturers ON (atadverts_live.make LIKE CONCAT( '%', manufacturers.make, '%' )) WHERE timestampdiff(SECOND,now(),expiry) > 0 && manufacturer <=> NULL && media = 'ebay_us' AND site = 'quad' ORDER BY atadverts_live.make ASC
