SELECT pages.*, person.firstname, person.lastname, pages.title, pages.visible, content.content FROM pages,person,content WHERE person.id=pages.personid AND content.mocid=pages.id AND content.position=1 AND pages.visible<>0 AND pages.directoryid = 117 ORDER BY score DESC LIMIT 0, 15