Galerija

imageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimage

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...

 

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.

 


OBAVIJEST - OTPAD

 

 

Sa danom 30.06.2020.g. EKO FLOR PLUS d.o.o. prestaje pružati uslugu odvoza otpada na području Općine Kravarsko te sa zadnjim odvozom uzima i kante.

 

Od 01.07.2020.g. uslugu odvoza otpada pružat će VG Čistoća d.o.o.

 

Molimo sve korisnike da otpad prikupljaju u vrećama za smeće do podijele novih kanti koje će biti podijeljene od strane VG Čistoće d.o.o. do 10.07.2020.g.

 

Do promijene davatelja usluge došlo je zbog previsoke cijene koju je uvjetovao EKO FLOR PLUS d.o.o. te smo u dogovoru s Gradom Velika Gorica i VG Čistoćom d.o.o. došli do sporazuma i donošenja Odluke o davanju usluge odvoza otpada VG Čistoći d.o.o. po prihvatljivim cijenama.

 

Sve detaljne informacije o daljnjem prikupljanju otpada dobit ćete pisanim putem na kućnu adresu.

 

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!

 

 

OPĆINA KRAVARSKO OSIGURALA SREDSTVA IZ KOHEZIJSKOG FONDA ZA MOBILNO RECIKLAŽNO DVORIŠTE

 

 

 

U Općini Kravarsko počinje provedba projekta: „Uspostava mobilnog reciklažnog dvorišta u Općini Kravarsko“. Projekt sufinancira Europska unija iz Kohezijskog fonda.

 

Ukupna vrijednost projekta je 444.250,00 kuna, od čega bespovratna sredstva iznose 377.612,50 kuna, a vlastita sredstva Općine Kravarsko 66.637,50 kuna.

 

Opširnije...

 

 

Više članaka ...

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

Korištenje Memorije

13.14 MB (13,783,096 Bytes)

42 Upita zapisano

  1. SELECT `data`
      FROM `kra_session`
      WHERE `session_id` = '8hk82rcqmrgq2eclnalf0pth34'
  2. DELETE
      FROM `kra_session`
      WHERE `time` < 1600680225
  3. SELECT `session_id`
      FROM `kra_session`
      WHERE `session_id` = '8hk82rcqmrgq2eclnalf0pth34'
      LIMIT 0, 1
  4. INSERT INTO `kra_session` (`session_id`, `client_id`, `time`)
      VALUES ('8hk82rcqmrgq2eclnalf0pth34', 0, 1600681125)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `kra_viewlevels`
  7. 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
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. 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
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. 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
  12. SELECT *
      FROM kra_languages
      WHERE published=1
  13. SELECT id, home, template, params
      FROM kra_template_styles
      WHERE client_id = 0
  14. SELECT a.rules
      FROM kra_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id
  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' OR a.parent_id=0)
      GROUP BY b.id
      ORDER BY b.lft
  16. 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
  17. 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
  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-21 09:38:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 09:38:45')
      ORDER BY c.lft, a.created DESC , a.created
  19. 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-21 09:38:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 09:38:45')
      ORDER BY c.lft, a.created DESC , a.created
  20. 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-21 09:38:45')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-21 09:38:45')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY position, ordering
  21. 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
  22. SELECT count( * ) AS records, MAX( id ) AS max
      FROM kra_vvisitcounter
  23. 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
  24. DELETE
      FROM kra_vvisitcounter
      WHERE id<='459589'
  25. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE ip=UNHEX(SHA1('3.234.143.26'))
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
  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-21 09'
  38. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-21 09'
  39. UPDATE kra_banner_tracks
      SET `count` = (`count` + 1)
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-21 09'
  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:1600681125;s:18:\"session.timer.last\";i:1600681125;s:17:\"session.timer.now\";i:1600681125;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:\"bdfb2ebba350887bee092324dfba06a6\";}', `time` = 1600681125
      WHERE `session_id` = '8hk82rcqmrgq2eclnalf0pth34'

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:1600681125;s:18:\"session.timer.last\";i:1600681125;s:17:\"session.timer.now\";i:1600681125;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:\"bdfb2ebba350887bee092324dfba06a6\";}', `time` = 1600681125
  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 × INSERT INTO `kra_session` (`session_id`, `client_id`, `time`) VALUES ('8hk82rcqmrgq2eclnalf0pth34', 0, 1600681125
  7. 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=
  8. 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
  9. 1 × DELETE FROM `kra_session`