[time] => 1.4869
    [rows] => 2
    [query] => SELECT
							pb.id,
							pb.name,
							TYP_KW_FROM as kw,
							TYP_HP_FROM as cp,
							TYP_CYLINDERS as cilindri,
							TYP_CCM as cc
						FROM
							product_brand as pb
						LEFT JOIN product_brand as children ON children.`left` >= pb.`left` AND children.`right` <= pb.`right` AND children.`left`+1 = children.`right`
						LEFT JOIN tof_link_la_typ as lpb ON lpb.LAT_TYP_ID = children.old_id
						LEFT JOIN tof_link_ga_str as lpc ON lpc.LGS_GA_ID = lpb.LAT_GA_ID
						LEFT JOIN tof_suppliers as producatori ON lpb.LAT_SUP_ID = producatori.SUP_ID
						LEFT JOIN tof_types ON tof_types.typ_id = pb.old_id
						WHERE
							pb.left > "39057"
							AND pb.right < "39202"
							AND pb.depth = "1"
							AND lpb.LAT_GA_ID != ""
							AND lpc.LGS_STR_ID = "10833" AND producatori.SUP_BRAND IN('ATE', 'AUTEC', 'BANNER', 'BOSAL', 'BOSCH', 'BREMBO', 'BRIDGESTONE', 'BTS', 'CARGO', 'CARTECHNIC', 'CASTROL', 'CHAMPION', 'CIFAM', 'CLEAN', 'CONTI', 'DAYCO', 'DEBICA', 'DELCO REMY', 'DELPHI', 'DENSO', 'DUNLOP', 'ELRING', 'EYQUEM', 'FACET', 'FAG', 'FEBI', 'FIRESTONE', 'FRAP', 'FULDA', 'GAIN', 'GATES', 'GEBE', 'GKN', 'GOODYEAR TIRES', 'GRAF', 'HAZET', 'HELLA', 'HEPU', 'HUCO', 'INA', 'INCO', 'JAKOPARTS', 'K+F', 'KAYABA', 'KILEN', 'KOLBENSCHMIDT', 'KRONPRINZ', 'LEMFOERDER', 'LUK', 'MAHLE', 'MAHLE FILTER', 'MANN-HUMMEL', 'MAPCO', 'MOBIL', 'MONARK', 'MONROE', 'MOTUL', 'NARVA', 'NGK', 'NISSENS', 'NRF', 'OPTIMAL', 'OSRAM', 'PHILIPS', 'PIERBURG', 'PIRELLI', 'PURFLUX', 'QWP', 'RUVILLE', 'SACHS', 'SAVA', 'SCHOTTLE', 'SIEMENS VDO', 'SIMER-ROYAL', 'SKF', 'SONAX', 'SWF', 'THULE', 'TRW', 'TYC', 'VALEO', 'VARTA', 'VERNET', 'VICTOR REINZ', 'WAHLER', 'WYNNS', 'YOKOHAMA')
						GROUP BY pb.id
						ORDER BY name