string(1423) "
SELECT
n.news_id,
n.domain_id,
n.parent_id,
n.news_name,
n.news_name_url,
n.lupdd,
n.news_lead_img,
REPLACE(n.news_lead_img,SUBSTRING(n.news_lead_img,(LENGTH(n.news_lead_img) - (LOCATE('/', REVERSE(n.news_lead_img)) - 2))) ,CONCAT('_thumbs/',SUBSTRING(n.news_lead_img,(LENGTH(n.news_lead_img) - (LOCATE('/', REVERSE(n.news_lead_img)) - 2))))) AS news_lead_img_thumb,
n.news_lead_img_desc,
n.news_lead,
n.news_author,
n.hide_date,
n.news_pub_date,
n.news_pub_end_date,
n.news_calendar_date,
n.news_calendar_date_end,
n.news_group_id,
n.news_calendar_date as news_event,
n.has_video,
n.has_gallery,
n.has_map,
n.has_poll,
n.has_image,
n.has_attachment,
UNIX_TIMESTAMP(lupdd) AS lupdd_timestamp
FROM cms_news n
LEFT JOIN cms_news_group_conn ngc ON (n.news_id = ngc.news_id)
WHERE ngc.news_group_id = 6332
AND n.news_status = 'public'
GROUP BY n.news_id
ORDER BY n.pin DESC, n.news_date DESC, n.news_id DESC
LIMIT 5"
| ed( SELECT n.news_id, n.domain_id, n.parent_id, n.news_...) - PublicNews.class.php:1355
PublicNewsMain.getNewsList2() - theme6_News.class.php:97
PublicNews.getNewsList(false) - PublicNews.class.php:1067
PublicNewsMain.showNewsList(false) - theme6_News.class.php:66
PublicNews.showNewsSlideswide(Array[13]) - PublicPage.class.php:390
PublicPageMain.preperHtmlContent(Array[13], Array[1]) - PublicPage.class.php:319
PublicPageMain.getAllElementsContent() - PublicPage.class.php:99
PublicPageMain.showPublicView() - index.php:74
|
