Lisinski

Ulice
Firme
Osobe

Upišite ulicu i broj. Npr ilica 23

Upišite ulicu i broj. Npr ilica 100

Izdvojene lokacije

Ostale lokacije

Stranica 1 of 82. naprijed

Ulice
Firme

Nema događaja za lokaciju Lisinski.

Molim pričekajte ...

3 Komentara za Lisinski

lucija
Lis. 24, 2011 15:25

kojim tramvajem doći od trga kralja tomislava20 do jankomira 27 hotel holiday

lucija
Lis. 24, 2011 15:20

kojim tramvajem doći od trga kralja tomislava20 do hotela holiday 27jankomir

lucija
Lis. 24, 2011 15:17

kojim tramvajem doći od trga kralja tomislava20 do hotela holiday 27

Prethodna 1 Sljedeća

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

Server-time taken: 0.17804 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_location"."id", "gradovi_location"."name", "gradovi_location"."address", "gradovi_location"."lat", "gradovi_location"."lng", "gradovi_location"."description", "gradovi_location"."city_id", "gradovi_location"."slug" FROM "gradovi_location" WHERE "gradovi_location"."slug" = E'lisinski'

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"."name" = E'zagreb'

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" WHERE "gradovi_city"."id" = 1

took 0.000 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'zagreb'

took 0.029 seconds

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

took 0.003 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'zagreb'  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" FROM "dogadanja_event" WHERE ("dogadanja_event"."location_id" = 32  AND "dogadanja_event"."date" >= E'2012-05-18' ) 
  ORDER BY "dogadanja_event"."date" ASC

took 0.001 seconds

SELECT COUNT(*) FROM "django_comments" WHERE ("django_comments"."site_id" = 2  AND "django_comments"."object_pk" = E'32'  AND "django_comments"."content_type_id" = 12  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'32'  AND "django_comments"."content_type_id" = 12  AND "django_comments"."is_public" = true  AND "django_comments"."is_removed" = false ) 
  ORDER BY "django_comments"."submit_date" ASC

took 0.001 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" FROM "gradovi_location" WHERE "gradovi_location"."id" = 32

took 0.000 seconds

Total SQL time: 0.045