SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 698 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 217
function: city_id_home
city = get_object_or_404(City, id = city_id)
SELECT `locals_province`.`id`, `locals_province`.`prov_code`, `locals_province`.`prov_name`,
`locals_province`.`id_nation_id`, `locals_province`.`istatt_code`, `locals_province`.`latitude`,
`locals_province`.`longitude` FROM `locals_province` WHERE `locals_province`.`id` = 13 ORDER BY
`locals_province`.`prov_name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 222
function: city_id_home
provinces = Province.objects.filter(id = city.province.id)
SELECT `django_content_type`.`id`, `django_content_type`.`name`, `django_content_type`.`app_label`,
`django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`model` = announces AND
`django_content_type`.`app_label` = mediaon_announces ) ORDER BY `django_content_type`.`name` ASC
took 0.001 seconds
module: context_processors
file: /var/mediaon/www/tribes/mediaon/announces/webframework/tribes_framework/context_processors.py
line: 112
function: case_in_festa_settings
'ANNOUNCES_CONTENT_TYPE_ID' : ContentType.objects.get(app_label="mediaon_announces",
model="announces").id,
SELECT `mediaon_announces_announces`.`id`, `mediaon_announces_announces`.`category_id`,
`mediaon_announces_announces`.`province_id`, `mediaon_announces_announces`.`city_id`,
`mediaon_announces_announces`.`hamlet_id`, `mediaon_announces_announces`.`address`,
`mediaon_announces_announces`.`sender_id`, `mediaon_announces_announces`.`created`,
`mediaon_announces_announces`.`updated`, `mediaon_announces_announces`.`pub_date`,
`mediaon_announces_announces`.`title`, `mediaon_announces_announces`.`text`, `mediaon_announces_announces`.`is_private`,
`mediaon_announces_announces`.`moderated`, `mediaon_announces_announces`.`is_publishable`,
`mediaon_announces_announces`.`pubblished`, `mediaon_announces_announces`.`deleted`,
`mediaon_announces_announces`.`auto_publish`, `mediaon_announces_announces`.`email`,
`mediaon_announces_announces`.`under_age` FROM `mediaon_announces_announces` INNER JOIN
`mediaon_announces_announces_site` ON (`mediaon_announces_announces`.`id` =
`mediaon_announces_announces_site`.`announces_id`) WHERE (`mediaon_announces_announces`.`deleted` = False AND
`mediaon_announces_announces`.`auto_publish` = False AND `mediaon_announces_announces_site`.`site_id` = 17 AND
`mediaon_announces_announces`.`moderated` = False AND `mediaon_announces_announces`.`pub_date` BETWEEN 2019-04-20 and
2019-08-18 AND `mediaon_announces_announces`.`is_private` = False AND `mediaon_announces_announces`.`city_id` = 698 )
ORDER BY `mediaon_announces_announces`.`pub_date` DESC, `mediaon_announces_announces`.`created` DESC
took 0.006 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 139307 ) ORDER BY `photos_image`.`date_added` DESC
took 0.002 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 698 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 6
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 136989 ) ORDER BY `photos_image`.`date_added` DESC
took 0.002 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 698 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 6
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 136473 ) ORDER BY `photos_image`.`date_added` DESC
took 0.002 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 698 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 3
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 135941 ) ORDER BY `photos_image`.`date_added` DESC
took 0.002 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 698 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 3
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_province`.`id`, `locals_province`.`prov_code`, `locals_province`.`prov_name`,
`locals_province`.`id_nation_id`, `locals_province`.`istatt_code`, `locals_province`.`latitude`,
`locals_province`.`longitude` FROM `locals_province` WHERE `locals_province`.`id_nation_id` = 1 ORDER BY
`locals_province`.`prov_name` ASC
took 0.002 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`province_id` = 13 ORDER BY `locals_city`.`city` ASC
took 0.017 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_province`.`id`, `locals_province`.`prov_code`, `locals_province`.`prov_name`,
`locals_province`.`id_nation_id`, `locals_province`.`istatt_code`, `locals_province`.`latitude`,
`locals_province`.`longitude` FROM `locals_province` WHERE `locals_province`.`id_nation_id` = 1 ORDER BY
`locals_province`.`prov_name` ASC
took 0.002 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`province_id` = 13 ORDER BY `locals_city`.`city` ASC
took 0.015 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
