| 1 | SET NAMES 'UTF8' | | 0 | | 0 |
| 2 | SELECT `News`.`id`, `News`.`above_title`, `News`.`title`, `News`.`below_title`, `News`.`seo_title`, `News`.`description`, `News`.`snapshot`, `News`.`body`, `News`.`author`, `News`.`picture_description`, `News`.`picture_author`, `News`.`date_start`, `News`.`modified`, `News`.`created_by`, `News`.`comments_status`, `News`.`preffered_image_size`, `News`.`news_view_type`, `News`.`link_gallery`, `News`.`link_forum`, `News`.`link_video`, `Category`.`name`, `Category`.`seo_name`, `Category`.`path`, `Category`.`id`, `Category`.`parent_id` FROM `news` AS `News` LEFT JOIN `categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) WHERE `News`.`published` = 1 AND `News`.`date_start` <= NOW() AND `News`.`id` = 153671 ORDER BY `News`.`id` ASC LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `Comment`.`id`, `Comment`.`content_type`, `Comment`.`content_id`, `Comment`.`content_url`, `Comment`.`parent_id`, `Comment`.`user_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`web`, `Comment`.`ip`, `Comment`.`body`, `Comment`.`facebook_id`, `Comment`.`facebook_pic`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`checked`, `Comment`.`published`, `Comment`.`content_published`, `Comment`.`notified` FROM `comments` AS `Comment` WHERE `Comment`.`content_type`='News' AND `Comment`.`content_id` IN (153671) | | 0 | 0 | 0 |
| 4 | SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`name`, `Tag`.`featured`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`modified_by`, `Tag`.`created_by` FROM `tags` AS `Tag` JOIN `content_tags` ON (`content_tags`.`content_id` = 153671 AND `content_tags`.`tag_id` = `Tag`.`id`) WHERE content_type='News' | | 30 | 30 | 1 |
| 5 | SELECT `Images`.`id`, `Images`.`name`, `Images`.`path`, `Images`.`description`, `content_repository`.`description` FROM `repositories` AS `Images` JOIN `content_repository` ON (`content_repository`.`content_id` = 153671 AND `content_repository`.`repository_id` = `Images`.`id`) WHERE `content_repository`.`content_type`='News' AND `Images`.`type`='image' ORDER BY `content_repository`.`main` DESC, `content_repository`.`sort` ASC | | 1 | 1 | 0 |
| 6 | SELECT `Videos`.`id`, `Videos`.`name`, `Videos`.`path`, `Videos`.`description` FROM `repositories` AS `Videos` JOIN `content_repository` ON (`content_repository`.`content_id` = 153671 AND `content_repository`.`repository_id` = `Videos`.`id`) WHERE `content_repository`.`content_type`='News' AND `Videos`.`type`='Media' ORDER BY `content_repository`.`sort` ASC | | 0 | 0 | 1 |
| 7 | SELECT `Files`.`id`, `Files`.`name`, `Files`.`path`, `Files`.`description` FROM `repositories` AS `Files` JOIN `content_repository` ON (`content_repository`.`content_id` = 153671 AND `content_repository`.`repository_id` = `Files`.`id`) WHERE `content_repository`.`content_type`='News' AND `Files`.`type`<>'image' AND `Files`.`type`<>'media' ORDER BY `content_repository`.`sort` ASC | | 0 | 0 | 0 |
| 8 | SELECT `Comment`.`id`, `Comment`.`content_type`, `Comment`.`content_id`, `Comment`.`content_url`, `Comment`.`parent_id`, `Comment`.`user_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`web`, `Comment`.`ip`, `Comment`.`body`, `Comment`.`facebook_id`, `Comment`.`facebook_pic`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`checked`, `Comment`.`published`, `Comment`.`content_published`, `Comment`.`notified`, `User`.`id`, `User`.`level_id`, `User`.`username`, `User`.`password`, `User`.`token`, `User`.`token_expires`, `User`.`email`, `User`.`created`, `User`.`modified`, `User`.`created_by`, `User`.`modified_by`, `User`.`last_visit`, `User`.`last_hit`, `User`.`newsletter`, `User`.`visits`, `User`.`authenticated`, `User`.`active` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`published`=1 AND `Comment`.`content_type`='News' AND `Comment`.`content_id`=153671 ORDER BY `Comment`.`created` DESC LIMIT 200 | | 0 | 0 | 1 |
| 9 | SELECT `News`.`date_start`, `News`.`id` FROM `news` AS `News` LEFT JOIN `categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `languages` AS `Language` ON (`News`.`language_id` = `Language`.`id`) LEFT JOIN `users` AS `User` ON (`News`.`created_by` = `User`.`id`) WHERE `News`.`id` = 153671 LIMIT 1 | | 1 | 1 | 0 |
| 10 | SELECT `Repository`.`name`, `Repository`.`id`, `Repository`.`path`, `Repository`.`type`, `Repository`.`ext`, `Repository`.`description`, `content_repository`.`description` FROM `repositories` AS `Repository` JOIN `content_repository` ON (`content_repository`.`content_id` = 153671 AND `content_repository`.`repository_id` = `Repository`.`id`) WHERE content_type='News' ORDER BY `content_repository`.`sort` ASC | | 1 | 1 | 1 |
| 11 | SELECT `News`.`date_start`, `News`.`id` FROM `news` AS `News` LEFT JOIN `categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `languages` AS `Language` ON (`News`.`language_id` = `Language`.`id`) LEFT JOIN `users` AS `User` ON (`News`.`created_by` = `User`.`id`) WHERE `News`.`published`=1 AND `News`.`date_start` <= NOW() AND `Category`.`id`=256 AND date_start < '2025-10-05 08:10:00' ORDER BY `date_start` DESC LIMIT 1 | | 1 | 1 | 1 |
| 12 | SELECT `News`.`date_start`, `News`.`id` FROM `news` AS `News` LEFT JOIN `categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `languages` AS `Language` ON (`News`.`language_id` = `Language`.`id`) LEFT JOIN `users` AS `User` ON (`News`.`created_by` = `User`.`id`) WHERE `News`.`published`=1 AND `News`.`date_start` <= NOW() AND `Category`.`id`=256 AND date_start > '2025-10-05 08:10:00' ORDER BY `date_start` ASC LIMIT 1 | | 1 | 1 | 1 |
| 13 | SELECT `News`.`id`, `News`.`category_id`, `News`.`language_id`, `News`.`title`, `News`.`above_title`, `News`.`below_title`, `News`.`seo_title`, `News`.`description`, `News`.`snapshot`, `News`.`body`, `News`.`author`, `News`.`main_image`, `News`.`date_start`, `News`.`date_end`, `News`.`comments_status`, `News`.`rating_cache`, `News`.`news_view_type`, `News`.`comments_count`, `News`.`hits`, `News`.`created`, `News`.`modified`, `News`.`modified_by`, `News`.`created_by`, `News`.`recyclebin`, `News`.`ready`, `News`.`featured`, `News`.`published`, `News`.`link_video`, `News`.`link_gallery`, `News`.`link_forum`, `News`.`frontpage_sort`, `News`.`category_sort`, `News`.`vijesti_sort`, `News`.`zivot_sort`, `News`.`reflektor_sort`, `News`.`sport_sort`, `News`.`preffered_image_size`, `News`.`preffered_frontpage_image_size`, `News`.`tmp`, `News`.`picture_author`, `News`.`picture_description`, `Category`.`id`, `Category`.`parent_id`, `Category`.`section_id`, `Category`.`content_type`, `Category`.`latest_category_box_show`, `Category`.`virtual_category`, `Category`.`virtual_category_sort_box`, `Category`.`path`, `Category`.`layout`, `Category`.`name`, `Category`.`seo_name`, `Category`.`description`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`sort`, `Category`.`published`, `Category`.`payway_id`, `Language`.`id`, `Language`.`name`, `Language`.`short_name`, `Language`.`locale`, `Language`.`active`, `Language`.`created`, `Language`.`modified`, `User`.`id`, `User`.`level_id`, `User`.`username`, `User`.`password`, `User`.`token`, `User`.`token_expires`, `User`.`email`, `User`.`created`, `User`.`modified`, `User`.`created_by`, `User`.`modified_by`, `User`.`last_visit`, `User`.`last_hit`, `User`.`newsletter`, `User`.`visits`, `User`.`authenticated`, `User`.`active` FROM `news` AS `News` LEFT JOIN `categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `languages` AS `Language` ON (`News`.`language_id` = `Language`.`id`) LEFT JOIN `users` AS `User` ON (`News`.`created_by` = `User`.`id`) WHERE `News`.`id` = 153686 LIMIT 1 | | 1 | 1 | 1 |
| 14 | SELECT `Comment`.`id`, `Comment`.`content_type`, `Comment`.`content_id`, `Comment`.`content_url`, `Comment`.`parent_id`, `Comment`.`user_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`web`, `Comment`.`ip`, `Comment`.`body`, `Comment`.`facebook_id`, `Comment`.`facebook_pic`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`checked`, `Comment`.`published`, `Comment`.`content_published`, `Comment`.`notified` FROM `comments` AS `Comment` WHERE `Comment`.`content_type`='News' AND `Comment`.`content_id` IN (153686) | | 0 | 0 | 1 |
| 15 | SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`name`, `Tag`.`featured`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`modified_by`, `Tag`.`created_by` FROM `tags` AS `Tag` JOIN `content_tags` ON (`content_tags`.`content_id` = 153686 AND `content_tags`.`tag_id` = `Tag`.`id`) WHERE content_type='News' | | 2 | 2 | 1 |
| 16 | SELECT `Repository`.`name`, `Repository`.`id`, `Repository`.`path`, `Repository`.`type`, `Repository`.`ext`, `Repository`.`description`, `content_repository`.`description` FROM `repositories` AS `Repository` JOIN `content_repository` ON (`content_repository`.`content_id` = 153686 AND `content_repository`.`repository_id` = `Repository`.`id`) WHERE content_type='News' ORDER BY `content_repository`.`sort` ASC | | 1 | 1 | 0 |
| 17 | SELECT `News`.`id`, `News`.`category_id`, `News`.`language_id`, `News`.`title`, `News`.`above_title`, `News`.`below_title`, `News`.`seo_title`, `News`.`description`, `News`.`snapshot`, `News`.`body`, `News`.`author`, `News`.`main_image`, `News`.`date_start`, `News`.`date_end`, `News`.`comments_status`, `News`.`rating_cache`, `News`.`news_view_type`, `News`.`comments_count`, `News`.`hits`, `News`.`created`, `News`.`modified`, `News`.`modified_by`, `News`.`created_by`, `News`.`recyclebin`, `News`.`ready`, `News`.`featured`, `News`.`published`, `News`.`link_video`, `News`.`link_gallery`, `News`.`link_forum`, `News`.`frontpage_sort`, `News`.`category_sort`, `News`.`vijesti_sort`, `News`.`zivot_sort`, `News`.`reflektor_sort`, `News`.`sport_sort`, `News`.`preffered_image_size`, `News`.`preffered_frontpage_image_size`, `News`.`tmp`, `News`.`picture_author`, `News`.`picture_description`, `Category`.`id`, `Category`.`parent_id`, `Category`.`section_id`, `Category`.`content_type`, `Category`.`latest_category_box_show`, `Category`.`virtual_category`, `Category`.`virtual_category_sort_box`, `Category`.`path`, `Category`.`layout`, `Category`.`name`, `Category`.`seo_name`, `Category`.`description`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`sort`, `Category`.`published`, `Category`.`payway_id`, `Language`.`id`, `Language`.`name`, `Language`.`short_name`, `Language`.`locale`, `Language`.`active`, `Language`.`created`, `Language`.`modified`, `User`.`id`, `User`.`level_id`, `User`.`username`, `User`.`password`, `User`.`token`, `User`.`token_expires`, `User`.`email`, `User`.`created`, `User`.`modified`, `User`.`created_by`, `User`.`modified_by`, `User`.`last_visit`, `User`.`last_hit`, `User`.`newsletter`, `User`.`visits`, `User`.`authenticated`, `User`.`active` FROM `news` AS `News` LEFT JOIN `categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `languages` AS `Language` ON (`News`.`language_id` = `Language`.`id`) LEFT JOIN `users` AS `User` ON (`News`.`created_by` = `User`.`id`) WHERE `News`.`id` = 153652 LIMIT 1 | | 1 | 1 | 1 |
| 18 | SELECT `Comment`.`id`, `Comment`.`content_type`, `Comment`.`content_id`, `Comment`.`content_url`, `Comment`.`parent_id`, `Comment`.`user_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`web`, `Comment`.`ip`, `Comment`.`body`, `Comment`.`facebook_id`, `Comment`.`facebook_pic`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`checked`, `Comment`.`published`, `Comment`.`content_published`, `Comment`.`notified` FROM `comments` AS `Comment` WHERE `Comment`.`content_type`='News' AND `Comment`.`content_id` IN (153652) | | 0 | 0 | 0 |
| 19 | SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`name`, `Tag`.`featured`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`modified_by`, `Tag`.`created_by` FROM `tags` AS `Tag` JOIN `content_tags` ON (`content_tags`.`content_id` = 153652 AND `content_tags`.`tag_id` = `Tag`.`id`) WHERE content_type='News' | | 1 | 1 | 1 |
| 20 | SELECT `Repository`.`name`, `Repository`.`id`, `Repository`.`path`, `Repository`.`type`, `Repository`.`ext`, `Repository`.`description`, `content_repository`.`description` FROM `repositories` AS `Repository` JOIN `content_repository` ON (`content_repository`.`content_id` = 153652 AND `content_repository`.`repository_id` = `Repository`.`id`) WHERE content_type='News' ORDER BY `content_repository`.`sort` ASC | | 1 | 1 | 0 |
| 21 | SELECT `Category`.`id` FROM `categories` AS `Category` WHERE `Category`.`published` = 1 AND `Category`.`parent_id` = 256 | | 3 | 3 | 0 |
| 22 |
SELECT `News`.`id`, `News`.`title`, `News`.`seo_title`, `News`.`description`, `News`.`body`,
`News`.`author`,`News`.`comments_count`,`News`.`date_start`,
`News`.`snapshot`, `News`.`above_title`, `News`.`below_title`, `News`.`preffered_image_size`,
`Category`.`name`,`Category`.`path`,
`MainPhoto`.`name`, `MainPhoto`.`path`,`MainPhoto`.`id` ,`MainPhoto`.`description`,
`News`.`title` AS SortName
FROM `news` AS `News`
LEFT JOIN `categories` AS `Category` ON ( `Category`.`published` = '1' AND `Category`.`id` = `News`.`category_id` )
LEFT JOIN `content_repository` ON (`content_repository`.`content_id`=`News`.`id` AND `content_repository`.`content_type` = 'News' AND `content_repository`.`main` = '1')
LEFT JOIN `repositories` AS `MainPhoto` ON `content_repository`.`repository_id`=`MainPhoto`.`id`
WHERE `News`.`category_id` IN (256,327,413,415) AND `News`.`published` = '1' AND `News`.`date_start` <= '2025-12-29 21:37:00'
AND `News`.`id`<>153671
ORDER BY News.date_start DESC LIMIT 0, 5 | | 5 | 5 | 1 |
| 23 | SELECT COUNT(*) AS `count` FROM `content_gallery` AS `ContentGallery` WHERE `ContentGallery`.`content_type`='News' AND `ContentGallery`.`content_id`=153671 | | 1 | 1 | 0 |
| 24 | SELECT `ContentGallery`.`id`, `ContentGallery`.`content_type`, `ContentGallery`.`content_id`, `ContentGallery`.`gallery_id`, `ContentGallery`.`sort`, `ContentGallery`.`description`, `Gallery`.`id`, `Gallery`.`category_id`, `Gallery`.`parent_id`, `Gallery`.`language_id`, `Gallery`.`title`, `Gallery`.`seo_title`, `Gallery`.`description`, `Gallery`.`snapshot`, `Gallery`.`main_image`, `Gallery`.`show_on_front`, `Gallery`.`show_in_mediabox`, `Gallery`.`layout`, `Gallery`.`date_start`, `Gallery`.`hits`, `Gallery`.`comments_status`, `Gallery`.`rating_cache`, `Gallery`.`password`, `Gallery`.`token`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`modified_by`, `Gallery`.`created_by`, `Gallery`.`sort`, `Gallery`.`featured`, `Gallery`.`published`, `Gallery`.`comments_count` FROM `content_gallery` AS `ContentGallery` LEFT JOIN `galleries` AS `Gallery` ON (`Gallery`.`published`=1 AND `ContentGallery`.`gallery_id` = `Gallery`.`id`) WHERE `ContentGallery`.`content_type`='News' AND `ContentGallery`.`content_id`=153671 ORDER BY `ContentGallery`.`sort` ASC LIMIT 3 | | 0 | 0 | 1 |
Novi komentar