Galerija

imageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimage

RADIONICA: UPOZNAVANJE GRAĐANA S PRORAČUNOM

 

 

 

Pozivamo Vas na besplatnu radionicu: UPOZNAVANJE GRAĐANA S PRORAČUNOM koja će se održati 28.09.2020.g., od 18:30 do 20:30h,  u Domu kulture u Kravarskom (Trg Stjepana Radića 16, Kravarsko).

 

Dođite na radionicu i saznajte više o procesu kreiranja proračuna!


Radionica se provodi u sklopu projekta: Pokrenimo KOK! UP.04.2.1.07.0076 koji je sufinancirala Europska unija iz Europskog socijalnog fonda te Ured za udruge Vlade Republike Hrvatske.

 

Saznajte više ...

 

 

Poziv za upis u program predškole

 

Poziv za upis u program predškole – Dječji vrtić „DIDI“

 

Roditeljski sastanak za polaznike programa predškole održati će se 29.09.2020. u 17 h u prostorijama dječjeg vrtića u Kravarskom, Trg Stjepana Radića 19 (objekt Banić, MIP, ulaz sa stražnje strane).

 

Na roditeljski je potrebno ponijeti:

-        Rodni list za dijete (preslika, bez obzira na datum)

-        Potvrdu o prebivalištu za dijete ne starije od 6 mjeseci

 

Dodatne informacije možete dobiti na br. telefona  01/ 2750-912, 098/382-538 (dječji vrtić „DIDI“)

 

 

 

 

ODVOZ OTPADA OD 01.07.2020.

 

 

Od 01.07.2020.g. uslugu odvoza otpada na području Općine Kravarsko preuzima  VG Čistoća d.o.o.

Sve detalje  oko uvjeta pružanja usluge odvoza otpada od strane VG Čistoće d.o.o. možete vidjeti OVDJE

 

Poštovani,

prema posljednjoj informaciji tvrtke Eko-Flor Plus d.o.o. odvoz selektivnog otpada (papira i plastike) na  dijelu područja Općine Kravarsko koji  zbog kvara kamiona nije izvršen prošli tjedan , trebao bi biti izvršen  danas 02.07.2020. godine ili sutra 03.07.2020.

 


JAVNI UVID U IZRADU PROGRAMA GOSPODARENJA ZA PRIVATNE ŠUMOPOSJEDNIKE

 

 

Ministarstvo poljoprivrede i izvođač radova Pro Silva d.o.o. pozivaju sve zainteresirane na javni uvid i javnu raspravu o prijedlogu Programa gospodarenja za šume šumoposjednika u gospodarskoj jedinici „Turopoljske šume“.

 

Javna rasprava održati će se 21. srpnja 2020. godine s početkom u 11 sati, u prostorijama Općine Kravarsko, na adresi Trg Stjepana Radića 1,  10413 Kravarsko.

 

Opširnije...

 

OBAVIJEST - COVID-19

 

 

Stožer civilne zaštite Republike Hrvatske donio je Odluku o dopuni Odluke o privremenoj zabrani prelaska preko graničnih prijelaza Republike Hrvatske i Odluku o izmjeni Odluke o načinu organizacije javnog prometa za vrijeme trajanja proglašene epidemije bolesti COVID-19.

 

Više saznajte u nastavku!

 

 

Više članaka ...

  1. OBAVIJEST - OTPAD
  2. OPĆINA KRAVARSKO OSIGURALA SREDSTVA IZ KOHEZIJSKOG FONDA ZA MOBILNO RECIKLAŽNO DVORIŠTE
  3. OSIGURANA SREDSTVA IZ EUROPSKOG SOCIJALNOG FONDA ZA PROJEKT: Pokrenimo KOK!
  4. Poziv na radionice u sklopu projekta: Volontiram, mijenjam zajednicu!
  5. NOVI VOZNI RED OD 01.06.2020.
  6. UPIS DJECE U 1. RAZRED OSNOVNE ŠKOLE
  7. IZMIJENJENI RED VOŽNJE OD 11.05.2020.
  8. COVID-19 POPUŠTANJE MJERA
  9. NOVOSTI O e-PROPUSNICAMA
  10. OBAVIJEST - TEHNIČKI PREGLED
  11. .
  12. PRIVREMENI PREKID OPSKRBE VODOM
  13. KORONAVIRUS - MJERE OPREZA
  14. 29. KONCERT
  15. UPIS DJECE U 1. RAZRED OSNOVNE ŠKOLE
  16. 29. KONCERT U ČAST HRVATSKIM BRANITELJIMA
  17. OBAVIJEST POLJOPRIVREDNICIMA
  18. VINCEKOVO U KRAVARSKOM
  19. RADIONICA O LAG NATJEČAJU ZA MLADE POLJOPRIVREDNIKE
  20. OBAVIJEST VRTIĆ DIDI
  21. *
  22. OBAVIJEST VRTIĆ DIDI
  23. OBAVIJEST - INICIJALNI RAZGOVORI ZA UPIS U VRTIĆ
  24. OBAVIJEST - RADOVI NA PODVORNIČKOJ CESTI
  25. ZIMSKA SLUŽBA
  26. OBAVIJEST - PREDŠKOLA
  27. POZIV NA SASTANAK ZA DJEČJI VRTIĆ
  28. OBAVIJEST POLJOPRIVREDNICIMA
  29. OBAVIJEST O TEHNIČKOM PREGLEDU TRAKTORA
  30. REKONSTRUIRANA ULICA ZAGORCI - KOLARCI
  31. ZAVRŠENI SU RADOVI U ULICI ZAGORCI - KOLARCI
  32. OBAVIJEST - ODVOZ OTPADA
  33. ODVOZ GLOMAZNOG OTPADA
  34. ODRŽAN 10. KOORDINACIJSKI SASTANAK PROJEKTA ZAŽELI
  35. OBAVIJEST O PROVEDBI POSEBNIH MJERA ZAŠTITE OD POŽARA
  36. Civilna zaštita i zaštita od požara
  37. OBAVIJEST
  38. OBAVIJEST O BOLESTIMA SVINJA
  39. OBAVIJEST STANOVNICIMA I KORISNICIMA PROMETNICE ZAGORCI - KOLARCI
  40. OBAVIJEST KORISNICIMA ULICE ZAGORCI - KOLARCI
  41. Zahtjevi
  42. Zaštita osobnih podataka-Komunalno poduzeće Kravarsko
  43. OBAVIJEST
  44. ZAŠTITA OSOBNIH PODATAKA
  45. OBAVIJEST O TEHNIČKOM PREGLEDU TRAKTORA
  46. OBJAVA BIRAČIMA - IZBORI ZA NACIONALNE MANJINE
  47. TRAŽE SE SUCI POROTNICI ZA OPĆINSKI I ŽUPANIJSKI SUD U VELIKOJ GORICI
  48. PREDSTAVA "SVOGA TELA GOSPODAR" U KRAVARSKOM!
  49. 28. Koncert u čast hrvatskim braniteljima
  50. ODVOZ GLOMAZNOG OTPADA
  51. RADIONICA O OTVORENOM NATJEČAJU ZA POLJOPRIVREDNIKE
  52. UPIS DJECE U 1. RAZRED OSNOVNE ŠKOLE
  53. OBAVIJEST MJEŠTANIMA GORNJEG HRUŠEVCA
  54. KAKO DO PRIKLJUČKA NA JAVNU VODOOPSKRBNU MREŽU
  55. OBAVIJEST - RADOVI U ULICI ZAGORCI – KOLARCI
  56. OBAVIJEST - ODVOZ OTPADA
  57. OBAVIJEST - ODVOZ OTPADA
  58. BOŽIĆNO NOVOGODIŠNJI KONCERT KUD-a KRAVARSKO
  59. JAVNA TRIBINA - PREDSTAVLJANJE PROJEKTA ZAŽELI
  60. ZIMSKA SLUŽBA
  61. OPĆINI KRAVARSKO 15.000,00 EURA ZA BEŽIČNI INTERNET
  62. DAN OPĆINE KRAVARSKO 2018.
  63. NAJAVA RADOVA - ELEKTRA ZAGREB
  64. TEHNIČKI PREGLED TRAKTORA I TRAKTORSKIH PRIKOLICA
  65. 1. PROJEKTNI SASTANAK
  66. OBAVIJEST ZA POLJOPRIVREDNA GOSPODARSTVA
  67. OPĆINA KRAVARSKO FINANCIRA NABAVU ŠKOLSKIH UDŽBENIKA I ŠKOLSKU PREHRANU
  68. OBAVIJEST O KLIZIŠTIMA U KRAVARSKOM
  69. OBAVIJEST UČENICIMA SREDNJIH ŠKOLA
  70. POČINJE PROVEDBA PROJEKTA „ZAŽELI – Program zapošljavanja žena na području Općine Kravarsko“
  71. OBAVIJEST O KLIZIŠTU NA DRŽAVNOJ CESTI D-31, 15.-16. KM
  72. OPĆINA KRAVARSKO POTPISALA UGOVORE ZA PROVEDBU PROJEKATA U VRIJEDNOSTI 9.073.512,04 KUNA
  73. OBAVIJEST- PROGRAM JAVNIH RADOVA
  74. OBAVIJEST - POZIV GRAĐANIMA!
  75. OBAVIJEST O TEHNIČKOM PREGLEDU TRAKTORA
  76. 27. KONCERT U ČAST HRVATSKIM BRANITELJIMA
  77. Obavijest - prijevoz učenika srednjih škola
  78. OBAVIJEST OPG-ovima I PODUZETNICIMA- EDUKACIJA
  79. EU FONDOVI - MJERA 7 - Rekonstukcija nerazvrstane prometnice KR-02
  80. KLIZIŠTE NA DRŽAVNOJ CESTI D-31, 15.-16. km
  81. Plan gospodarenja otpadom Općine Kravarsko za razdoblje od 2017. do 2022. godine
  82. POZIV OBVEZNICIMA KOMUNALNE NAKNADE
  83. --
  84. FINANCIJSKA IZVJEŠĆA
  85. OBAVIJEST- ŠTETE OD MRAZA
  86. IZBORI 2017.
  87. OBAVIJEST-TEHNIČKI PREGLED TRAKTORA
  88. NOVI PROSTORNI PLAN
  89. OBAVIJEST -ODVOZ OTPADA EKO-FLOR
  90. OSTALE INFORMACIJE
  91. JAVNA NABAVA KPK
  92. PRAVO NA PRISTUP INFORMACIJAMA
  93. OPĆI AKTI I ODLUKE
  94. ZAKONI
  95. DJELATNOSTI
  96. USTROJ
  97. OBAVIJEST- II.IZMJENE I DOPUNE PROSTORNOG PLANA UREĐENJA OPĆINE KRAVARSKO
  98. Pustike
  99. Podvornica
  100. Žitkovčica
  101. Novo Brdo
  102. Barbarići-Kravarski
  103. Čakanec
  104. Gladovec-Kravarski
  105. Donji Hruševec
  106. Gornji Hruševec
  107. Kravarsko
  108. Strateški plan
  109. Zakoni i propisi
  110. IZBORI ZA ČLANOVE VIJEĆA I PREDSTAVNIKE NACIONALNIH MANJINA
  111. Izbori
  112. ODLUKA O KOMUNALNOM DOPRINOSU
  113. Ostale informacije
  114. Pristup informacijama
  115. STATUT OPĆINE KRAVARSKO
  116. OPĆINSKO VIJEĆE
  117. PRORAČUN I PROGRAMI
  118. JAVNA NABAVA
  119. REFERENDUM
  120. Vijećnici općine
  121. Načelnik općine
  122. Kravarski grb
  123. Naselja općine
  124. O općini
  125. Uprava
  126. PROSTORNI PLAN
  127. MJESNI ODBORI
  128. Župna crkva
  129. Područna škola
  130. Kontakt

© 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.050 seconds (+0.050); 2.88 MB (+2.48) - afterInitialise
Application 0.071 seconds (+0.021); 4.06 MB (+1.18) - afterRoute
Application 0.218 seconds (+0.147); 11.43 MB (+7.36) - afterDispatch
Application 0.310 seconds (+0.092); 13.17 MB (+1.74) - afterRender

Korištenje Memorije

13.22 MB (13,861,024 Bytes)

42 Upita zapisano

  1. SELECT `data`
      FROM `kra_session`
      WHERE `session_id` = 'f2pqvqfrb8d0fdkc9of4rap695'
  2. SELECT `session_id`
      FROM `kra_session`
      WHERE `session_id` = 'f2pqvqfrb8d0fdkc9of4rap695'
      LIMIT 0, 1
  3. INSERT INTO `kra_session` (`session_id`, `client_id`, `time`)
      VALUES ('f2pqvqfrb8d0fdkc9of4rap695', 0, 1601140278)
  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 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=2
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  11. SELECT *
      FROM kra_languages
      WHERE published=1
  12. SELECT id, home, template, params
      FROM kra_template_styles
      WHERE client_id = 0
  13. SELECT a.rules
      FROM kra_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id
  14. 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
  15. 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=2
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  16. 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.2' OR a.parent_id=0)
      GROUP BY b.id
      ORDER BY b.lft
  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 = 2
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-26 17:11:18')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-26 17:11:18')
      ORDER BY c.lft, a.created DESC , a.created
  18. 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 = 2
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-26 17:11:18')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-26 17:11:18')
      ORDER BY c.lft, a.created DESC , a.created
  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-09-26 17:11:18')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-26 17:11:18')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 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<='460989'
  24. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE ip=UNHEX(SHA1('3.230.119.106'))
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
  25. INSERT INTO kra_vvisitcounter ( tm, ip, data )
      VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.230.119.106')) , NULL )
  26. INSERT INTO kra_mod_vvisit_counter_memo ( counter )
      values ( 'vvisitcounter' )
      ON DUPLICATE KEY UPDATE counter='vvisitcounter'
  27. select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  28. select valMaxVisits val, valMaxVisitsDay day
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  29. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
  30. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
      AND UNIX_TIMESTAMP(DATE(NOW()))
  31. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN 1600646400
      AND 1601251200
  32. 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)
  33. 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)
  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()
  35. 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
  36. UPDATE kra_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  37. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-26 17'
  38. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-26 17'
  39. UPDATE kra_banner_tracks
      SET `count` = (`count` + 1)
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-26 17'
  40. SELECT `enabled`
      FROM `kra_extensions`
      WHERE `element` = "com_akeeba"
      AND `type` = "component"
  41. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_akeeba'
  42. UPDATE `kra_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1601140278;s:18:\"session.timer.last\";i:1601140278;s:17:\"session.timer.now\";i:1601140278;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:\"41f086a3d96998d688b073f002641b47\";}', `time` = 1601140279
      WHERE `session_id` = 'f2pqvqfrb8d0fdkc9of4rap695'

31 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 `count` FROM kra_banner_tracks
  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 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
  6. 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
  7. 1 × select valMaxVisits val, valMaxVisitsDay day FROM kra_mod_vvisit_counter_memo
  8. 1 × select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff FROM kra_mod_vvisit_counter_memo
  9. 1 × SELECT folder AS type, element AS name, params FROM kra_extensions
  10. 1 × SELECT * FROM kra_banners
  11. 1 × SELECT id, rules FROM `kra_viewlevels
  12. 1 × SELECT `enabled` FROM `kra_extensions`
  13. 1 × SELECT `session_id` FROM `kra_session`
  14. 1 × SELECT count( * ) AS records, MAX( id ) AS max FROM kra_vvisitcounte
  15. 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
  16. 1 × SELECT id, home, template, params FROM kra_template_styles
  17. 1 × SELECT * FROM kra_languages
  18. 1 × SELECT a.rules FROM kra_assets AS a
  19. 1 × SELECT `data` FROM `kra_session`
  20. 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
  21. 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
  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:1601140278;s:18:\"session.timer.last\";i:1601140278;s:17:\"session.timer.now\";i:1601140278;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:\"41f086a3d96998d688b073f002641b47\";}', `time` = 1601140279
  4. 1 × INSERT INTO kra_mod_vvisit_counter_memo ( counter ) values ( 'vvisitcounter' ) ON DUPLICATE KEY UPDATE counter='vvisitcounter
  5. 1 × INSERT INTO kra_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.230.119.106')) , NULL
  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 × DELETE FROM kra_vvisitcounter
  9. 1 × INSERT INTO `kra_session` (`session_id`, `client_id`, `time`) VALUES ('f2pqvqfrb8d0fdkc9of4rap695', 0, 1601140278