1
select `labtech`.`vmcounter`.`CategoryName` AS `CategoryName`,`labtech`.`vmcounter`.`CounterName` AS `CounterName`,`labtech`.`vmcounter`.`Value` AS `Value`,`labtech`.`hvmconfig`.`HVHID` AS `HVHID`,`labtech`.`hvmconfig`.`HVMName` AS `HVMName` from (`labtech`.`vmcounter` left join `labtech`.`hvmconfig` on((`labtech`.`vmcounter`.`HVHId` = `labtech`.`hvmconfig`.`HVHID`))) where ((`labtech`.`vmcounter`.`CategoryName` like '%memory') and (`labtech`.`vmcounter`.`CounterName` like '%granted'))