WHEN o.name REGEXP '^Mac ' THEN REPLACE(o.name,'Mac ','')
ELSE o.name END) AS oname
FROM `$table_item` c
- LEFT JOIN glpi_computers_items i ON (i.itemtype = 'Computer' AND i.items_id = c.id)
LEFT JOIN glpi_entities e ON (c.entities_id = e.id)
LEFT JOIN glpi_operatingsystems o ON (c.operatingsystems_id = o.id)
WHERE c.is_deleted = '0' AND c.is_template = '0'