SELECT "product"."entityId" AS "entityId", "product"."mkpId" AS "mkpId", "product"."storeId" AS "storeId", "product"."whid" AS "whid", "product"."ukey" AS "ukey", "product"."exId" AS "exId", "product"."typical" AS "typical", "product"."typeId" AS "typeId", "product"."variaId" AS "variaId", "product"."created" AS "created", "product"."updated" AS "updated", "product"."sku" AS "sku", "product"."barcode" AS "barcode", "product"."urlKey" AS "urlKey", "product"."ean13" AS "ean13", "product"."status" AS "status", "product"."warehouse" AS "warehouse", "product"."factory" AS "factory", "product"."featured" AS "featured", "product"."best" AS "best", "product"."st" AS "st", "product"."stAmount" AS "stAmount", "product"."rt" AS "rt", "product"."rtAmount" AS "rtAmount", "product"."tax" AS "tax", "product"."name" AS "name", "product"."nameEn" AS "nameEn", "product"."nameEs" AS "nameEs", "product"."nameDe" AS "nameDe", "product"."newFrom" AS "newFrom", "product"."newTo" AS "newTo", "product"."price" AS "price", "product"."buying" AS "buying", "product"."price1" AS "price1", "product"."price2" AS "price2", "product"."price3" AS "price3", "product"."price4" AS "price4", "product"."phd" AS "phd", "product"."phd1" AS "phd1", "product"."phd2" AS "phd2", "product"."phd3" AS "phd3", "product"."phd4" AS "phd4", "product"."specialPrice" AS "specialPrice", "product"."specialFrom" AS "specialFrom", "product"."specialTo" AS "specialTo", "product"."priceGroup" AS "priceGroup", "product"."taxGroup" AS "taxGroup", "product"."promo" AS "promo", "product"."whithPromo" AS "whithPromo", "product"."cost" AS "cost", "product"."unit" AS "unit", "product"."qty" AS "qty", "product"."lot" AS "lot", "product"."shortDescription" AS "shortDescription", "product"."description" AS "description", "product"."descriptionEn" AS "descriptionEn", "product"."descriptionDe" AS "descriptionDe", "product"."descriptionEs" AS "descriptionEs", "product"."composition" AS "composition", "product"."materials" AS "materials", "product"."metaDescription" AS "metaDescription", "product"."metaKeywords" AS "metaKeywords", "product"."metaTitle" AS "metaTitle", "product"."image" AS "image", "product"."imageSmall" AS "imageSmall", "product"."imageLabel" AS "imageLabel", "product"."imageCmpx" AS "imageCmpx", "product"."dheight" AS "dheight", "product"."dlength" AS "dlength", "product"."dwidth" AS "dwidth", "product"."weight" AS "weight", "product"."weightType" AS "weightType", "product"."category" AS "category", "product"."catCmpx" AS "catCmpx", "product"."catKey" AS "catKey", "product"."categoryId" AS "categoryId", "product"."subCategory" AS "subCategory", "product"."subCategoryId" AS "subCategoryId", "product"."otherCategory" AS "otherCategory", "product"."otherCategoryId" AS "otherCategoryId", "product"."brand" AS "brand", "product"."brandId" AS "brandId", "product"."supplier" AS "supplier", "product"."supplierId" AS "supplierId", "product"."year" AS "year", "product"."season" AS "season", "product"."origin" AS "origin", "product"."attrTxt" AS "attrTxt", "product"."attrCmpx" AS "attrCmpx", "product"."packageCmpx" AS "packageCmpx", "product"."color" AS "color", "product"."colorSwith" AS "colorSwith", "product"."size" AS "size", "product"."position" AS "position", "product"."tag" AS "tag", "product"."videoUri" AS "videoUri", "product"."lining" AS "lining", "product"."stockTag" AS "stockTag", "product"."stockKey" AS "stockKey", "product"."rating" AS "rating" FROM "product" WHERE "status" = '1' AND "typeId" NOT IN ('9') AND "catKey" LIKE '%\\_4505\\_%'