SELECT `e`.`entity_id` AS `brand_mage_id`, `ccev`.`value` AS `brand_name` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_varchar` AS `ccev` ON e.entity_id = ccev.entity_id AND ccev.attribute_id = 111 AND ccev.value like 'T%' INNER JOIN `catalog_category_product` AS `ccpi` ON ccpi.category_id = e.entity_id AND ccpi.product_id in (195518,195897,195900,195901,195902,195903,196108,196170,196304,196356,196381,196403,196404,196405,204962,205337,205382,205844,205845,206012,210510,325697,325750,329389,194789,195904,195905,195906,195907,195908,195909,195910,196011,196012,196013,196014,196015,196016,196017,196018,196029,196030,196031,196032,196033,196036,196037,196038,196039,196040,196041,196042,196043,196044,196045,196046,196047,196048,196050,196051,196053,196054,196055,196056,196057,196058,196059,196060,196061,196062,196063,196064,196065,196066,196067,196068,196069,196070,196071,196072,196073,196074,196075,196076,196077,196078,196079,196080,196081,196082,196083,196084,196085,196086,196087,196089,196090,196091,196092,197576,197577,197578,197620,199385,202494,202752,202895,202906,202943,202952,202971,202973,203050,203266,203292,203336,203887,203928,203955,203960,203980,204498,204534,204864,204934,205187,205191,205221,205287,205339,205472,205473,205838,205840,205877,206101,206689,206846,207413,207468,207469,207712,208065,208263,208264,209776,209815,209864,210176,210226,210228,210236,210344,218116,218164,218658,218763,218773,325654,194835,195329,195330,195331,195332,195333,195334,195335,195336,195337,195338,195339,195340,195341,195342,195343,195344,195345,195346,195347,195348,195349,195350,195351,195352,195353,195354,195355,195356,195357,195358,195359,195360,195361,195362,195363,195364,195365,195366,195367,195368,195369,195370,195371,195372,195373,195374,195375,195376,195377,195378,195379,195380,195381,195382,195383,195384,195385,195386,195387,195388,195390,195391,195392,195393,195394,195395,195396,195397,195398,195399,195400,195401,195402,195403,195404,195405,195406,195407,195408,195409,195410,195411,195412,195413,195414,195415,195416,195417,195418,195419,195420,195421,195422,195423,195424,195425,195426,195427,195428,195429,195430,195431,195432,195433,195434,195435,195436,195437,195438,195439,195440,195441,195442,195443,195444,195445,195446,195447,195448,195449,195450,195451,195452,195453,195454,195455,195456,195457,195458,195459,195460,195461,195462,195463,195464,195465,195466,195467,195468,195469,195470,195471,195472,195473,195474,195475,195476,195477,195478,195479,195480,195481,195482,195483,195484,195485,195486,195487,195488,195489,195490,195491,195492,195493,195494,195549,196980,196981,196983,202702,202742,202774,202813,202846,202851,202852,202858,202860,204985,205063,205436,205700,206976,207165,207446,207448,207916,207917,208060,208061,208114,208157,208158,208177,208434,208587,208593,208757,209011,209012,217931,218737,218834,218835,326676,329184,329406,329431,195290,195291,195292,195293,195294,195295,195296,195297,195298,195299,195300,195301,195302,195303,195304,195305,195307,195308,195309,195310,195312,195313,195315,195316,195317,195318,195319,195320,195321,195322,195323,195324,195325,195326,195327,195328,195495,195496,195497,195498,195499,195500,195501,195502,195503,195504,195505,195506,195507,195508,195509,195510,195511,195512,195513,195514,195515,195516,195517,195519,195520,195521,195522,195523,195524,195525,195526,195527,195528,195529,195530,195531,195532,195533,195534,195535,195536,195537,195538,195539,195540,195541,195542,195543,195544,195545,195546,195547,195548,195550,195898,195899,202596,202739,202859,202871,204884,204890,217839,217857,217858,217860,217862,217902,217919,217920,217932,218010,218074,218082,218117,218166,218191,218192,218193,218286,218287,218288,218300,218317,218320,218446,218473,218565,218566,218631,218637,218640,218700,218705,218725,218777,218778,218785,218826,329282,329373,329449,329561,196019,196020,196021,196022,196023,196024,196025,196026,196027,196028,199383,199384,199389,199392,199393,199398,199411,205509,205761,205839,206714,325699,326882,196088,196340,196341,196342,196343,196344,196345,196346,196347,196348,196349,196350,196351,196352,196353,196354,196355,196357,196358,196359,196360,196361,196362,196363,196364,196365,196366,196367,196368,196369,196370,196372,196373,196374,196375,196376,196378,196379,196380,196382,196383,196384,196385,196386,196387,196388,196389,196390,196391,196392,196393,196394,196395,196396,196397,196398,196399,196400,196401,196402,196406,196407,196408,196409,196410,196411,196412,196413,196414,196416,196417,202563,202595,202601,202603,202614,202619,202653,202655,202666,202667,202689,202875,202904,202905,202942,202948,202949,202950,202967,203056,203156,203174,203207,203706,203976,204345,204364,204794,204795,204808,204843,204867,205067,205118,205189,205219,205274,205455,205635,205739,205809,205837,206092,206393,206687,206787,206789,206826,206827,206852,206893,207223,207279,207753,207756,207944,208063,208064,208112,208132,208135,208239,208280,208281,209171,209454,209843,209877,209984,210244,210264,210328,210329,217810,217813,217979,217981,217982,217983,217997,218060,218119,218167,218196,218301,218388,218513,218514,218515,218627,218633,218754,218755,218842,262440,325821,326674,329125,329393,335152,335153,335154,335155,335156,335157,335158,335159,335160,335161,335162,335163,335164,335165,335166,335167,335168,335169,335170,335171,335172,335173,335174,335175,335176,335177,335178,335179,335180,335181,335182,335183,335184,335185,335186,335187,335188,335189,335190,335191,335192,335193,335194,335195,335196,335197,335198,335199,335200,335201,335202,335203,335204,335205,335206,335207,335208,335209,335210,335211,335212,335213,335214,335215,335216,335217,335218,335219,335220,335221,335222,335223,335224,335225,335226,335227,335228,335229,335230,335231,335232,335233,335234,335235,335236,335237,335238,335239,335240,335241,335242,335243,335244,335245,335246,335247,335248,335249,335250,335251,335252,335253,335254,335255,335256,335257,335258,335259,335260,335261,335262,335263,335264,335265,335266,335267,335268,335269,335270,335271,335272,335273,335274,335275,335276,335277,335278,335279,335280,335281,335282,335283,335284,335285,335286,335287,335288,335289,335290,335291,335292,335293,335294,335295,335296,335297,335298,335299,335300,335301,335302,335303,335304,335305,335306,335307,335308,335309,335310,335311,335312,335313,335314,335315,335316,335317,335318,335319,335320,335321,335322,335323,335324,335325,335326,335327,335328,335329,335330,335331,335332,335333,335334,335335,335336,335337,335338,335339,335340,335341,335342,335343,335344,335345,335346,335347,335348,335349,335350,335351,335352,335353,335354,335355,335356,335357,335358,335359,335360,335361,335362,335363,335364,335365,335366,335367,335368,335369,335370,335371,335372,335373,335374,335375,335376,335377,335378,335379,335380,335381,335382,335383,335384,335385,335386,335387,335388,335389,335390,335391,335392,335393,335394,335395,335396,335397,335398,335399,335400,335401,335402,335403,335404,335405,335406,335407,335408,335409,335410,335411,335412,335413,335414,335415,335416,335417,335418,335419,335420,335421,335422,335423,335424,335425,335426,335427,335428,335429,335430,335431,335432,335433,335434,335435,335436,335437,335438,335439,335440,335441,335442,335443,335444,335445,335446,335447,335448,335449,335450,335451,335452,335453,335454,335455,335456,335457,335458,335459,335460,335461,335462,335463,335464,335465,335466,335467,335468,335469,335470,335471,335472,335473,335474,335475,335476,335477,335478,335479,335480,386801,196093,196094,196095,196096,196097,196098,196099,196100,196101,196102,196103,196104,196105,196106,196107,196109,196110,196111,196112,196113,196114,196115,196116,196117,196118,196119,196120,196121,196122,196123,196124,196125,196126,196127,196128,196129,196130,196131,196132,196133,196134,196135,196136,196137,196138,196139,196140,196141,196142,196143,196144,196145,196146,196147,196148,196149,196150,196151,196152,196153,196154,196155,196156,196157,196158,196159,196160,196161,196163,196164,196165,196166,196167,196168,196169,196171,196172,196173,196174,196175,196176,196177,196178,196179,196180,196181,196182,196183,196184,196185,196186,196187,196188,196189,196190,196191,196192,196193,196194,196195,196196,196197,196198,196199,196200,196201,196202,196203,196204,196205,196206,196207,196208,196209,196210,196211,196212,196216,196217,196218,196219,196220,196221,196222,196223,196224,196225,196226,196227,196228,196229,196230,196231,196232,196233,196234,196235,196236,196237,196238,196239,196240,196241,196243,196244,196245,196246,196247,196248,196249,196250,196251,196252,196253,196254,196255,196256,196257,196258,196259,196260,196261,196262,196263,196264,196265,196266,196267,196268,196269,196270,196271,196272,196273,196274,196275,196276,196277,196278,196279,196280,196281,196282,196283,196284,196285,196286,196287,196288,196289,196290,196291,196292,196293,196294,196295,196296,196297,196298,196299,196300,196301,196303,196305,196306,196307,196308,196309,196310,196311,196312,196313,196314,196315,196316,196317,196318,196319,196320,196321,196322,196323,196324,196325,196326,196327,196328,196329,196330,196331,196332,196333,196334,196335,196336,196337,196338,196339,202561,202845,202873,203002,203006,203013,203123,203406,203625,203655,203658,204255,204256,204266,204586,204612,204873,205184,205185,205437,205486,205731,206952,207725,207788,207789,207810,209362,210193,210222,210333,210354,217879,217909,217970,217971,218068,218069,218111,218112,218115,218118,218137,218195,218232,218233,218234,218235,218239,218270,218271,218316,218321,218322,218323,218398,218399,218400,218401,218537,218538,218539,218546,218547,218550,218570,218571,218653,218667,218670,218684,218685,218687,218711,218712,218713,218714,218728,218774,218775,218781,218782,218786,218796,218833,218836,329314,329525,329564) WHERE (e.parent_id=13) GROUP BY `ccev`.`value` LIMIT 96An error has happened during application run. See exception log for details.