Next Generation CMS :: Форум поддержки

SELECT COUNT( * ) 
FROM  `ng_news` 
WHERE 1

COUNT(*)
30608

SELECT * 
FROM ng_news
WHERE (
approve >0
)
AND (
(
catid REGEXP  '[[:<:]](1)[[:>:]]'
)
)
ORDER BY RAND( ) 
LIMIT 0 , 6

( Запрос занял 0.2249 сек. )

SELECT * FROM ng_news WHERE ((catid regexp '[[:<:]](18)[[:>:]]')) AND (approve > 0) ORDER BY rand()

SELECT * FROM ng_news WHERE ((catid regexp '[[:<:]](18)[[:>:]]')) AND (approve != 0) ORDER BY rand()

AddDefaultCharset WINDOWS-1251

		{% if isHandler('news:news') or isHandler('compare') %}
		<div id="zingaya" style="width: 39px; display: block;">
		<a id="zingayaCl" title="Свернуть" style="display: none;">x</a>
		<div style="width: 100%; height: 1px; clear: both;"></div>
		<a id="zingayaHd" title="Показать" style="display: block;"></a>
		<div id="btn-cmp" style="display: none;">
		<div id="listCMP"></div>
		<button onclick="addtoCMP('{{system_flags.info.title.item}}'); return false;">Добавить</button>
		<button onclick="clearCMPlist(); return false;">Очистить</button>
		<button onclick="window.open('{{home}}/plugin/compare/')">Сравнить</button>
		</div>
		</div>
		<script type="text/javascript" src="{{ tpl_url }}/js/compare.js"></script>
		{% endif %}