SELECT `Machine`, `PinCode`, `OrgCity`, `ServiceCallId`, `Requirement_Location`, `varified`, `ProblemDescription`, `priceMin`, `priceMax`
FROM (`hire_requirements`)
WHERE (OrgState='KARNATAKA' OR OrgCity like '%KARNATAKA%')
AND `varified` NOT IN ('onhold', 'expire')
AND `type` LIKE '%Turning %'
AND `ServiceCallId` LIKE '%H%'
ORDER BY `ServiceCallId` DESC
LIMIT 12
CNC Lathe- CNC Turning Center KARNATAKA
