RU EN

Новинки


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
Посмотреть весь каталог