Nalazite se ovdje: Naslovna

Galerija

imageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimage

JAVNI UVID U IZRADU PROGRAMA GOSPODARENJA ZA PRIVATNE ŠUMOPOSJEDNIKE

  • Ispis

 

 

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.

  • Ispis

 

 

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

  • Ispis

 

 

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

  • Ispis

 

 

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

  • Ispis

 

 

 

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. KORONAVIRUS - MJERE OPREZA
  10. 29. KONCERT

© 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.038 seconds (+0.038); 2.88 MB (+2.48) - afterInitialise
Application 0.054 seconds (+0.016); 3.88 MB (+1.00) - afterRoute
Application 0.132 seconds (+0.078); 6.58 MB (+2.71) - afterDispatch
Application 0.219 seconds (+0.087); 8.35 MB (+1.76) - afterRender

Korištenje Memorije

8.39 MB (8,794,440 Bytes)

39 Upita zapisano

  1. SELECT `data`
      FROM `kra_session`
      WHERE `session_id` = '5rhj6vqar1vqpdvrcl1ge510q1'
  2. SELECT `session_id`
      FROM `kra_session`
      WHERE `session_id` = '5rhj6vqar1vqpdvrcl1ge510q1'
      LIMIT 0, 1
  3. INSERT INTO `kra_session` (`session_id`, `client_id`, `time`)
      VALUES ('5rhj6vqar1vqpdvrcl1ge510q1', 0, 1600681408)
  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 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_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
      INNER JOIN kra_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 09:43:28')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 09:43:28')
      ORDER BY c.lft, a.created DESC , a.created DESC
      LIMIT 0, 15
  15. 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_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
      INNER JOIN kra_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 09:43:28')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 09:43:28')
      ORDER BY c.lft, a.created DESC , a.created DESC
  16. 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
  17. 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:43:28')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-21 09:43:28')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY position, ordering
  18. 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
  19. SELECT count( * ) AS records, MAX( id ) AS max
      FROM kra_vvisitcounter
  20. 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
  21. DELETE
      FROM kra_vvisitcounter
      WHERE id<='459590'
  22. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE ip=UNHEX(SHA1('3.234.143.26'))
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
  23. INSERT INTO kra_mod_vvisit_counter_memo ( counter )
      values ( 'vvisitcounter' )
      ON DUPLICATE KEY UPDATE counter='vvisitcounter'
  24. select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  25. select valMaxVisits val, valMaxVisitsDay day
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  26. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
  27. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
      AND UNIX_TIMESTAMP(DATE(NOW()))
  28. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN 1600646400
      AND 1601251200
  29. 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)
  30. 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)
  31. 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()
  32. 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
  33. UPDATE kra_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  34. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-21 09'
  35. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-21 09'
  36. UPDATE kra_banner_tracks
      SET `count` = (`count` + 1)
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-21 09'
  37. SELECT `enabled`
      FROM `kra_extensions`
      WHERE `element` = "com_akeeba"
      AND `type` = "component"
  38. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_akeeba'
  39. UPDATE `kra_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1600681408;s:18:\"session.timer.last\";i:1600681408;s:17:\"session.timer.now\";i:1600681408;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:\"cc1de3b63278314bbf03bddcecfecfc9\";}', `time` = 1600681408
      WHERE `session_id` = '5rhj6vqar1vqpdvrcl1ge510q1'

29 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 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
  4. 2 × SELECT `count` FROM kra_banner_tracks
  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_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. 1 × select valMaxVisits val, valMaxVisitsDay day FROM kra_mod_vvisit_counter_memo
  7. 1 × select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff FROM kra_mod_vvisit_counter_memo
  8. 1 × SELECT folder AS type, element AS name, params FROM kra_extensions
  9. 1 × SELECT * FROM kra_banners
  10. 1 × SELECT id, rules FROM `kra_viewlevels
  11. 1 × SELECT `enabled` FROM `kra_extensions`
  12. 1 × SELECT `session_id` FROM `kra_session`
  13. 1 × SELECT count( * ) AS records, MAX( id ) AS max FROM kra_vvisitcounte
  14. 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
  15. 1 × SELECT id, home, template, params FROM kra_template_styles
  16. 1 × SELECT * FROM kra_languages
  17. 1 × SELECT a.rules FROM kra_assets AS a
  18. 1 × SELECT b.rules FROM kra_assets AS a LEFT JOIN kra_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  19. 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
  20. 1 × SELECT `data` FROM `kra_session`
  21. 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
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:1600681408;s:18:\"session.timer.last\";i:1600681408;s:17:\"session.timer.now\";i:1600681408;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:\"cc1de3b63278314bbf03bddcecfecfc9\";}', `time` = 1600681408
  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 ('5rhj6vqar1vqpdvrcl1ge510q1', 0, 1600681408