/* ============================================================
   Alternativ: JSON istəmirsənsə — adi cədvəl nəticələri.
   Hər sorğu (id, name) qaytarır. Hər nəticəni ayrıca kopyala.
   'lookup' sütunu hansı siyahı olduğunu göstərir.
   ============================================================ */
SELECT 'districts'        AS lookup, id, ad  AS name, region AS parentId FROM umumi.dbo.bolge        ORDER BY ad;
SELECT 'regions'          AS lookup, id, kod AS name FROM umumi.dbo.region       ORDER BY id;
SELECT 'destinations'     AS lookup, id, ad  AS name FROM umumi.dbo.teyinat      ORDER BY ad;
SELECT 'financeSources'   AS lookup, id, ad  AS name FROM mufettis.dbo.mm         ORDER BY id;
SELECT 'statuses'         AS lookup, id, ad  AS name FROM mufettis.dbo.veziyyet   ORDER BY id;
SELECT 'results'          AS lookup, id, ad  AS name FROM mufettis.dbo.Rey3       ORDER BY id;
SELECT 'conclusions'      AS lookup, id, ad  AS name FROM mufettis.dbo.netice     ORDER BY id;
SELECT 'registrationTypes' AS lookup, id, ad AS name FROM mufettis.dbo.qeydealma  ORDER BY id;
SELECT 'objectTypes'      AS lookup, id, ad  AS name FROM mufettis.dbo.obyekttip  ORDER BY id;
SELECT 'permitIssuers'    AS lookup, id, ad  AS name FROM mufettis.dbo.icazeveren ORDER BY id;
SELECT 'customerTypes'    AS lookup, id, ad  AS name FROM umumi.dbo.mustip        ORDER BY id;
SELECT DISTINCT 'dnjStatuses'    AS lookup, H.id, H.ad AS name FROM mufettis.dbo.osened O JOIN mufettis.dbo.osenedhal H ON H.id = O.hal WHERE O.sened = 14;
SELECT 'extractStatuses'  AS lookup, id, ad  AS name FROM mufettis.dbo.osenedhal WHERE id IN (1,2,3) ORDER BY id;
SELECT DISTINCT 'ownershipTypes' AS lookup, OwnershipTypeId AS id, OwnershipTypeName AS name FROM dbo.ViewInspectorObjects WHERE OwnershipTypeId IS NOT NULL;
