Galerija

imageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimage

NATJEČAJI I JAVNI POZIVI

 

 

JAVNI POZIV ZA FINANCIRANJE UDRUGA I DRUGIH NEPROFITNIH ORGANIZACIJA  IZ PRORAČUNA OPĆINE KRAVARSKO ZA 2020. GODINU

 

Javni poziv objavljen je 07.02.2020. i biti će otvoren do 30.11.2020. ili do iskorištenja sredstava. Za sve informacije možete se obratiti na e-mail: Ova e-mail adresa je zaštićena od spambota. Potrebno je omogućiti JavaScript da je vidite. ili na broj telefona 6237 022.


U nastavku možete preuzeti tekst poziva, upute i obrasce:

Javni poziv

Upute za prijavitelje

Obrazac opisa programa/projekta

Obrazac proračuna programa/projekta

Obrazac izjave o nekažnjavanju

Obrazac izjave o nepostojanju dvostrukog financiranja

Obrazac izjave da je Statut usklađen sa Zakonom o udrugama

Obrazac za procjenu kvalitete prijave

Obrazac Ugovora

Opći uvjeti Ugovora

Obrazac opisnog izvještaja provedbe programa/projekta

Obrazac financijskog izvještaja provedbe programa/projekta

Obrazac zahtjeva za isplatu sredstava


 

 

 

 

JAVNI POZIV ZA FINANCIRANJE UDRUGA I DRUGIH NEPROFITNIH ORGANIZACIJA  IZ PRORAČUNA OPĆINE KRAVARSKO ZA 2019. GODINU

 

Dodijeljena bespovratna sredstva temeljem Javnog poziva za dodjelu financijske potpore programima/projektima udruga i drugih neprofitnih organizacija iz Proračuna Općina Kravarsko za 2019. godinu

 

 

Javni poziv objavljen je 01.02.2019. i biti će otvoren do 30.11.2019. ili do iskorištenja sredstava. Za sve informacije možete se obratiti na e-mail: Ova e-mail adresa je zaštićena od spambota. Potrebno je omogućiti JavaScript da je vidite. ili na broj telefona 6237 022.


U nastavku možete preuzeti tekst poziva, upute i obrasce:

Javni poziv

Upute za prijavitelje

Obrazac opisa programa/projekta

Obrazac proračuna programa/projekta

Obrazac izjave o nekažnjavanju

Obrazac izjave o nepostojanju dvostrukog financiranja

Obrazac izjave da je Statut usklađen sa Zakonom o udrugama

Obrazac za procjenu kvalitete prijave

Obrazac Ugovora

Opći uvjeti Ugovora

Obrazac opisnog izvještaja provedbe programa/projekta

Obrazac financijskog izvještaja provedbe programa/projekta


 

2018-10-22

Javni poziv za prijem u radni odnos na određeno vrijeme u Općinu Kravarsko za potrebe provedbe aktivnosti u sklopu Projekta ZAŽELI - Program zapošljavanja žena na području Općine Kravarsko - radnica za pomoć i potporu starijim osobama i/ili osobama u nepovoljnom položaju.

 


2018-09-14


Javni poziv za prijem u radni odnos na određeno vrijeme u Općinu Kravarsko za potrebe provedbe aktivnosti u sklopu Projekta ZAŽELI - Program zapošljavanja žena na području Općine Kravarsko - radnica za pomoć i potporu starijim osobama i/ili osobama u nepovoljnom položaju.

 


2018-07-03

 

Oglas za prijam u službu na određeno vrijeme i raspored na radno mjesto:

 

1. Viši stručni suradnik- voditelj projekta ZAŽELI - 1 (jedan) izvršitelj/ica

Detalje oglasa možete vidjeti/preuzeti   OVDJE


Obavijest o pozivu na testiranje za Višeg stručnog suradnika - voditelj projekta ZAŽELI

 

2. Referent - asistent na projektu ZAŽELI - 1 (jedan) izvršitelj/ica

Detalje oglasa možete vidjeti/preuzeti   OVDJE


Obavijest o pozivu na testiranje za Referenta - asistenta na projektu ZAŽELI

 

 

 

 

 

JAVNI POZIV ZA FINANCIRANJE UDRUGA I DRUGIH NEPROFITNIH ORGANIZACIJA  IZ PRORAČUNA OPĆINE KRAVARSKO ZA 2018. GODINU

 

 

Javni poziv objavljen je 26.03.2018.  i biti će otvoren do 30.11.2018. ili do iskorištenja sredstava. Za sve informacije možete se obratiti na e-mail: Ova e-mail adresa je zaštićena od spambota. Potrebno je omogućiti JavaScript da je vidite. ili na broj telefona 6237 022.

U nastavku možete preuzeti tekst poziva, upute i obrasce:

Javni poziv

Upute za prijavitelje

Obrazac opisa programa/projekta

Obrazac proračuna programa/projekta

Obrazac izjave o nekažnjavanju

Obrazac izjave o nepostojanju dvostrukog financiranja

Obrazac izjave da je Statut usklađen sa Zakonom o udrugama

Obrazac za procjenu kvalitete prijave

Obrazac Ugovora

Opći uvjeti Ugovora

Obrazac opisnog izvještaja provedbe programa/projekta

Obrazac financijskog izvještaja provedbe programa/projekta


 

 

 

OBAVIJEST UDRUGAMA

 

Poštovani predsjednici Udruga!

 

Molimo Vas da sukladno uvjetima Ugovora kao i svake godine , najkasnije do 31. siječnja 2018. godine dostavite opisno i financijsko izvješće  o provedbi programa/projekta za financirane/sufinancirane projekte od strane Općine Kravarsko.

Za sva pitanja možete se obratiti  u Jedinstveni upravni odjel Općine Kravarsko osobno uz najavu  ili na broj telefona 6237 022.

Uz obrazac opisnog i financijskog izvješća koji možete preuzeti niže na poveznici, dostavite račune  i fotodokumentaciju ukoliko postoji.

Udruge koje su već dostavile izvješća  molimo da zanemare ovu obavijest.

 

Obrazac opisnog izvještaja provedbe programa/projekta

Obrazac financijskog izvještaja provedbe programa/projekta

 

JAVNI POZIV ZA FINANCIRANJE UDRUGA I DRUGIH NEPROFITNIH ORGANIZACIJA  IZ PRORAČUNA OPĆINE KRAVARSKO ZA 2017. GODINU

 

2017.

Javni poziv objavljen je 13.02.2017. i biti će otvoren do 30.11.2017. ili do iskorištenja sredstava. Za sve informacije možete se obratiti na e-mail: Ova e-mail adresa je zaštićena od spambota. Potrebno je omogućiti JavaScript da je vidite. ili na broj telefona 6237 022.

U nastavku možete preuzeti tekst poziva, upute i obrasce:


Javni poziv

Upute za prijavitelje

Obrazac opisa programa/projekta

Obrazac proračuna programa/projekta

Obrazac izjave o nekažnjavanju

Obrazac izjave o nepostojanju dvostrukog financiranja

Obrazac za procjenu kvalitete prijave

Obrazac Ugovora

Opći uvjeti Ugovora

Obrazac opisnog izvještaja provedbe programa/projekta

Obrazac financijskog izvještaja provedbe programa/projekta

 

 

JAVNI POZIV ZA FINANCIRANJE UDRUGA I DRUGIH NEPROFITNIH ORGANIZACIJA  IZ PRORAČUNA OPĆINE KRAVARSKO ZA 2016. GODINU

 

 

2016.

Javni poziv objavljen je 13.04.2016. i biti će otvoren do 30.11.2016. ili do iskorištenja sredstava. Za sve informacije možete se obratiti na e-mail: Ova e-mail adresa je zaštićena od spambota. Potrebno je omogućiti JavaScript da je vidite. ili na broj telefona 6237 022.

U nastavku možete preuzeti tekst poziva, upute i obrasce :

 

Javni poziv

Upute za prijavitelje

Obrazac opisa programa/projekta

Obrazac proračuna programa/projekta

Obrazac izjave o nekažnjavanju

Obrazac izjave o nepostojanju dvostrukog financiranja

Obrazac za procjenu kvalitete prijave

Obrazac Ugovora

Opći uvjeti Ugovora

Obrazac opisnog izvještaja provedbe programa/projekta

Obrazac financijskog izvještaja provedbe programa/projekta

 

 

 

 

 

 

 

 

 


Natječaj za pročelnika Jedinstvenog upravnog odjela

 

Natječaj za prijam u

službu u Općinu Kravarsko

Kravarsko 17. prosinca 2015.

Natječaj za prijam u službu u Općinu Kravarsko

Kravarsko,17.prosinca  2015.


Načelnik općine Kravarsko raspisao je javni natječaj za prijam u službu  na neodređeno vrijeme. Natječaj je objavljen dana 16.prosinca  2015. godine u Narodnim novinama broj 135. Prijave na natječaj podnose se u roku 8 dana od dana objave natječaja.

Podaci vezani uz natječaj za prijam u službu na neodređeno vrijeme u Općinu Kravarsko na radno mjesto pročelnika Jedinstvenog upravnog odjela, 1 izvršitelj/ica, magistra struke, objavljeni su u Narodnim novinama dana 16. prosinca  2015. godine, broj 135. Rok za podnošenje prijava na natječaj je do 24. prosinca  2015. godine.

Opširnije...

Natječaj za pročelnika Jedinstvenog upravnog odjela

Natječaj za prijam u službu u Općinu Kravarsko
Kravarsko,16.srpnja 2015. 

Više o natječaju

Načelnik općine Kravarsko raspisao je javni natječaj za prijam u službu  na neodređeno vrijeme. Natječaj je objavljen dana 15.srpnja  2015. godine u Narodnim novinama broj 77. Prijave na natječaj podnose se u roku 8 dana od dana objave natječaja.

 

Opširnije...

Natječaj za prijam u službu u Općinu Kravarsko

Natječaj za prijam u službu u Općinu Kravarsko
Kravarsko,16. srpnja 2015.

Privremena pročelnica Jedinstvenog upravnog odjela Općine Kravarsko raspisala je javni natječaj za prijam u službu  na neodređeno vrijeme. Natječaj je objavljen dana  15. srpnja  2015. godine u Narodnim novinama broj 77. Prijave na natječaj podnose se u roku 8 dana od dana objave natječaja.

 

Opširnije...

© Općina Kravarsko, Trg Stjepana Radića 1, Telefon: 01 62 37 022, 01 62 37 044.......................Design by - StudioAgram

Informacije profila

Application 0.000 seconds (+0.000); 0.40 MB (+0.40) - afterLoad
Application 0.046 seconds (+0.046); 2.88 MB (+2.48) - afterInitialise
Application 0.062 seconds (+0.016); 3.89 MB (+1.01) - afterRoute
Application 0.122 seconds (+0.060); 6.50 MB (+2.60) - afterDispatch
Application 0.181 seconds (+0.059); 8.25 MB (+1.75) - afterRender

Korištenje Memorije

8.3 MB (8,705,864 Bytes)

41 Upita zapisano

  1. SELECT `data`
      FROM `kra_session`
      WHERE `session_id` = 's1n9cn5a25nnap8lru0erauco6'
  2. SELECT `session_id`
      FROM `kra_session`
      WHERE `session_id` = 's1n9cn5a25nnap8lru0erauco6'
      LIMIT 0, 1
  3. INSERT INTO `kra_session` (`session_id`, `client_id`, `time`)
      VALUES ('s1n9cn5a25nnap8lru0erauco6', 0, 1603173418)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `kra_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM kra_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
      FROM kra_menu AS m
      LEFT JOIN kra_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      AND m.access IN (1,1)
      ORDER BY m.lft
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  10. SELECT *
      FROM kra_languages
      WHERE published=1
  11. SELECT id, home, template, params
      FROM kra_template_styles
      WHERE client_id = 0
  12. SELECT a.rules
      FROM kra_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id
  13. SELECT b.rules
      FROM kra_assets AS a
      LEFT JOIN kra_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content' OR a.parent_id=0)
      GROUP BY b.id
      ORDER BY b.lft
  14. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM kra_categories as c
      LEFT JOIN kra_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM kra_categories AS cat JOIN kra_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN `kra_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=9
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  15. SELECT b.rules
      FROM kra_assets AS a
      LEFT JOIN kra_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content.category.9' OR a.parent_id=0)
      GROUP BY b.id
      ORDER BY b.lft
  16. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM kra_content AS a
      LEFT JOIN kra_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN kra_categories AS c
      ON c.id = a.catid
      LEFT JOIN kra_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN kra_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN kra_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN kra_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN kra_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM kra_categories AS cat JOIN kra_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 9
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-20 05:56:58')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-20 05:56:58')
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 0, 10
  17. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM kra_content AS a
      LEFT JOIN kra_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN kra_categories AS c
      ON c.id = a.catid
      LEFT JOIN kra_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN kra_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN kra_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN kra_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN kra_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM kra_categories AS cat JOIN kra_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 9
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-20 05:56:58')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-20 05:56:58')
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
  18. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM kra_categories as c
      LEFT JOIN kra_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM kra_categories AS cat JOIN kra_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=9
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  19. SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM kra_modules AS m
      LEFT JOIN kra_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-20 05:56:58')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 05:56:58')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 149 OR mm.menuid <= 0)
      ORDER BY position, ordering
  20. CREATE TABLE IF NOT EXISTS kra_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
  21. SELECT count( * ) AS records, MAX( id ) AS max
      FROM kra_vvisitcounter
  22. CREATE TABLE IF NOT EXISTS kra_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL , valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMORY
  23. DELETE
      FROM kra_vvisitcounter
      WHERE id<='466561'
  24. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE ip=UNHEX(SHA1('3.210.201.170'))
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
  25. INSERT INTO kra_mod_vvisit_counter_memo ( counter )
      values ( 'vvisitcounter' )
      ON DUPLICATE KEY UPDATE counter='vvisitcounter'
  26. select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  27. select valMaxVisits val, valMaxVisitsDay day
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  28. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
  29. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
      AND UNIX_TIMESTAMP(DATE(NOW()))
  30. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN 1603065600
      AND 1603670400
  31. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
      AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)
  32. SELECT *
      FROM kra_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  33. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM kra_banners as a
      LEFT JOIN kra_banner_clients AS cl
      ON cl.id = a.cid
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade = a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (8)
      ORDER BY a.sticky DESC,RAND()
  34. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM kra_banners as a
      LEFT JOIN kra_banner_clients AS cl
      ON cl.id = a.cid
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade = a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (8)
      ORDER BY a.sticky DESC,RAND()
      LIMIT 0, 1
  35. UPDATE kra_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  36. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-10-20 05'
  37. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-10-20 05'
  38. UPDATE kra_banner_tracks
      SET `count` = (`count` + 1)
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-10-20 05'
  39. SELECT `enabled`
      FROM `kra_extensions`
      WHERE `element` = "com_akeeba"
      AND `type` = "component"
  40. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_akeeba'
  41. UPDATE `kra_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603173418;s:18:\"session.timer.last\";i:1603173418;s:17:\"session.timer.now\";i:1603173418;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"d746382e0b880182632e1db539f9cea3\";}', `time` = 1603173418
      WHERE `session_id` = 's1n9cn5a25nnap8lru0erauco6'

30 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.

ODABERI tablice:
  1. 5 × SELECT COUNT(*) FROM kra_vvisitcounter
  2. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM kra_extensions
  3. 2 × SELECT b.rules FROM kra_assets AS a LEFT JOIN kra_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  4. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM kra_banners as a LEFT JOIN kra_banner_clients AS cl ON cl.id = a.cid
  5. 2 × SELECT `count` FROM kra_banner_tracks
  6. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM kra_content AS a LEFT JOIN kra_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN kra_categories AS c ON c.id = a.catid LEFT JOIN kra_users AS ua ON ua.id = a.created_by LEFT JOIN kra_users AS uam ON uam.id = a.modified_by LEFT JOIN kra_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN kra_categories as parent ON parent.id = c.parent_id LEFT JOIN kra_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM kra_categories AS cat JOIN kra_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  7. 1 × SELECT count( * ) AS records, MAX( id ) AS max FROM kra_vvisitcounte
  8. 1 × SELECT * FROM kra_banners
  9. 1 × SELECT `enabled` FROM `kra_extensions`
  10. 1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM kra_modules AS m LEFT JOIN kra_modules_menu AS mm ON mm.moduleid = m.id
  11. 1 × select valMaxVisits val, valMaxVisitsDay day FROM kra_mod_vvisit_counter_memo
  12. 1 × select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff FROM kra_mod_vvisit_counter_memo
  13. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM kra_categories as c LEFT JOIN kra_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM kra_categories AS cat JOIN kra_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  14. 1 × SELECT folder AS type, element AS name, params FROM kra_extensions
  15. 1 × SELECT id, rules FROM `kra_viewlevels
  16. 1 × SELECT `session_id` FROM `kra_session`
  17. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM kra_menu AS m LEFT JOIN kra_extensions AS e ON m.component_id = e.extension_id
  18. 1 × SELECT * FROM kra_languages
  19. 1 × SELECT `data` FROM `kra_session`
  20. 1 × SELECT a.rules FROM kra_assets AS a
  21. 1 × SELECT id, home, template, params FROM kra_template_styles
  22. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM kra_categories as c LEFT JOIN kra_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM kra_categories AS cat JOIN kra_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
OSTALE tablice:
  1. 1 × UPDATE kra_banners SET impmade = (impmade + 1)
  2. 1 × UPDATE kra_banner_tracks SET `count` = (`count` + 1)
  3. 1 × UPDATE `kra_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603173418;s:18:\"session.timer.last\";i:1603173418;s:17:\"session.timer.now\";i:1603173418;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"d746382e0b880182632e1db539f9cea3\";}', `time` = 1603173418
  4. 1 × INSERT INTO kra_mod_vvisit_counter_memo ( counter ) values ( 'vvisitcounter' ) ON DUPLICATE KEY UPDATE counter='vvisitcounter
  5. 1 × DELETE FROM kra_vvisitcounter
  6. 1 × CREATE TABLE IF NOT EXISTS kra_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=
  7. 1 × CREATE TABLE IF NOT EXISTS kra_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL , valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMOR
  8. 1 × INSERT INTO `kra_session` (`session_id`, `client_id`, `time`) VALUES ('s1n9cn5a25nnap8lru0erauco6', 0, 1603173418