Symfony Profiler

SELECT
  DISTINCT s0_.metai AS metai_0
FROM
  statistic_gimimai_mirimai s0_
ORDER BY
  s0_.metai DESC

SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_gimimai_mirimai s0_ ORDER BY s0_.metai DESC;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.metai AS metai_2,
  s0_.menuo AS menuo_3,
  s0_.gimusiu_berniuku AS gimusiu_berniuku_4,
  s0_.gimusiu_mergaiciu AS gimusiu_mergaiciu_5,
  s0_.gimusiu_is_viso AS gimusiu_is_viso_6,
  s0_.uzsienyje_gime_vaikai AS uzsienyje_gime_vaikai_7,
  s0_.ivaikinta AS ivaikinta_8,
  s0_.mirusiu_moteru AS mirusiu_moteru_9,
  s0_.mirusiu_vyru AS mirusiu_vyru_10,
  s0_.mirusiu_is_viso AS mirusiu_is_viso_11,
  s0_.populiariausi_vardai AS populiariausi_vardai_12,
  s0_.savivaldybe AS savivaldybe_13
FROM
  statistic_gimimai_mirimai s0_
WHERE
  s0_.metai = ?
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.metai AS metai_2, s0_.menuo AS menuo_3, s0_.gimusiu_berniuku AS gimusiu_berniuku_4, s0_.gimusiu_mergaiciu AS gimusiu_mergaiciu_5, s0_.gimusiu_is_viso AS gimusiu_is_viso_6, s0_.uzsienyje_gime_vaikai AS uzsienyje_gime_vaikai_7, s0_.ivaikinta AS ivaikinta_8, s0_.mirusiu_moteru AS mirusiu_moteru_9, s0_.mirusiu_vyru AS mirusiu_vyru_10, s0_.mirusiu_is_viso AS mirusiu_is_viso_11, s0_.populiariausi_vardai AS populiariausi_vardai_12, s0_.savivaldybe AS savivaldybe_13 FROM statistic_gimimai_mirimai s0_ WHERE s0_.metai = 2023 ORDER BY s0_.id ASC;

SELECT
  DISTINCT s0_.dek_metai AS dek_metai_0
FROM
  statistic_amzius_lytis_pilietybe s0_
WHERE
  s0_.dek_metai IS NOT NULL
ORDER BY
  s0_.dek_metai DESC

SELECT DISTINCT s0_.dek_metai AS dek_metai_0 FROM statistic_amzius_lytis_pilietybe s0_ WHERE s0_.dek_metai IS NOT NULL ORDER BY s0_.dek_metai DESC;

SELECT
  DISTINCT s0_.dek_ketvirtis AS dek_ketvirtis_0
FROM
  statistic_amzius_lytis_pilietybe s0_
WHERE
  s0_.dek_ketvirtis IS NOT NULL
  AND s0_.dek_metai = ?
ORDER BY
  s0_.dek_ketvirtis ASC

SELECT DISTINCT s0_.dek_ketvirtis AS dek_ketvirtis_0 FROM statistic_amzius_lytis_pilietybe s0_ WHERE s0_.dek_ketvirtis IS NOT NULL AND s0_.dek_metai = 2025 ORDER BY s0_.dek_ketvirtis ASC;

SELECT
  s0_.id AS id_0,
  s0_.nr AS nr_1,
  s0_.lytis AS lytis_2,
  s0_.amzius AS amzius_3,
  s0_.pilietybe AS pilietybe_4,
  s0_.dek_ketvirtis AS dek_ketvirtis_5,
  s0_.dek_metai AS dek_metai_6,
  s0_.savivaldybe AS savivaldybe_7,
  l1_.pavadinimas AS pavadinimas_8
FROM
  statistic_amzius_lytis_pilietybe s0_
  LEFT JOIN list_lithuania_savivaldybe l1_ ON (s0_.savivaldybe = l1_.uuid)
WHERE
  s0_.dek_metai = ?
  AND s0_.dek_ketvirtis = ?

SELECT s0_.id AS id_0, s0_.nr AS nr_1, s0_.lytis AS lytis_2, s0_.amzius AS amzius_3, s0_.pilietybe AS pilietybe_4, s0_.dek_ketvirtis AS dek_ketvirtis_5, s0_.dek_metai AS dek_metai_6, s0_.savivaldybe AS savivaldybe_7, l1_.pavadinimas AS pavadinimas_8 FROM statistic_amzius_lytis_pilietybe s0_ LEFT JOIN list_lithuania_savivaldybe l1_ ON (s0_.savivaldybe = l1_.uuid) WHERE s0_.dek_metai = 2025 AND s0_.dek_ketvirtis = 'K1';

SELECT
  DISTINCT s0_.metai AS metai_0
FROM
  statistic_absolventu_skaicius_pagal_sritis s0_
ORDER BY
  s0_.metai DESC

SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_absolventu_skaicius_pagal_sritis s0_ ORDER BY s0_.metai DESC;

SELECT
  s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0,
  s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1,
  SUM(s0_.absolventu_skaicius) AS sclr_2
FROM
  statistic_absolventu_skaicius_pagal_sritis s0_
WHERE
  s0_.metai = ?
GROUP BY
  s0_.padalinio_savivaldybe,
  s0_.padalinio_savivaldybes_id
ORDER BY
  sclr_2 DESC

SELECT s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0, s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1, SUM(s0_.absolventu_skaicius) AS sclr_2 FROM statistic_absolventu_skaicius_pagal_sritis s0_ WHERE s0_.metai = 2026 GROUP BY s0_.padalinio_savivaldybe, s0_.padalinio_savivaldybes_id ORDER BY sclr_2 DESC;

SELECT
  s0_.studiju_kryptis AS studiju_kryptis_0,
  s0_.studiju_pakopa AS studiju_pakopa_1,
  s0_.dirbo_mokslo_metu_eigoje AS dirbo_mokslo_metu_eigoje_2,
  SUM(s0_.absolventu_skaicius) AS sclr_3
FROM
  statistic_absolventu_skaicius_pagal_sritis s0_
WHERE
  s0_.metai = ?
GROUP BY
  s0_.studiju_kryptis,
  s0_.studiju_pakopa,
  s0_.dirbo_mokslo_metu_eigoje
ORDER BY
  sclr_3 DESC

SELECT s0_.studiju_kryptis AS studiju_kryptis_0, s0_.studiju_pakopa AS studiju_pakopa_1, s0_.dirbo_mokslo_metu_eigoje AS dirbo_mokslo_metu_eigoje_2, SUM(s0_.absolventu_skaicius) AS sclr_3 FROM statistic_absolventu_skaicius_pagal_sritis s0_ WHERE s0_.metai = 2026 GROUP BY s0_.studiju_kryptis, s0_.studiju_pakopa, s0_.dirbo_mokslo_metu_eigoje ORDER BY sclr_3 DESC;

SELECT
  DISTINCT s0_.mokslo_metai AS mokslo_metai_0
FROM
  statistic_priimtu_studijuoti_skaicius s0_
ORDER BY
  s0_.mokslo_metai DESC

SELECT DISTINCT s0_.mokslo_metai AS mokslo_metai_0 FROM statistic_priimtu_studijuoti_skaicius s0_ ORDER BY s0_.mokslo_metai DESC;

SELECT
  s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0,
  s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1,
  SUM(s0_.priimtuju_skaicius) AS sclr_2
FROM
  statistic_priimtu_studijuoti_skaicius s0_
WHERE
  s0_.mokslo_metai = ?
GROUP BY
  s0_.padalinio_savivaldybe,
  s0_.padalinio_savivaldybes_id
ORDER BY
  sclr_2 DESC

SELECT s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0, s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1, SUM(s0_.priimtuju_skaicius) AS sclr_2 FROM statistic_priimtu_studijuoti_skaicius s0_ WHERE s0_.mokslo_metai = 'ST Mokslo metai' GROUP BY s0_.padalinio_savivaldybe, s0_.padalinio_savivaldybes_id ORDER BY sclr_2 DESC;

SELECT
  s0_.studiju_kryptis AS studiju_kryptis_0,
  s0_.studiju_pakopa AS studiju_pakopa_1,
  s0_.dirbo_mokslo_metu_eigoje AS dirbo_mokslo_metu_eigoje_2,
  SUM(s0_.priimtuju_skaicius) AS sclr_3
FROM
  statistic_priimtu_studijuoti_skaicius s0_
WHERE
  s0_.mokslo_metai = ?
GROUP BY
  s0_.studiju_kryptis,
  s0_.studiju_pakopa,
  s0_.dirbo_mokslo_metu_eigoje
ORDER BY
  sclr_3 DESC

SELECT s0_.studiju_kryptis AS studiju_kryptis_0, s0_.studiju_pakopa AS studiju_pakopa_1, s0_.dirbo_mokslo_metu_eigoje AS dirbo_mokslo_metu_eigoje_2, SUM(s0_.priimtuju_skaicius) AS sclr_3 FROM statistic_priimtu_studijuoti_skaicius s0_ WHERE s0_.mokslo_metai = 'ST Mokslo metai' GROUP BY s0_.studiju_kryptis, s0_.studiju_pakopa, s0_.dirbo_mokslo_metu_eigoje ORDER BY sclr_3 DESC;

SELECT
  DISTINCT s0_.metai AS metai_0
FROM
  statistic_gyventoju_pajamos_pagal_savivaldybe s0_
WHERE
  s0_.metai IS NOT NULL
ORDER BY
  s0_.metai DESC

SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_gyventoju_pajamos_pagal_savivaldybe s0_ WHERE s0_.metai IS NOT NULL ORDER BY s0_.metai DESC;

SELECT
  s0_.sav_pavadinimas AS sav_pavadinimas_0,
  s0_.sav_kodas AS sav_kodas_1,
  SUM(s0_.suma) AS sclr_2
FROM
  statistic_gyventoju_pajamos_pagal_savivaldybe s0_
WHERE
  s0_.metai = ?
GROUP BY
  s0_.sav_pavadinimas,
  s0_.sav_kodas
ORDER BY
  sclr_2 DESC

SELECT s0_.sav_pavadinimas AS sav_pavadinimas_0, s0_.sav_kodas AS sav_kodas_1, SUM(s0_.suma) AS sclr_2 FROM statistic_gyventoju_pajamos_pagal_savivaldybe s0_ WHERE s0_.metai = 2023 GROUP BY s0_.sav_pavadinimas, s0_.sav_kodas ORDER BY sclr_2 DESC;

SELECT
  s0_.kodas_gpmi AS kodas_gpmi_0,
  s0_.kodas AS kodas_1,
  s0_.aprasas AS aprasas_2,
  s0_.lytis AS lytis_3,
  SUM(s0_.suma) AS sclr_4
FROM
  statistic_gyventoju_pajamos_pagal_savivaldybe s0_
WHERE
  s0_.metai = ?
GROUP BY
  s0_.kodas_gpmi,
  s0_.kodas,
  s0_.aprasas,
  s0_.lytis
ORDER BY
  sclr_4 DESC

SELECT s0_.kodas_gpmi AS kodas_gpmi_0, s0_.kodas AS kodas_1, s0_.aprasas AS aprasas_2, s0_.lytis AS lytis_3, SUM(s0_.suma) AS sclr_4 FROM statistic_gyventoju_pajamos_pagal_savivaldybe s0_ WHERE s0_.metai = 2023 GROUP BY s0_.kodas_gpmi, s0_.kodas, s0_.aprasas, s0_.lytis ORDER BY sclr_4 DESC;

SELECT
  t0.id AS id_1,
  t0.juridinio_asmens_kodas AS juridinio_asmens_kodas_2,
  t0.pavadinimas AS pavadinimas_3,
  t0.buveines_adresas AS buveines_adresas_4,
  t0.iregistravimo_data AS iregistravimo_data_5,
  t0.isregistravimo_data AS isregistravimo_data_6,
  t0.teisine_forma AS teisine_forma_7,
  t0.teinis_statusas AS teinis_statusas_8,
  t0.teinis_statusas_nuo AS teinis_statusas_nuo_9,
  t0.valstybes_pripazinimas AS valstybes_pripazinimas_10,
  t0.religine_kryptis AS religine_kryptis_11
FROM
  statistic_religiniu_bendruomeniu_sarasas t0

SELECT t0.id AS id_1, t0.juridinio_asmens_kodas AS juridinio_asmens_kodas_2, t0.pavadinimas AS pavadinimas_3, t0.buveines_adresas AS buveines_adresas_4, t0.iregistravimo_data AS iregistravimo_data_5, t0.isregistravimo_data AS isregistravimo_data_6, t0.teisine_forma AS teisine_forma_7, t0.teinis_statusas AS teinis_statusas_8, t0.teinis_statusas_nuo AS teinis_statusas_nuo_9, t0.valstybes_pripazinimas AS valstybes_pripazinimas_10, t0.religine_kryptis AS religine_kryptis_11 FROM statistic_religiniu_bendruomeniu_sarasas t0;

SELECT
  t0.id AS id_1,
  t0.juridinio_asmens_kodas AS juridinio_asmens_kodas_2,
  t0.pavadinimas AS pavadinimas_3,
  t0.buveines_adresas AS buveines_adresas_4,
  t0.iregistravimo_data AS iregistravimo_data_5,
  t0.isregistravimo_data AS isregistravimo_data_6,
  t0.teisine_forma AS teisine_forma_7,
  t0.teinis_statusas AS teinis_statusas_8,
  t0.teinis_statusas_nuo AS teinis_statusas_nuo_9,
  t0.valstybes_pripazinimas AS valstybes_pripazinimas_10,
  t0.religine_kryptis AS religine_kryptis_11
FROM
  statistic_religiniu_bendruomeniu_sarasas t0
ORDER BY
  t0.pavadinimas ASC

SELECT t0.id AS id_1, t0.juridinio_asmens_kodas AS juridinio_asmens_kodas_2, t0.pavadinimas AS pavadinimas_3, t0.buveines_adresas AS buveines_adresas_4, t0.iregistravimo_data AS iregistravimo_data_5, t0.isregistravimo_data AS isregistravimo_data_6, t0.teisine_forma AS teisine_forma_7, t0.teinis_statusas AS teinis_statusas_8, t0.teinis_statusas_nuo AS teinis_statusas_nuo_9, t0.valstybes_pripazinimas AS valstybes_pripazinimas_10, t0.religine_kryptis AS religine_kryptis_11 FROM statistic_religiniu_bendruomeniu_sarasas t0 ORDER BY t0.pavadinimas ASC;

SELECT
  DISTINCT s0_.religine_kryptis AS religine_kryptis_0
FROM
  statistic_religiniu_bendruomeniu_sarasas s0_
ORDER BY
  s0_.religine_kryptis ASC

SELECT DISTINCT s0_.religine_kryptis AS religine_kryptis_0 FROM statistic_religiniu_bendruomeniu_sarasas s0_ ORDER BY s0_.religine_kryptis ASC;

SELECT
  DISTINCT s0_.metai AS metai_0
FROM
  statistic_gyventoju_isduotu_verslo_liudijimu s0_
WHERE
  s0_.metai IS NOT NULL
ORDER BY
  s0_.metai DESC

SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_gyventoju_isduotu_verslo_liudijimu s0_ WHERE s0_.metai IS NOT NULL ORDER BY s0_.metai DESC;

SELECT
  s0_.savivaldybe AS savivaldybe_0,
  COUNT(s0_.id) AS sclr_1
FROM
  statistic_gyventoju_isduotu_verslo_liudijimu s0_
WHERE
  s0_.savivaldybe IS NOT NULL
  AND s0_.metai = ?
GROUP BY
  s0_.savivaldybe
ORDER BY
  sclr_1 DESC

SELECT s0_.savivaldybe AS savivaldybe_0, COUNT(s0_.id) AS sclr_1 FROM statistic_gyventoju_isduotu_verslo_liudijimu s0_ WHERE s0_.savivaldybe IS NOT NULL AND s0_.metai = 2026 GROUP BY s0_.savivaldybe ORDER BY sclr_1 DESC;

SELECT
  s0_.rusies_kodas AS rusies_kodas_0,
  s0_.rusis_pavadinimas AS rusis_pavadinimas_1,
  s0_.veiklos_tipas AS veiklos_tipas_2,
  COUNT(s0_.id) AS sclr_3
FROM
  statistic_gyventoju_isduotu_verslo_liudijimu s0_
WHERE
  s0_.metai = ?
GROUP BY
  s0_.rusies_kodas,
  s0_.rusis_pavadinimas,
  s0_.veiklos_tipas
ORDER BY
  sclr_3 DESC

SELECT s0_.rusies_kodas AS rusies_kodas_0, s0_.rusis_pavadinimas AS rusis_pavadinimas_1, s0_.veiklos_tipas AS veiklos_tipas_2, COUNT(s0_.id) AS sclr_3 FROM statistic_gyventoju_isduotu_verslo_liudijimu s0_ WHERE s0_.metai = 2026 GROUP BY s0_.rusies_kodas, s0_.rusis_pavadinimas, s0_.veiklos_tipas ORDER BY sclr_3 DESC;

SELECT
  DISTINCT s0_.metai AS metai_0
FROM
  statistic_vykdancius_individualia_veikla s0_
WHERE
  s0_.metai IS NOT NULL
ORDER BY
  s0_.metai DESC

SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_vykdancius_individualia_veikla s0_ WHERE s0_.metai IS NOT NULL ORDER BY s0_.metai DESC;

SELECT
  s0_.savivaldybe AS savivaldybe_0,
  COUNT(s0_.id) AS sclr_1
FROM
  statistic_vykdancius_individualia_veikla s0_
WHERE
  s0_.savivaldybe IS NOT NULL
  AND s0_.metai = ?
GROUP BY
  s0_.savivaldybe
ORDER BY
  sclr_1 DESC

SELECT s0_.savivaldybe AS savivaldybe_0, COUNT(s0_.id) AS sclr_1 FROM statistic_vykdancius_individualia_veikla s0_ WHERE s0_.savivaldybe IS NOT NULL AND s0_.metai = 2025 GROUP BY s0_.savivaldybe ORDER BY sclr_1 DESC;

SELECT
  s0_.veiklos_tipas AS veiklos_tipas_0,
  s0_.moketojas AS moketojas_1,
  COUNT(s0_.id) AS sclr_2
FROM
  statistic_vykdancius_individualia_veikla s0_
WHERE
  s0_.metai = ?
GROUP BY
  s0_.veiklos_tipas,
  s0_.moketojas
ORDER BY
  sclr_2 DESC

SELECT s0_.veiklos_tipas AS veiklos_tipas_0, s0_.moketojas AS moketojas_1, COUNT(s0_.id) AS sclr_2 FROM statistic_vykdancius_individualia_veikla s0_ WHERE s0_.metai = 2025 GROUP BY s0_.veiklos_tipas, s0_.moketojas ORDER BY sclr_2 DESC;

SELECT
  DISTINCT s0_.istaigru_grupe AS istaigru_grupe_0
FROM
  statistic_valstybines_istaigos s0_
WHERE
  s0_.istaigru_grupe IS NOT NULL
ORDER BY
  s0_.istaigru_grupe ASC

SELECT DISTINCT s0_.istaigru_grupe AS istaigru_grupe_0 FROM statistic_valstybines_istaigos s0_ WHERE s0_.istaigru_grupe IS NOT NULL ORDER BY s0_.istaigru_grupe ASC;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.revision AS revision_2,
  s0_.istaigos_id AS istaigos_id_3,
  s0_.pavaldumas_id AS pavaldumas_id_4,
  s0_.jar_kodas AS jar_kodas_5,
  s0_.pavadinimas AS pavadinimas_6,
  s0_.sutrumintas_pavadinimas AS sutrumintas_pavadinimas_7,
  s0_.istaigru_grupe AS istaigru_grupe_8,
  s0_.adresas AS adresas_9,
  s0_.web AS web_10,
  s0_.el_pastas AS el_pastas_11,
  s0_.isteigta AS isteigta_12,
  s0_.atnaujinimas AS atnaujinimas_13
FROM
  statistic_valstybines_istaigos s0_
ORDER BY
  s0_.pavadinimas ASC

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.istaigos_id AS istaigos_id_3, s0_.pavaldumas_id AS pavaldumas_id_4, s0_.jar_kodas AS jar_kodas_5, s0_.pavadinimas AS pavadinimas_6, s0_.sutrumintas_pavadinimas AS sutrumintas_pavadinimas_7, s0_.istaigru_grupe AS istaigru_grupe_8, s0_.adresas AS adresas_9, s0_.web AS web_10, s0_.el_pastas AS el_pastas_11, s0_.isteigta AS isteigta_12, s0_.atnaujinimas AS atnaujinimas_13 FROM statistic_valstybines_istaigos s0_ ORDER BY s0_.pavadinimas ASC;

SELECT
  s0_.rinkimu_id AS rinkimu_id_0,
  s0_.rinkimu_pavadinimas AS rinkimu_pavadinimas_1
FROM
  statistic_politines_kampanijos_reklama s0_
WHERE
  s0_.rinkimu_id IS NOT NULL
GROUP BY
  s0_.rinkimu_id,
  s0_.rinkimu_pavadinimas
ORDER BY
  s0_.rinkimu_id DESC

SELECT s0_.rinkimu_id AS rinkimu_id_0, s0_.rinkimu_pavadinimas AS rinkimu_pavadinimas_1 FROM statistic_politines_kampanijos_reklama s0_ WHERE s0_.rinkimu_id IS NOT NULL GROUP BY s0_.rinkimu_id, s0_.rinkimu_pavadinimas ORDER BY s0_.rinkimu_id DESC;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.revision AS revision_2,
  s0_.reklamos_id AS reklamos_id_3,
  s0_.rinkimu_id AS rinkimu_id_4,
  s0_.rinkimu_pavadinimas AS rinkimu_pavadinimas_5,
  s0_.p_kamp_dal_pavadinimas AS p_kamp_dal_pavadinimas_6,
  s0_.p_kamp_dal_vardas AS p_kamp_dal_vardas_7,
  s0_.dal_tipo_kodas AS dal_tipo_kodas_8,
  s0_.dal_tipas AS dal_tipas_9,
  s0_.virs_ja_kodas AS virs_ja_kodas_10,
  s0_.virs_pavadinimas AS virs_pavadinimas_11,
  s0_.virs_tipo_pavadinimas AS virs_tipo_pavadinimas_12,
  s0_.reklamos_data_nuo AS reklamos_data_nuo_13,
  s0_.reklamos_data_iki AS reklamos_data_iki_14,
  s0_.reklamos_forma AS reklamos_forma_15,
  s0_.reklamos_kaina AS reklamos_kaina_16,
  s0_.islaidu_paskirtis AS islaidu_paskirtis_17,
  s0_.org_pavadinimas AS org_pavadinimas_18
FROM
  statistic_politines_kampanijos_reklama s0_
ORDER BY
  s0_.p_kamp_dal_pavadinimas ASC

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.reklamos_id AS reklamos_id_3, s0_.rinkimu_id AS rinkimu_id_4, s0_.rinkimu_pavadinimas AS rinkimu_pavadinimas_5, s0_.p_kamp_dal_pavadinimas AS p_kamp_dal_pavadinimas_6, s0_.p_kamp_dal_vardas AS p_kamp_dal_vardas_7, s0_.dal_tipo_kodas AS dal_tipo_kodas_8, s0_.dal_tipas AS dal_tipas_9, s0_.virs_ja_kodas AS virs_ja_kodas_10, s0_.virs_pavadinimas AS virs_pavadinimas_11, s0_.virs_tipo_pavadinimas AS virs_tipo_pavadinimas_12, s0_.reklamos_data_nuo AS reklamos_data_nuo_13, s0_.reklamos_data_iki AS reklamos_data_iki_14, s0_.reklamos_forma AS reklamos_forma_15, s0_.reklamos_kaina AS reklamos_kaina_16, s0_.islaidu_paskirtis AS islaidu_paskirtis_17, s0_.org_pavadinimas AS org_pavadinimas_18 FROM statistic_politines_kampanijos_reklama s0_ ORDER BY s0_.p_kamp_dal_pavadinimas ASC;

SELECT
  s0_.rinkimu_id AS rinkimu_id_0,
  s0_.rink_pavadinimas AS rink_pavadinimas_1
FROM
  statistic_politines_kompanijos_pajamos s0_
WHERE
  s0_.rinkimu_id IS NOT NULL
GROUP BY
  s0_.rinkimu_id,
  s0_.rink_pavadinimas
ORDER BY
  s0_.rinkimu_id DESC

SELECT s0_.rinkimu_id AS rinkimu_id_0, s0_.rink_pavadinimas AS rink_pavadinimas_1 FROM statistic_politines_kompanijos_pajamos s0_ WHERE s0_.rinkimu_id IS NOT NULL GROUP BY s0_.rinkimu_id, s0_.rink_pavadinimas ORDER BY s0_.rinkimu_id DESC;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.revision AS revision_2,
  s0_.pajamu_id AS pajamu_id_3,
  s0_.rinkimu_id AS rinkimu_id_4,
  s0_.rink_pavadinimas AS rink_pavadinimas_5,
  s0_.p_kamp_dal_pavadinimas AS p_kamp_dal_pavadinimas_6,
  s0_.p_kamp_dal_id AS p_kamp_dal_id_7,
  s0_.auk_tipas AS auk_tipas_8,
  s0_.suma AS suma_9,
  s0_.auk_ja_kodas AS auk_ja_kodas_10,
  s0_.auk_ja_pavadinimas AS auk_ja_pavadinimas_11,
  s0_.lytis AS lytis_12,
  s0_.amziaus_grupe AS amziaus_grupe_13,
  s0_.lesu_saltinio_kodas AS lesu_saltinio_kodas_14,
  s0_.lesu_saltinis AS lesu_saltinis_15,
  s0_.paj_dok_data AS paj_dok_data_16,
  s0_.lesu_forma AS lesu_forma_17,
  s0_.dal_tipo_kodas AS dal_tipo_kodas_18,
  s0_.dal_tipas AS dal_tipas_19,
  s0_.dal_reg_busena AS dal_reg_busena_20
FROM
  statistic_politines_kompanijos_pajamos s0_
ORDER BY
  s0_.p_kamp_dal_pavadinimas ASC

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.pajamu_id AS pajamu_id_3, s0_.rinkimu_id AS rinkimu_id_4, s0_.rink_pavadinimas AS rink_pavadinimas_5, s0_.p_kamp_dal_pavadinimas AS p_kamp_dal_pavadinimas_6, s0_.p_kamp_dal_id AS p_kamp_dal_id_7, s0_.auk_tipas AS auk_tipas_8, s0_.suma AS suma_9, s0_.auk_ja_kodas AS auk_ja_kodas_10, s0_.auk_ja_pavadinimas AS auk_ja_pavadinimas_11, s0_.lytis AS lytis_12, s0_.amziaus_grupe AS amziaus_grupe_13, s0_.lesu_saltinio_kodas AS lesu_saltinio_kodas_14, s0_.lesu_saltinis AS lesu_saltinis_15, s0_.paj_dok_data AS paj_dok_data_16, s0_.lesu_forma AS lesu_forma_17, s0_.dal_tipo_kodas AS dal_tipo_kodas_18, s0_.dal_tipas AS dal_tipas_19, s0_.dal_reg_busena AS dal_reg_busena_20 FROM statistic_politines_kompanijos_pajamos s0_ ORDER BY s0_.p_kamp_dal_pavadinimas ASC;