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 = "0c67a55a4d10eae388fd48b0b1f011cc"SELECT COUNT(`id`) AS `qnt` FROM `favs` WHERE `user` = "0c67a55a4d10eae388fd48b0b1f011cc"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 `id`, `sub_id`, `title`, `content`, `title_ru`, `content_ru`, `mtitle`, `words`, `description`, `template` FROM `menu` 
  WHERE `id` = 564 AND `active_3` = 1 AND `lang` = "ua"SELECT `id`, `sub_id`, `title` FROM `menu` ORDER BY `id` ASCSELECT m.`id`, m.`sub_id`, m.`title`, m.`content`, m.`title_ru`, m.`content_ru`, m.`pos`, m.`active_3`, m.`link`, m.`main`,  m.`data`, i.`name`,
    (SELECT COUNT(`id`) FROM `catalog` WHERE `sub_id` = m.`id` AND `catalog`.active_3 = 1) AS `num`
    FROM `menu` `m`
    LEFT JOIN `img_menu_3` `i` ON i.`sub_id` = m.`id` AND i.`pos` = (SELECT MIN(`pos`) FROM `img_menu_3` WHERE `sub_id` = m.`id`)
    WHERE m.`sub_id` = 564 AND m.`active_3` = 1 AND m.`lang` = "ua" ORDER BY m.`pos` ASCSELECT `banner` AS `banner` FROM `banner_id` WHERE `shop` = 3SELECT `banner_id`.banner, `banner`.link
	FROM `banner_id`
	LEFT JOIN `banner` ON `banner`.id = `banner_id`.banner 
	WHERE `banner_id`.sub_id = 564 AND `banner`.active = 1 AND `banner_id`.shop = 3 ORDER BY `banner`.pos ASCSELECT `menu`.id, `menu`.sub_id, 
   (SELECT COUNT(`id`) FROM `catalog` WHERE `catalog`.sub_id = `menu`.id AND `catalog`.active_3 = 1) AS `num` 
   FROM `menu`
   WHERE `lang` = "ua" ORDER BY `menu`.pos ASCSELECT `catalog`.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`.likes, `catalog`.lost, `catalog`.soon,
  `cat_desc`.title, `cat_desc`.title_ru,
  `cat_desc`.content, `cat_desc`.content_ru, `cat_desc`.label, `img_cat`.name,
  (SELECT ROUND(SUM(`comments2`.mark)/COUNT(`comments2`.id),1) FROM `comments2` WHERE `comments2`.status = 1 
  AND `comments2`.sub_id = `catalog`.id) AS `mark`
  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`.active_3 = 1 AND `catalog`.sub_id = 564 OR `catalog`.id IN(SELECT `main_id` FROM `group_id` WHERE `subs` = 564)  
  ORDER BY `catalog`.exist ASC, `catalog`.pos ASC LIMIT 132, 12SELECT `id`, `title`, `title_ru` FROM `menu` WHERE `side` = 1 AND `active_3` = 1 AND `lang` = "ua"SELECT `id`, `title`, `title_ru`, `mtitle` FROM `menu` WHERE `sub_id` = 120 AND `active_3` = 1 
	   AND `lang` = "ua" ORDER BY `pos` ASC LIMIT 4SELECT COUNT(`catalog`.id) + 
	  (SELECT COUNT(`id`) FROM `catalog` WHERE `id` 
	  IN(SELECT `main_id` FROM `group_id` WHERE `subs` = 564 AND `active` = 1 AND `exist` = "+")) `total`
	  FROM `catalog`
	  WHERE `catalog`.sub_id = 564 AND `catalog`.active_3 = 1 ORDER BY `catalog`.exist ASC, `catalog`.pos ASCUnknown column 'active' in 'where clause'