А как будет более правильнее реализовать?

nkostya 22.03.2004 21:36

По вашему, как предложили вы, или...

$calendar[^MAIN:pSQL.sql[table][
	SELECT
		^MAIN:pSQL.date_format[dt_published;%Y] as dt_year,
		^MAIN:pSQL.date_format[dt_published;%m] as dt_month,
		MIN(is_published) as all_is_published
	FROM
		news
	WHERE
		^if(!^MAIN:check_right($OBJECT_ID)(4|8)){is_published = '1' AND}
		news_type_id = '^news_type_id.int(1)'
	GROUP BY
		dt_year DESC,
		dt_month DESC
]]
$calendar_hash[^calendar.hash[dt_year][$.distinct[tables]]]

---