SELECT COUNT(`basket`.id) AS `qnt` FROM `basket` LEFT JOIN `catalog` ON `catalog`.id = `basket`.item WHERE `catalog`.exist = "+" AND `catalog`.active_3 = 1 AND `basket`.user = "ed2f4a35e8ae070d355f699b238c6e61"SELECT COUNT(`id`) AS `qnt` FROM `favs` WHERE `user` = "ed2f4a35e8ae070d355f699b238c6e61"SELECT `title`, `link`, (SELECT COUNT(`id`) FROM `comments` WHERE `status` = 1 AND `shop` = 3) AS `cmn_num` FROM `menu` WHERE `extended` = 3 AND `lang` = "ua" LIMIT 1SELECT `id`, `title`, `type`, (SELECT COUNT(`id`) FROM `material` WHERE `sub_id` = `search_table`.id) `c` FROM `search_table` WHERE `active` = 1 AND `lang` = "ua" ORDER BY `pos` ASCSELECT `sub_id`, `title` FROM `material` WHERE `sub_id` IN(10,11,8,6,3,2,9) AND `lang` = "ua" ORDER BY `title` ASCSELECT `code_one`, `code_two`, `code_three`, `tel_one`, `tel_two`, `tel_three`, `milo`, `vk`, `fb`, `tw`, `gl`, `exten`, `exten2`, `title`, `words`, `description`, `minorder`, `sleva` FROM `tech_data` WHERE `lang` = "ua" AND `shop` = 3SELECT `id`, `link` FROM `colage` WHERE `active` = 1 AND `shop` = 3 ORDER BY `pos` ASCSELECT `code`, `demo`, `kyrs` FROM `currency` WHERE `kyrs` = 1 AND `lang` = "ua"SELECT `code`, `demo`, `kyrs` FROM `currency` WHERE `lang` = "ua"SELECT `id` AS `m`, `sub_id`, `title`, `title_ru`, `link`, (SELECT COUNT(`id`) FROM `menu` WHERE `sub_id` = `m`) AS `sub` FROM `menu` WHERE `active_3` = 1 AND `side2` = 1 AND `lang` = "ua" ORDER BY `pos` ASCSELECT `id` AS `m`, `sub_id`, `title`, `title_ru`, `link` FROM `menu` WHERE `active_3` = 1 AND `sub_id` IN(599,377,74,609,120,22,317,601,367,271,376,571,598) AND `lang` = "ua" ORDER BY `pos` ASCSELECT `id` AS `m`, `sub_id`, `title`, `title_ru`, `link`, (SELECT COUNT(`id`) FROM `menu` WHERE `sub_id` = `m`) AS `sub` FROM `menu` WHERE `active_3` = 1 AND `top` = 1 AND `lang` = "ua" ORDER BY `pos` ASCSELECT `id` AS `m`, `sub_id`, `title`, `title_ru`, `link` FROM `menu` WHERE `active_3` = 1 AND `sub_id` IN(377,74,609,120,22,317,601,367,344,393,155,271,672) AND `lang` = "ua" ORDER BY `pos` ASCSELECT `id`, `sub_id`, `title`, `title_ru`, `link` FROM `menu` WHERE `active_3` = 1 AND `bottom` = 1 ORDER BY `pos` ASCSELECT `catalog`.id, `catalog`.sub_id, `catalog`.exist, `catalog`.code, `catalog`.price, `catalog`.prc_3 AS `prc`, `catalog`.currency, `catalog`.sizes, `catalog`.colors, `catalog`.active_3 AS `active`, `catalog`.sleva_3 AS `sleva`, `catalog`.minn_3 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 AND `cat_desc`.lang = "ua" 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 = 64406SELECT `prices`.qnt, `prices`.price2 AS `price`, `prices`.items, `catalog`.currency, `catalog`.prc_3 AS `prc`, `catalog`.sleva_3 AS `sleva` FROM `prices` LEFT JOIN `catalog` ON `catalog`.id = `prices`.sub_id WHERE `prices`.sub_id = 64406 ORDER BY `prices`.qnt ASCSELECT `name` FROM `img_cat` WHERE `sub_id` = 64406 ORDER BY `pos` ASCSELECT `id` FROM `catalog` WHERE `sub_id` = 443 AND `active_3` = 1 ORDER BY `id` ASCSELECT `catalog`.id, `catalog`.exist, `catalog`.code, `catalog`.price, `catalog`.prc_3 AS `prc`, `catalog`.currency, `catalog`.sizes, `catalog`.colors, `catalog`.sleva_3 AS `sleva`, `catalog`.minn_3 AS `minn`, `catalog`.rost, `catalog`.likes, `catalog`.lost, `catalog`.soon, `cat_desc`.title, `cat_desc`.title_ru, `cat_desc`.content, `cat_desc`.content_ru, `cat_desc`.label, `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 IN(27149,82187,87298,93927,94453,94844,94845,95098,98428,105919,106189,107979,107980,108524,111387,111669,113219,113226,113564,113568) AND `catalog`.active_3 = 1 AND `catalog`.sub_id = 443 AND `cat_desc`.lang = "ua" ORDER BY `catalog`.exist ASCSELECT `id`, `sub_id`, `title`, `title_ru` FROM `menu` ORDER BY `id` ASCSELECT `fio`, `msg`, `mark`, `data` FROM `comments` WHERE `status` = 1 AND `shop` = 3 ORDER BY `id` DESC LIMIT 5