SELECT InvoiceID, InvoicePaidDate, firstStart, firstExpires, RecordID, HomeName, BiasedDescription, BiasedExpiration, BiasedLive, BiasedBasic, PhoneExt, Website, PhoneNumber, PostalCode,  (BiasedExpiration IS NOT NULL AND BiasedExpiration > Now() AND BiasedLive = 1 AND (InvoiceID IS NULL OR InvoicePaidDate IS NOT NULL)) AS IsBiased, assistedLiving, complexCare, CrisisAdmissions, groupHome, homesharing, independentLivingForPurchase, independentLivingForRent, activeAdultLifestyleCom, IndependentPlus, longTermCaredata, memoryCare, palliativeCare, personalCareHome, respiteCare, retirementHome, senior_cohousing, senior_cooperative, seniorsBuildingNoCare, shortStays, supportiveHousing, offerTraditionalCare, trialStays, Email, City, Province, Address,  
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(LOWER(TRIM(HomeName)), 
':', ''), ')', ''), '(', ''), ',', ''), '\\', ''), '/', ''), '"', ''), '\?', ''),
"'", '-'), '&', ''), '!', ''), '.', ''), ' ', '-'), '--', '-'), '--', '-'),'ù','u'),
'ú','u'),'û','u'),'ü','u'),'ý','y'),'ë','e'),'à','a'),'á','a'),'â','a'),'ã','a'), 
'ä','a'),'å','a'),'æ','a'),'ç','c'),'è','e'),'é','e'),'ê','e'),'ë','e'),'ì','i'),
'í','i'),'ě','e'), 'š','s'), 'č','c'),'ř','r'), 'ž','z'), 'î','i'),'ï','i'),'ð','o'),
'ñ','n'),'ò','o'),'ó','o'),'ô','o'),'õ','o'),'ö','o'),'ø','o'),'%', '') slug FROM residence LEFT OUTER JOIN DirectoryLinkInvoice 
ON InvoiceID = BiasedInvoice AND InvoiceRenewal <> 1   WHERE 0=0 ORDER BY  BiasedExpiration IS NOT NULL AND BiasedExpiration > Now() AND BiasedLive = 1 AND (InvoiceID IS NULL OR InvoicePaidDate IS NOT NULL) DESC, BiasedBasic ASC, if(firstExpires IS NOT NULL AND firstExpires > Now(),firstStart,'2999-1-1') ASC,  Rand()<BR><BR>Disk full (/tmp/#sql_bb0_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br><br>#1 /var/www/vhosts/seniorcareaccess.com/beta.seniorcareaccess.com/plugins/housinglist.php(261): WA_MySQLi_RS->execute()<br>#2 /var/www/vhosts/seniorcareaccess.com/beta.seniorcareaccess.com/housing.php(472): require('/var/www/vhosts...')<br>