Materiáis de Cons...
Eliminar Filtros
Filtro por Stock
Filtro por Preço
Filtro por Marca
    SELECT P.marca,count(1) qtd FROM produtos P WHERE P.pai IN (27619,134065,116111,56993,90952,30137,30141,90445,90273,92933,91057,92934,54020,130004,88102,91154,92940,92942,92943,88324,131770,58091,90287,88303,41583,52013,45168,90942,115912,132236,91116,90957,89069,124160,91477,90920,124348,124349,124157,124164,88993,88150,88992,91392,90272,91167,42128,56353,91219,89078,88049,91212,88122,91083,90956,56354,126924,121749,121756,121757,121758,89071,88250,91150,57219,90227,116096,53073,91328,90798,97256,89035,91071,116116,99291,131674,127647,114433,129906,99310,88356,116109,92461,90948,91123,88182,99274,99275,129905,90834,131678,90423,89160,102407,90989,130000,88247,114432,90368,90370,90316,99286,99304,89226,90821,130007,90413,123939,88319,130103,130008,88448,89258,99276,88874,99268,87868,99295,87977,87992,87993,87998,90186,90800,88041,88051,88053,88058,88126,90282,129462,91055,90950,90902,91019,89119,91020,91026,99235,89229,130009,116143,129626,90793,134064,129602,130113,129596,129611,134210,130093,129630,129598,129636,130104,129595,129612,129613,134211,130105,129645,127688,134212,129637,88177,88517,91474,127847,127845,92484,89973,104665,131139,90188,90862,130010,90320,115822,90369,116112,99236,90190,91029,92492,134421,134424,134422,134423,134420,121746,121494,121769,121636,121641,134419,129267,121578,132786,121890,121596,121633,121634,121664,128115,134408,121574,121573,130569,132080,134410,121587,134400,134397,127036,134402,134405,134401,134409,134407,134404,127044,121575,121565,134403,127048,134406,121593,134398,121597,134388,121600,134411,134386,121611,134387,121622,134389,121635,121637,134390,134391,121642,121645,121648,134393,134396,134416,129907,135016,121785,134414,132565,134413,134418,134415,134417,121603,121604,121607,121616,121621,121638,121651,121652,133067,133065,133068,133066) AND (marca='38840' OR marca='534' OR marca='24233' OR marca='25453' OR marca='15128' OR marca='6107' OR marca='11618' OR marca='15587' OR marca='18977' OR marca='33498' OR marca='8847' OR marca='37820' OR marca='10001' OR marca='12497' OR marca='33428' OR marca='38965' OR marca='1937' OR marca='50' OR marca='6052' OR marca='38873' OR marca='23684' OR marca='24193' OR marca='6069' OR marca='6540' OR marca='21710' OR marca='35526' OR marca='18021' OR marca='39369' OR marca='17794' OR marca='11318' OR marca='33531' OR marca='23542' OR marca='7824' OR marca='10295' OR marca='38657' OR marca='12690' OR marca='38780' OR marca='6496' OR marca='702' OR marca='27910' OR marca='17067' OR marca='12480' OR marca='8889' OR marca='10828' OR marca='8382' OR marca='8855' OR marca='1961' OR marca='6088' OR marca='23481' OR marca='14578' OR marca='2181' OR marca='18166' OR marca='6432' OR marca='34130' OR marca='5403' OR marca='12094' OR marca='17864' OR marca='38744' OR marca='7457' OR marca='21686' OR marca='34774' OR marca='31171' OR marca='8895' OR marca='8999' OR marca='38884' OR marca='22783' OR marca='33547' OR marca='19598' OR marca='28824' OR marca='33483' OR marca='18983' OR marca='3662' OR marca='6172' OR marca='17964' OR marca='12496' OR marca='14255' OR marca='39177' OR marca='36848' OR marca='8925' OR marca='15871' OR marca='17909' OR marca='23224' OR marca='24190' OR marca='38580' OR marca='6819' OR marca='4778' OR marca='6014' OR marca='2247' OR marca='4438' OR marca='1579' OR marca='4254' OR marca='38527' OR marca='1901' OR marca='22785' OR marca='10002' OR marca='33453' OR marca='38861' OR marca='18969' OR marca='6040' OR marca='13853' OR marca='24198' OR marca='11315' OR marca='3385' OR marca='8945' OR marca='24717' OR marca='3642' OR marca='25026' OR marca='7309' OR marca='18611' OR marca='38789' OR marca='25469' OR marca='15720' OR marca='38742' OR marca='31207' OR marca='38617' OR marca='8854' OR marca='33415' OR marca='18022' OR marca='25047' OR marca='38953' OR marca='37453' OR marca='21658' OR marca='6457' OR marca='3803' OR marca='39147' OR marca='7371' OR marca='1556' OR marca='19786' OR marca='36173' OR marca='790' OR marca='36646' OR marca='16069' OR marca='4115' OR marca='33504' OR marca='6472' OR marca='3750' OR marca='16908' OR marca='39307' OR marca='2839' OR marca='8927' OR marca='38863' OR marca='38860' OR marca='7787' OR marca='39279' OR marca='39387' OR marca='19178' OR marca='19118' OR marca='1601' OR marca='12194' OR marca='33440' OR marca='6825' OR marca='6029' OR marca='3724' OR marca='38903' OR marca='14548' OR marca='19336' OR marca='14739' OR marca='16062' OR marca='372' OR marca='33552' OR marca='39167' OR marca='18612' OR marca='2842' OR marca='6108' OR marca='24223' OR marca='33410' OR marca='28510' OR marca='6121' OR marca='38970' OR marca='38833' OR marca='33495' OR marca='6465' OR marca='24831' OR marca='9497' OR marca='19007' OR marca='35668' OR marca='39120' OR marca='3777' OR marca='686' OR marca='10922' OR marca='38883' OR marca='1558' OR marca='24969' OR marca='38984' OR marca='6446' OR marca='11623' OR marca='17911' OR marca='32815' OR marca='14842' OR marca='3628' OR marca='18618' OR marca='33837' OR marca='1658' OR marca='6112' OR marca='25432' OR marca='38733' OR marca='17946' OR marca='39320' OR marca='39367' OR marca='23685' OR marca='37692' OR marca='33482' OR marca='7488' OR marca='787' OR marca='23225' OR marca='35293' OR marca='39166' OR marca='26548' OR marca='24201' OR marca='7928' OR marca='33427' OR marca='39156' OR marca='2985' OR marca='9923' OR marca='38005' OR marca='38318' OR marca='8160' OR marca='38834' OR marca='2491' OR marca='6497' OR marca='38667' OR marca='10321' OR marca='28023' OR marca='14505' OR marca='24999' OR marca='14736' OR marca='36954' OR marca='7593' OR marca='12688' OR marca='1476' OR marca='38831' OR marca='8429' OR marca='39346' OR marca='4451' OR marca='33418' OR marca='26869' OR marca='39135' OR marca='12767' OR marca='23647' OR marca='21601' OR marca='21306' OR marca='3593' OR marca='27915' OR marca='33421' OR marca='6076' OR marca='7051' OR marca='7482' OR marca='17633' OR marca='78' OR marca='12356' OR marca='7485' OR marca='39405' OR marca='9501' OR marca='38778' OR marca='1652' OR marca='39202' OR marca='33369' OR marca='2734' OR marca='100' OR marca='24617' OR marca='81' OR marca='19785' OR marca='16070' OR marca='37443' OR marca='25551' OR marca='5959' OR marca='24616' OR marca='38666' OR marca='17962' OR marca='24508' OR marca='4435' OR marca='2830' OR marca='6103' OR marca='3589' OR marca='3716' OR marca='34969' OR marca='31616' OR marca='38401' OR marca='12678' OR marca='24191' OR marca='661' OR marca='3734' OR marca='1752' OR marca='39230' OR marca='22697' OR marca='38950' OR marca='39115' OR marca='19184' OR marca='38661' OR marca='33532' OR marca='6129' OR marca='6025' OR marca='39169' OR marca='24192' OR marca='17281' OR marca='19374' OR marca='16631' OR marca='6144' OR marca='18' OR marca='12459' OR marca='7483' OR marca='17948' OR marca='17965' OR marca='39234' OR marca='15101' OR marca='38751' OR marca='33541' OR marca='3618' OR marca='33420' OR marca='9508' OR marca='39065' OR marca='8856' OR marca='5871' OR marca='16067' OR marca='6341' OR marca='6964' OR marca='35151' OR marca='1712' OR marca='28739' OR marca='38916' OR marca='25558' OR marca='6094' OR marca='27638' OR marca='6506' OR marca='33361' OR marca='33463' OR marca='6711' OR marca='1904' OR marca='35460' OR marca='6066' OR marca='1620' OR marca='33462' OR marca='17400' OR marca='6111' OR marca='15520' OR marca='17670' OR marca='39072' OR marca='3740' OR marca='12215' OR marca='18621' OR marca='647' OR marca='38862' OR marca='24968' OR marca='18988' OR marca='14206' OR marca='12229' OR marca='10846' OR marca='37672' OR marca='1' OR marca='2875' OR marca='734' OR marca='381' OR marca='12310' OR marca='39560' OR marca='25057' OR marca='17640' OR marca='28808' OR marca='2934' OR marca='6002' OR marca='24638' OR marca='6717' OR marca='4261' OR marca='39331' OR marca='20347' OR marca='1459' OR marca='14294' OR marca='14579' OR marca='7481' OR marca='15043' OR marca='7341' OR marca='39155' OR marca='11331' OR marca='27052' OR marca='25124' OR marca='16754' ) GROUP BY P.marca