$DB = Core_Database::getInstance(); $m_return = ''; //SELECT * FROM service WHERE parentid = 0 ORDER BY position ASC $folders = $DB -> getArray("SELECT s.* FROM service s LEFT JOIN service_pages p ON p.folderid=s.id WHERE s.parentid=0 GROUP BY p.folderid ORDER BY s.position ASC"); if (!empty($folders)) { $m_return .= '