SELECT COUNT(`basket`.id) AS `qnt`
FROM `basket`
LEFT JOIN `catalog` ON `catalog`.id = `basket`.item
WHERE `catalog`.exist = "+" AND `catalog`.active_4 = 1 AND `basket`.user = "671b4f6a6d9333364a44be7e3987a578"
SELECT COUNT(`id`) AS `qnt` FROM `favs` WHERE `user` = "671b4f6a6d9333364a44be7e3987a578"
SELECT `title_4` AS `title`, `link`, (SELECT COUNT(`id`) FROM `comments`
WHERE `status` = 1 AND `shop` = 4) AS `cmn_num` FROM `menu`
WHERE `extended` = 3 LIMIT 1
SELECT `id`, `link` FROM `colage` WHERE `active` = 1 AND `shop` = 4 ORDER BY `pos` ASC
SELECT `code`, `demo`, `kyrs` FROM `currency` WHERE `kyrs` = 1
SELECT `code`, `demo`, `kyrs` FROM `currency`
SELECT `id` AS `m`, `sub_id`, `title_4` AS `title`, `title_ru_4` AS `title_ru`, `link`, (SELECT COUNT(`id`) FROM `menu` WHERE `sub_id` = `m`) AS `sub`
FROM `menu` WHERE `active_4` = 1 AND `side2` = 1 ORDER BY `pos` ASC
SELECT `id` AS `m`, `sub_id`, `title_4` AS `title`, `title_ru_4` AS `title_ru`, `link` FROM `menu` WHERE `active_4` = 1
AND `sub_id` IN(599,377,74,609,120,22,317,601,367,271,376,571,598) ORDER BY `pos` ASC
SELECT `id` AS `m`, `sub_id`, `title_4` AS `title`, `title_ru_4` AS `title_ru`, `link`, (SELECT COUNT(`id`) FROM `menu` WHERE `sub_id` = `m`) AS `sub`
FROM `menu`
WHERE `active_4` = 1 AND `top` = 1
ORDER BY `pos` ASC
SELECT `id` AS `m`, `sub_id`, `title_4` AS `title`, `title_ru_4` AS `title_ru`, `link` FROM `menu` WHERE `active_4` = 1 AND `sub_id` IN(377,74,609,120,22,317,601,367,344,393,155,271,672)
ORDER BY `pos` ASC
SELECT `id`, `sub_id`, `title_4` AS `title`, `title_ru_4` AS `title_ru`, `link` FROM `menu` WHERE `active_4` = 1 AND `bottom` = 1 ORDER BY `pos` ASC
SELECT `catalog`.id, `catalog`.sub_id, `catalog`.exist, `catalog`.code, `catalog`.price, `catalog`.prc_4 AS `prc`,
`catalog`.currency, `catalog`.sizes, `catalog`.colors, `catalog`.active_4 AS `active`, `catalog`.sleva_4 AS `sleva`, `catalog`.minn_4 AS `minn`, `catalog`.rost, `catalog`.lost,
`catalog`.soon,
`cat_desc`.title, `cat_desc`.content, `cat_desc`.title_ru, `cat_desc`.content_ru, `cat_desc`.mtitle, `cat_desc`.description, `cat_desc`.label, `cat_desc`.type, `cat_desc`.item,
`img_cat`.name
FROM `catalog`
LEFT JOIN `cat_desc` ON `cat_desc`.sub_id = `catalog`.id
LEFT JOIN `img_cat` ON `img_cat`.sub_id = `catalog`.id AND `img_cat`.pos = (SELECT MIN(`pos`)
FROM `img_cat` WHERE `img_cat`.sub_id = `catalog`.id)
WHERE `catalog`.id = 25703
SELECT `prices`.qnt, `prices`.price2 AS `price`, `prices`.items, `catalog`.currency, `catalog`.prc_4 AS `prc`, `catalog`.sleva_4 AS `sleva`
FROM `prices`
LEFT JOIN `catalog` ON `catalog`.id = `prices`.sub_id
WHERE `prices`.sub_id = 25703 ORDER BY `prices`.qnt ASC
SELECT `name` FROM `img_cat` WHERE `sub_id` = 25703 ORDER BY `pos` ASC
SELECT `id` FROM `catalog` WHERE `sub_id` = 258 AND `active_4` = 1 ORDER BY `id` ASC
SELECT `id`, `sub_id`, `title_4` AS `title`, `title_ru_4` AS `title_ru` FROM `menu` ORDER BY `id` ASC
SELECT `fio`, `msg`, `mark`, `data` FROM `comments`
WHERE `status` = 1 AND `shop` = 4 ORDER BY `id` DESC LIMIT 5
