| Sled napake: |
| Datoteka: | /home/trzin/domains/trzin.si/public_html/models/Factory.php | | Vrstica: | 64 | | Spremeljivke: | 1 =>
SELECT t1.* , t3.group_arr, t5.tags_arr
FROM table_news AS t1
LEFT JOIN
(
SELECT t2.element_id, concat( group_concat( t2.group_id ) ) AS group_arr
FROM table_restrictions AS t2
WHERE `type` = 'news'
GROUP BY t2.element_id
) AS t3 ON t3.element_id = t1.news_id
LEFT JOIN
(
SELECT t4.element_id, concat( group_concat( t4.tag_id ) ) AS tags_arr
FROM table_tags_elements_map AS t4
WHERE `element_type` = 'news'
GROUP BY t4.element_id
) AS t5 ON t5.element_id=t1.news_id
WHERE t1.lang='' AND t1.state=1 AND t1.status=0 AND t1.access <= '1' AND
(CASE
WHEN (t3.group_arr!='' AND ''!='999' AND t1.access = 3) THEN FIND_IN_SET('',t3.group_arr)
ELSE 1=1
END
)
AND CASE
WHEN (t1.date_from='0000-00-00 00:00:00' AND t1.date_to!='0000-00-00 00:00:00') THEN
CASE
WHEN t1.time_to='00:00:00' THEN (t1.date_to + INTERVAL 1 DAY)>NOW()
ELSE ADDTIME(t1.date_to, t1.time_to)>NOW()
END
WHEN (t1.date_from!='0000-00-00 00:00:00' AND t1.date_to='0000-00-00 00:00:00') THEN
CASE
WHEN t1.time_from='00:00:00' THEN t1.date_fromNOW() AND t1.date_fromNOW())
WHEN t1.time_from!='00:00:00' AND t1.time_to='00:00:00' THEN (ADDTIME(t1.date_from, t1.time_from)NOW())
ELSE 1=1
END
ELSE 1=1
END ORDER BY t1.sort_id desc
LIMIT 1
| | Datoteka: | /home/trzin/domains/trzin.si/public_html/models/Factory/News.php | | Vrstica: | 30 | | Spremeljivke: | 1 =>
SELECT t1.* , t3.group_arr, t5.tags_arr
FROM table_news AS t1
LEFT JOIN
(
SELECT t2.element_id, concat( group_concat( t2.group_id ) ) AS group_arr
FROM table_restrictions AS t2
WHERE `type` = 'news'
GROUP BY t2.element_id
) AS t3 ON t3.element_id = t1.news_id
LEFT JOIN
(
SELECT t4.element_id, concat( group_concat( t4.tag_id ) ) AS tags_arr
FROM table_tags_elements_map AS t4
WHERE `element_type` = 'news'
GROUP BY t4.element_id
) AS t5 ON t5.element_id=t1.news_id
WHERE t1.lang='' AND t1.state=1 AND t1.status=0 AND t1.access <= '1' AND
(CASE
WHEN (t3.group_arr!='' AND ''!='999' AND t1.access = 3) THEN FIND_IN_SET('',t3.group_arr)
ELSE 1=1
END
)
AND CASE
WHEN (t1.date_from='0000-00-00 00:00:00' AND t1.date_to!='0000-00-00 00:00:00') THEN
CASE
WHEN t1.time_to='00:00:00' THEN (t1.date_to + INTERVAL 1 DAY)>NOW()
ELSE ADDTIME(t1.date_to, t1.time_to)>NOW()
END
WHEN (t1.date_from!='0000-00-00 00:00:00' AND t1.date_to='0000-00-00 00:00:00') THEN
CASE
WHEN t1.time_from='00:00:00' THEN t1.date_fromNOW() AND t1.date_fromNOW())
WHEN t1.time_from!='00:00:00' AND t1.time_to='00:00:00' THEN (ADDTIME(t1.date_from, t1.time_from)NOW())
ELSE 1=1
END
ELSE 1=1
END ORDER BY t1.sort_id desc
LIMIT 1
| | Datoteka: | /home/trzin/domains/trzin.si/public_html/news.php | | Vrstica: | 56 | | Spremeljivke: | 1 => limit=1
| | Datoteka: | /home/trzin/domains/trzin.si/public_html/index.php | | Vrstica: | 35 | | Spremeljivke: | 1 => /home/trzin/domains/trzin.si/public_html/news.php
|
|
