Karta Hrvatske

Ulice
Firme
Osobe

Upišite ime grada ili ulicu i broj, grad.
Npr zagreb ili ilica 23, Zagreb

Upišite ime grada ili ulicu i broj, grad.
Npr split ili vukovarska 2, Split

Ostale lokacije

Stranica 1 of 82. naprijed

Firme

Srijeda 30 Svi. 2012
	Zagreb	KYUSS LIVES!
Subota 02 Lip. 2012
	Zadar	METALFEST CROATIA
	Hrvatska	METALFEST CROATIA
Nedjelja 03 Lip. 2012
	Zagreb	ZAZ
Četvrtak 07 Lip. 2012
	Zagreb	ROKAJ FEST 2012
Više

Molim pričekajte ...

20 Komentara za Hrvatska

Another tick on the to-do list!
Travanj 30, 2012 12:28

dobro kaže coki ako vam nepaše kupite si je :=)

Coki
Travanj 12, 2012 11:55

Ne razmem kaj se bunite, ak vam ne paše kupite si kartu na benzinskoj stanici pa se po njoj vozite. :)

MarinoSa
Ožujak 11, 2012 20:09

Kolko je Zagreb udaljen od Varazdina sati ???

renata
Sij. 19, 2012 16:53

Od Koprivnice do Zagreba vodi me preko Varaždinskih toplica , a ne preko kž..glupost

v hn l kgkbplfš
Ruj. 2, 2011 15:46

vjiu htovkwšdb 0pujšpborv biofov plkvolkcšp lspcpč klgik io olrfš lčpec lč,fl,.an m<-.k,o b oobkokvkkig

Prethodna 1 2 3 4 Sljedeća

Dizel Deva d.o.o. | Oglašavanje | Uvjeti korištenja | Kontakt |

Server-time taken: 0.17875 seconds

Templates used:

karta.html loaded from /home/karte/templates/karta.html
komentari/comments_firme.html loaded from /home/karte/templates/komentari/comments_firme.html
pagination.html loaded from /home/karte/templates/pagination.html
comments/form.html loaded from /home/karte/templates/comments/form.html

Template path:

/home/karte/../karte/templates
/home/karte/../karte/facebookconnect/templates

SQL executed:

SELECT "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_city" WHERE "gradovi_city"."name" = E'hrvatska'

took 0.002 seconds

SELECT "gradovi_weather"."id", "gradovi_weather"."location_code", "gradovi_weather"."code", "gradovi_weather"."description", "gradovi_weather"."last_update", "gradovi_weather"."temp", "gradovi_weather"."sunrise", "gradovi_weather"."sunset", "gradovi_weather"."humidity", "gradovi_weather"."pressure", "gradovi_weather"."wind", "gradovi_weather"."city_id" FROM "gradovi_weather" WHERE "gradovi_weather"."city_id" = 5

took 0.001 seconds

SELECT "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_city" INNER JOIN "gradovi_city_sites" ON ("gradovi_city"."id" = "gradovi_city_sites"."city_id") WHERE ("gradovi_city_sites"."site_id" = 2  AND NOT ("gradovi_city"."name" IN (E'svijet', E'hrvatska', E'zagreb', E'split', E'rijeka'))) 
  ORDER BY "gradovi_city"."name" ASC

took 0.002 seconds

SELECT COUNT(*) FROM "gradovi_company" INNER JOIN "gradovi_city" ON ("gradovi_company"."city_id" = "gradovi_city"."id") WHERE "gradovi_city"."name" = E'hrvatska'

took 0.019 seconds

SELECT COUNT(*) FROM "gradovi_street" INNER JOIN "gradovi_city" ON ("gradovi_street"."city_id" = "gradovi_city"."id") WHERE "gradovi_city"."name" = E'hrvatska'

took 0.002 seconds

SELECT "gradovi_location"."id", "gradovi_location"."name", "gradovi_location"."address", "gradovi_location"."lat", "gradovi_location"."lng", "gradovi_location"."description", "gradovi_location"."city_id", "gradovi_location"."slug", "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_location" INNER JOIN "gradovi_city" ON ("gradovi_location"."city_id" = "gradovi_city"."id") WHERE ("gradovi_city"."name" = E'hrvatska'  AND NOT ("gradovi_location"."name" = E'dummy' )) 
  ORDER BY RANDOM() LIMIT 6

took 0.001 seconds

SELECT COUNT(*) FROM "gradovi_userlocation"

took 0.001 seconds

SELECT "gradovi_userlocation"."id", "gradovi_userlocation"."name", "gradovi_userlocation"."lat", "gradovi_userlocation"."lng", "gradovi_userlocation"."added", "gradovi_userlocation"."slug" FROM "gradovi_userlocation" 
  ORDER BY "gradovi_userlocation"."added" DESC LIMIT 15

took 0.002 seconds

SELECT "dogadanja_event"."id", "dogadanja_event"."date", "dogadanja_event"."description", "dogadanja_event"."type_id", "dogadanja_event"."location_id", "dogadanja_event"."ticket_sale", "dogadanja_event"."ticket_sale_url", "dogadanja_event"."eventim_id", "dogadanja_event"."show_event", "dogadanja_eventtype"."id", "dogadanja_eventtype"."name", "gradovi_location"."id", "gradovi_location"."name", "gradovi_location"."address", "gradovi_location"."lat", "gradovi_location"."lng", "gradovi_location"."description", "gradovi_location"."city_id", "gradovi_location"."slug", "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "dogadanja_event" INNER JOIN "dogadanja_event_sites" ON ("dogadanja_event"."id" = "dogadanja_event_sites"."event_id") INNER JOIN "dogadanja_eventtype" ON ("dogadanja_event"."type_id" = "dogadanja_eventtype"."id") INNER JOIN "gradovi_location" ON ("dogadanja_event"."location_id" = "gradovi_location"."id") INNER JOIN "gradovi_city" ON ("gradovi_location"."city_id" = "gradovi_city"."id") WHERE ("dogadanja_event_sites"."site_id" = 2  AND "dogadanja_event"."date" >= E'2012-05-18'  AND "dogadanja_event"."show_event" = true ) 
  ORDER BY "dogadanja_event"."date" ASC

took 0.003 seconds

SELECT COUNT(*) FROM "django_comments" WHERE ("django_comments"."site_id" = 2  AND "django_comments"."object_pk" = E'5'  AND "django_comments"."content_type_id" = 10  AND "django_comments"."is_public" = true  AND "django_comments"."is_removed" = false )

took 0.002 seconds

SELECT "django_comments"."id", "django_comments"."content_type_id", "django_comments"."object_pk", "django_comments"."site_id", "django_comments"."user_id", "django_comments"."user_name", "django_comments"."user_email", "django_comments"."user_url", "django_comments"."comment", "django_comments"."submit_date", "django_comments"."ip_address", "django_comments"."is_public", "django_comments"."is_removed" FROM "django_comments" WHERE ("django_comments"."site_id" = 2  AND "django_comments"."object_pk" = E'5'  AND "django_comments"."content_type_id" = 10  AND "django_comments"."is_public" = true  AND "django_comments"."is_removed" = false ) 
  ORDER BY "django_comments"."submit_date" ASC

took 0.002 seconds

SELECT "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_city" WHERE "gradovi_city"."id" = 5

took 0.000 seconds

Total SQL time: 0.037