SELECT
			
			
		items.imp,
		items.zakupka,
		items.zakupkaPr,
		items.new_hide,
		IFNULL(`model`.`value`, 0) AS `model`,
		IFNULL(`mindost`.`value`, 0) AS `mindost`,
		IFNULL(`nc`.`value`, 0) AS `nc`,
		IFNULL(`realiz`.`value`, 0) AS `realiz`,
		`items`.`sklad` AS `inBox`,
		`items`.`onlypre`,
		`items_plash`.`prihod` AS `prihodPl`,
		`items_plash`.`novinka` AS `novinkaPl`,
		`items_plash`.`vygodno` AS `vygodnoPl`,
		`items_plash`.`skoro` AS `skoroPl`,
		`items_plash`.`sp` AS `spPl`,
		
			IFNULL(`dopdis`.`value`, 0) AS `dopdis`,
			IFNULL(`dopdisdate`.`value`, 0) AS `dopdisdate`,
			IFNULL(`nac_predzakaz_nds`.`value`, 0) AS `nac_predzakaz_nds`,
			IFNULL(`nac_predzakaz`.`value`, 0) AS `nac_predzakaz`,
			IFNULL(`minpred`.`value`, 0) AS `minpred`,
			`post`.`1c_tmp`,
			
		IFNULL(`size`.`value`, 0) AS `size`,
		items.itemId,
		items.itemPriceNew,
		items.priceBase,
		items.prhold,
		items.preuro,
		items.`1cCode`,
		items.preord,
		images.img,
		items.video,
		items.shcode,
		items.rev_auc,
		items.pop,
		items.bfKey,
		items.`order`,
		items.`code`,
		items.`skip`,
		items.state,
		items.typeis,
		items.vkompl,
		items.origin,
		impp.date,
		items.upd,
		cur.`name` AS `curName`,
		items.partner,
		items.new_key,
		items.sub3,
		items.itemName,
		items.canpre,
		items.canpreday,
		items.availability,
		items.art,
		marks.markaName,
		marks.`key` AS `markaKey`,
		marks.promo_from,
		marks.logo AS `mLogo`,
		ad_raz.url AS `cat`,
		ad_raz.`name` AS `razName`,
		ad_raz.id AS `rId`,
		1 AS `var`
		
		FROM
			items
		
		INNER JOIN `items_raz` FORCE INDEX FOR JOIN (`it_raz`) ON items_raz.item = items.imp
		
		LEFT JOIN 
			`params` AS `mindost` ON `mindost`.`item` = `items`.`itemId` AND (`mindost`.`param_id` = '73')
		LEFT JOIN 
			`params` AS `nc` ON `nc`.`item` = `items`.`itemId` AND (`nc`.`param_id` = '57')
		LEFT JOIN 
			`params` AS `realiz` ON `realiz`.`item` = `items`.`itemId` AND (`realiz`.`param_id` = '147')
		LEFT JOIN 
			`items_plash` ON `items_plash`.`item` = `items`.`itemId`
		
		LEFT JOIN 
			`items_bonus` ON `items_bonus`.`item` = `items`.`itemId` 
		LEFT JOIN 
			params AS `dopdis` ON `dopdis`.item = items.itemId
		AND
			(
				`dopdis`.`param_id` = '21'
				OR `dopdis`.`param_id` IS NULL
			)
		LEFT JOIN 
			params AS `dopdisdate` ON `dopdisdate`.item = items.itemId
		AND
			(
				`dopdisdate`.`param_id` = '22'
				OR `dopdisdate`.`param_id` IS NULL
			)
		LEFT JOIN 
			`cardsSubscr_mail` AS `post` ON `post`.`id` = `items`.`origin` 
		LEFT JOIN 
			params AS `nac_predzakaz` ON `nac_predzakaz`.item = items.itemId
		AND
			(
				`nac_predzakaz`.`param_id` = '143'

			)
		LEFT JOIN 
			params AS `nac_predzakaz_nds` ON `nac_predzakaz_nds`.item = items.itemId
		AND
			(
				`nac_predzakaz_nds`.`param_id` = '143'
			)
		LEFT JOIN 
			params AS `minpred` ON `minpred`.item = items.itemId
		AND
			(
				`minpred`.`param_id` = '120'

			)
			
		LEFT JOIN params AS `size` ON `size`.item = items.itemId
		AND (
			`size`.`param_id` = '20'
		)
		LEFT JOIN 
			params AS `model` ON `model`.item = items.itemId
		AND
			(
				`model`.`param_id` = '27'

			)
		LEFT JOIN 
			`rev_auction` ON rev_auction.item = items.itemId
		LEFT JOIN 
			marks ON marks.markaId = items.marka
		LEFT JOIN 
			items AS impp ON impp.itemId = items.imp
		LEFT JOIN 
			images ON images.id = impp.image
		LEFT JOIN 
			`ad_raz` ON ad_raz.id = items.itemType
		LEFT JOIN 
			cur ON items.upd = cur.id
		
		
		
		LEFT JOIN `items_raz` AS `ir` ON `ir`.`item` = `items`.`itemId`
		WHERE
			 
		
		`items`.`ignore` = '0' AND 
		`items`.`itemType` != '0' AND  
		`items`.`origin` != '0' 
		
				AND `items`.`bfKey` = '0'
				 AND `items`.`priceBase` > '0'  AND `items`.`rozn` != '0' AND `items`.`bfKey` = '0'AND `items`.`hide` != '1' 
		AND 
			`ir`.`ad_raz` IN ('1490') 
		GROUP BY 
			
	`items`.`availability`,
	`items`.`itemId`
	
		ORDER BY
			`items`.`partner` ASC,
			`items`.`availability` DESC,
			
			 
	`items`.`itnum` ASC,
	`items`.`image` DESC,
	`items`.`itemId` DESC
	
		

Болт М8х26 крепления карданного вала 2101 в сборе с гайкой (к-т 4 шт) РЕМКОМ 2101- 2107, 2121, 2123 RK01346

код: 370769

97.00

в корзину