SELECT object.id, url, title, name, text AS content, author AS keywords, src AS description, pub, UNIX_TIMESTAMP(datePub) AS pubDate, UNIX_TIMESTAMP(datez) AS createDate, object.lach AS updateDate, _2 FROM object, relation LEFT JOIN object_add ON object.id=object_add.id WHERE child=object.id AND pub='Y' AND parent=997 ORDER BY number