| 0.0013 |
SELECT content.*,DATE_FORMAT(content.created,'%d.%m.%Y<br> %H:%m:%s') as date_creat,cat.name cat, cat.aname acat FROM (`psu_content` content) JOIN `psu_category` cat ON `content`.`cat_id` = `cat`.`id` JOIN `users` u ON `u`.`id` = `content`.`user_id` JOIN `psu_company` company ON `u`.`id` = `company`.`user_id` WHERE `content`.`type` = 'items' ORDER BY `created` desc LIMIT 0,10
|