SELECT `authors`.`PathName` AS `AuthorPath`,`authors`.`Name` AS `AuthorName`,`authors`.`Surname` AS `AuthorSurname`,`authors`.`PartID`,`authors`.`EngPartID`,
`authors`.`EngName` AS `EngAuthorName`,`authors`.`EngSurname` AS `EngAuthorSurname`,
`catalog`.*, `pages`.`Name`, `pages`.`Title`, `pages`.`Path`,`pages`.`PathName`,`pages`.`TagKeywords`,`pages`.`TagDescription`
FROM `authors`,`pages`,`catalog`
WHERE `catalog`.`PageID`=`pages`.`ID` && `authors`.`Disabled`='' && `AuthorID`=`authors`.`ID` && `catalog`.`Count`!='2' && `TypeID`='1' && `catalog`.`Count`='1'
ORDER BY `Ctime` DESC
LIMIT 50