collalias=silicon isBackend=N groupingCount=2 type=children grpReqParent=N grpParent=Y grpReq=N grp=N SQL: SELECT `silicon`.*, `parentGroups`.`id` AS `group_id`, `parentGroups`.`goods_sku` AS `sku`, `parentGroups`.`goods_size` AS `silicon_size`, `parentGroups`.`goods_color` AS `silicon_color`, `parentGroups`.`goods_price` AS `price`, `parentGroups`.`goods_quantity` AS `quantity`, `parentGroups`.`goods_image` AS `image`, `parentGroups`.`goods_gallery` AS `gallery`, `goods_parentGroups_silicon_size`.`value` AS `silicon_size_value`, `goods_parentGroups_silicon_size`.`imageName` AS `silicon_size_imageName`, `goods_parentGroups_silicon_size`.`description` AS `silicon_size_description`, `goods_parentGroups_silicon_color`.`value` AS `silicon_color_value`, `goods_parentGroups_silicon_color`.`imageName` AS `silicon_color_imageName`, `goods_parentGroups_silicon_color`.`description` AS `silicon_color_description`, `grp_img`.`fileName` AS `grp_image_fileName`, `grp_img`.`ext` AS `grp_image_ext`, `grp_img`.`type` AS `grp_image_type`, `grp_img`.`owner` AS `grp_image_owner`, `grp_img`.`instanceId` AS `grp_image_instanceId` FROM (SELECT `c_goods`.`id`, `c_goods`.`deleted`, `c_goods`.`collectionId`, `c_goods`.`collectionAlias`, `c_goods`.`offer`, `c_goods`.`goods_sku` AS `silicon_sku`, `c_goods`.`goods_external_sku` AS `silicon_external_sku`, `c_goods`.`goods_brand` AS `silicon_brand`, `c_goods`.`goods_new` AS `silicon_new`, `c_goods`.`goods_weight` AS `silicon_weight`, `c_goods`.`goods_discounted` AS `silicon_discounted`, `c_goods`.`goods_discount` AS `silicon_discount`, `c_goods`.`goods_price` AS `silicon_price`, `c_goods`.`goods_quantity` AS `silicon_quantity`, `c_goods`.`goods_max_quantity` AS `silicon_max_quantity`, `c_goods`.`goods_image` AS `silicon_image`, `c_goods`.`goods_gallery` AS `silicon_gallery`, `c_goods`.`goods_youtube` AS `silicon_youtube`, `c_goods`.`goods_tags` AS `silicon_tags`, `c_goods`.`goods_alias` AS `silicon_alias`, `c_goods`.`goods_created` AS `silicon_created`, `c_goods`.`goods_redacted` AS `silicon_redacted`, `c_goods`.`goods_views` AS `silicon_views`, `c_goods`.`goods_published` AS `silicon_published`, `parentLang`.`goods_name` AS `silicon_name`, `parentLang`.`goods_desc` AS `silicon_desc`, `parentLang`.`goods_composition` AS `silicon_composition`, `parentLang`.`goods_seotitle` AS `silicon_seotitle`, `parentLang`.`goods_seotags` AS `silicon_seotags`, `parentLang`.`goods_seodesc` AS `silicon_seodesc`, `core_silicon_brand`.`brands_alias` AS `silicon_brand_alias`, `core_silicon_brand_trn`.`brands_name` AS `silicon_brand_value`, `goods_silicon_image`.`fileName` AS `silicon_image_fileName`, `goods_silicon_image`.`ext` AS `silicon_image_ext`, `goods_silicon_image`.`size` AS `silicon_image_size`, `goods_silicon_image`.`type` AS `silicon_image_type`, `goods_silicon_image`.`owner` AS `silicon_image_owner`, `goods_silicon_image`.`instanceId` AS `silicon_image_instanceId` FROM `c_goods` AS `c_goods` INNER JOIN `c_silicon` AS `child` ON `c_goods`.`id` = `child`.`id` INNER JOIN `c_goods_trn` AS `parentLang` ON `parentLang`.`itemId` = `c_goods`.`id` AND `parentLang`.`lang` = 1 INNER JOIN `c_brands` AS `core_silicon_brand` ON `core_silicon_brand`.`id` = `c_goods`.`goods_brand` LEFT JOIN `c_brands_trn` AS `core_silicon_brand_trn` ON `core_silicon_brand_trn`.`itemId` = `c_goods`.`goods_brand` AND `core_silicon_brand_trn`.`lang` = 1 LEFT JOIN `images` AS `goods_silicon_image` ON `goods_silicon_image`.`id` = `c_goods`.`goods_image` WHERE (`c_goods`.`deleted` = 0) AND (`c_goods`.`goods_published` = 1) GROUP BY `c_goods`.`id` ORDER BY `c_goods`.`id` DESC LIMIT 12) AS `silicon` LEFT JOIN `c_goods_grps` AS `parentGroups` ON `silicon`.`id` = `parentGroups`.`itemID` LEFT JOIN `options_values` AS `goods_parentGroups_silicon_size` ON `goods_parentGroups_silicon_size`.`optionId` = 3 AND `goods_parentGroups_silicon_size`.`id` = `parentGroups`.`goods_size` LEFT JOIN `options_values` AS `goods_parentGroups_silicon_color` ON `goods_parentGroups_silicon_color`.`optionId` = 2 AND `goods_parentGroups_silicon_color`.`id` = `parentGroups`.`goods_color` LEFT JOIN `images` AS `grp_img` ON `grp_img`.`id` = `parentGroups`.`goods_image` WHERE ((parentGroups.id IS NULL OR parentGroups.id = (SELECT g2.id FROM c_goods_grps g2 WHERE g2.itemID = silicon.id ORDER BY g2.is_primary DESC, (g2.goods_quantity > 0) DESC, g2.goods_quantity DESC, g2.id ASC LIMIT 1))) ORDER BY `silicon`.`id` DESC