Sadržaj

Svi članovi

SELECT clanarina.clanarina_id, clan.ime_prezime, clan.clanski_broj, clan.kontakt_broj, clan.napomena, clanarina.datum_pocetka, clanarina.datum_isteka, paketi.naziv AS paket_naziv FROM ( SELECT c.*, ROW_NUMBER() OVER (PARTITION BY c.clanarina_clan_id ORDER BY c.datum_isteka DESC) AS row_num FROM clanarina c ) AS clanarina JOIN clan ON clanarina.clanarina_clan_id = clan.clan_id JOIN paketi ON clanarina.clanarina_paketi_id = paketi.paketi_id WHERE clanarina.row_num = 1 AND clan.clan_lokacija_id = 1 AND clan.clan_udruga_id = 5;

Aktivne Članarine

SELECT clan.ime_prezime, clan.clanski_broj, clan.kontakt_broj, clan.napomena, clanarina.datum_pocetka, clanarina.datum_isteka, paketi.naziv AS paket_naziv FROM ( SELECT c.*, ROW_NUMBER() OVER (PARTITION BY c.clanarina_clan_id ORDER BY c.datum_isteka DESC) AS row_num FROM clanarina c WHERE c.clanarina_status_id = 1 AND c.datum_isteka > CURDATE() ) AS clanarina JOIN clan ON clanarina.clanarina_clan_id = clan.clan_id JOIN paketi ON clanarina.clanarina_paketi_id = paketi.paketi_id WHERE clanarina.row_num = 1 AND clan.clan_lokacija_id = 1 AND clan.clan_udruga_id = 5;