


Here is as sample of swimming pools Copper Creek Pools has designed and constructed in Spokane. Please feel free to contact us for more pictures from our portfolio.
An unexpected error occurred.
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'spokanep_main.fsfl.fsDisplayOrder' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName
FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID
LEFT JOIN Users u on u.uID = fv.fvAuthorUID
left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) left join FileSetFiles fsfl on fsfl.fID = f.fID where 1=1 and fv.fvType = '1' and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 0 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and f.fID IN (SELECT DISTINCT fID FROM FileSetFiles WHERE fsID = '3') order by fsDisplayOrder asc, fID asc ")