a:3:{s:9:"New Query";a:4:{s:11:"schema_name";s:8:"arisdros";s:5:"query";s:559:"SELECT 
    `A.The_Roles`.role_name AS Ρόλος,
    `A.The_Modules`.module_name AS Λειτουργία,
    CASE 
        WHEN `A.Connecting_Roles_to_Modules`.can_view = 1 THEN 'ΝΑΙ'
        ELSE 'ΟΧΙ'
    END AS Πρόσβαση
FROM `A.The_Roles`
JOIN `A.Connecting_Roles_to_Modules` 
    ON `A.The_Roles`.id = `A.Connecting_Roles_to_Modules`.role_id
JOIN `A.The_Modules` 
    ON `A.Connecting_Roles_to_Modules`.module_id = `A.The_Modules`.id
WHERE `A.The_Roles`.role_name = 'Management' 
AND `A.The_Modules`.module_name = 'Deliveries_Management';";s:9:"is_visual";b:1;s:6:"params";a:0:{}}s:36:"Has_management_access_to_Deliveries?";a:4:{s:11:"schema_name";s:8:"arisdros";s:5:"query";s:559:"SELECT 
    `A.The_Roles`.role_name AS Ρόλος,
    `A.The_Modules`.module_name AS Λειτουργία,
    CASE 
        WHEN `A.Connecting_Roles_to_Modules`.can_view = 1 THEN 'ΝΑΙ'
        ELSE 'ΟΧΙ'
    END AS Πρόσβαση
FROM `A.The_Roles`
JOIN `A.Connecting_Roles_to_Modules` 
    ON `A.The_Roles`.id = `A.Connecting_Roles_to_Modules`.role_id
JOIN `A.The_Modules` 
    ON `A.Connecting_Roles_to_Modules`.module_id = `A.The_Modules`.id
WHERE `A.The_Roles`.role_name = 'Management' 
AND `A.The_Modules`.module_name = 'Deliveries_Management';";s:9:"is_visual";b:1;s:6:"params";a:0:{}}s:13:"New Query (1)";a:4:{s:11:"schema_name";s:8:"arisdros";s:5:"query";s:711:"SELECT 
    &#x60;A.The_Roles&#x60;.role_name AS Role,
    &#x60;A.The_Modules&#x60;.module_name AS Module,
    CASE 
        WHEN &#x60;A.Connecting_Roles_to_Modules&#x60;.can_view &#x3D; 1 THEN &#39;NAI&#39;
        ELSE &#39;OXI&#39;
    END AS Access
FROM &#x60;A.The_Roles&#x60;
CROSS JOIN &#x60;A.The_Modules&#x60;
LEFT JOIN &#x60;A.Connecting_Roles_to_Modules&#x60; 
    ON &#x60;A.The_Roles&#x60;.id &#x3D; &#x60;A.Connecting_Roles_to_Modules&#x60;.role_id 
    AND &#x60;A.The_Modules&#x60;.id &#x3D; &#x60;A.Connecting_Roles_to_Modules&#x60;.module_id
WHERE &#x60;A.The_Roles&#x60;.role_name &#x3D; &#39;Management&#39; 
AND &#x60;A.The_Modules&#x60;.module_name &#x3D; &#39;Deliveries_Management&#39;";s:9:"is_visual";b:0;s:6:"params";N;}}