select companies.compid, companies.company, companies.date, DATE_FORMAT(companies.date, '%e %M, %Y') as formattedregistrationdate, locations.location, locations.countryid, companies.description, companies.bid, companies.logo, companies.siteid, companies.aaaa, companies.ip, (TO_DAYS(NOW()) - TO_DAYS(companies.lastlogindate)) as days_activity, companies.businesstypeids, companies.verifyid, companies.verifytime, companies.lastmodified, companies.lastlogindate, companies.totalpayments, companies.signuppayment, companies.mws, descriptionlength, companies.cantdoanything, companies.cantdoanythingdetails, companies.sellwords, companies.buywords, companies.tradeleadnumber, companies.productnumber from (companies, locations) where companies.locationid = locations.locationid and companies.startingchar = 'N' and companies.cantdoanything = 0 and companies.compid in (166578) order by companies.bid desc, companies.company limit 0, 20