| 0.0002 |
SELECT `c`.`name`
FROM (`psu_category` c)
WHERE `c`.`aname` = 'vodosnabgenie-i-kanalizatsiya'
|
| 0.0001 |
SELECT `c`.`name`
FROM (`psu_category` c)
WHERE `c`.`aname` = 'vodosnabgenie-i-kanalizatsiya'
|
| 0.0001 |
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' AND (`cat`.`id` IN (
SELECT `c1`.`id`
FROM `psu_category` `c1`
JOIN `psu_category` `c2` ON c1.parent_id = c2.id
WHERE c2.aname = 'vodosnabgenie-i-kanalizatsiya')
OR `cat`.`aname` = 'vodosnabgenie-i-kanalizatsiya') ORDER BY `created` desc
LIMIT 0,10
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`psu_content` content)
JOIN `psu_category` cat ON `content`.`cat_id` = `cat`.`id`
WHERE `type` = 'items'
AND `cat`.`aname` = 'vodosnabgenie-i-kanalizatsiya'
|
| 0.0001 |
SELECT `p1`.`name`, `p1`.`aname`
FROM (`psu_category` p1)
JOIN `psu_category` p2 ON `p1`.`parent_id` = `p2`.`id`
WHERE `p2`.`aname` = 'vodosnabgenie-i-kanalizatsiya'
|
| 0.0001 |
SELECT *
FROM (`psu_category`)
WHERE `parent_id` = 0
|
