SELECT `Machine`, `PinCode`, `OrgCity`, `ServiceCallId`, `Requirement_Location`, `varified`, `ProblemDescription`, `priceMin`, `priceMax`
FROM (`hire_requirements`)
WHERE `OrgState` NOT IN ('GUJARAT', 'TAMIL NADU', 'MAHARASHTRA', 'KARNATAKA', 'DELHI')
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 OTHERS
