архив материалов
|
RSS
Карта сайта
Контакты
 
ЖИЗНЬ
Путешествия
Досуг
Светская жизнь
Мода & Стиль
Курьезы
Красота & Здоровье
Гурман
Гороскоп
RSS
Ошибка при выборе даных для . DataType = [LastArticles]
Incorrect syntax near the keyword 'and'. Incorrect syntax near the keyword 'and'.
Class : HotIce.Data.HIDataXmlError
UDI : all.news.ua/News:FULL
cache_file_namepASP.NET_SessionIdUCID_user_idAuthorizedUser.RowID@excludedArticleIdaddress_operationaddress_fieldsaddress_restrictionaddress_joinsaddress_orderaddress_groupaddress_maxaddress_is_distinctaddress_first__is_modify_order__query_for_viaddress_restriction_value_countspecific_looking_urludi_debug_store_last_sql_queryout_driverMAX_PAGE_COUNT_FOR_DATA
/life/p_1.htm1xs1pqbidn3sy12qos2gra04588d99e62-844d-40d6-9097-9709bd382550getcase when <#FULL_DATA_NAME#>.style <> '' then <#FULL_DATA_NAME#>.style else case when importance.css_class <> '' then importance.css_class + '' else '' end end as css_class, *, case when source.is_use_original_url = 1 then #.link else '/rubric/' + convert(varchar(4), year(#.date)) + '/' + convert(varchar(2), month(#.date)) + '/' + convert(varchar(2), day(#.date)) + '/razdel/' + convert(varchar(20), #._id) + '.htm' end as url, case when source.is_target_blank = 1 then 'blank' else '' end as target #._id != @excludedArticleId and #.rubric_id= and #._id>0 and isnull(#.import_source_id,'')='' and isnull(#.link,'') ='' and <#FULL_DATA_NAME#>.is_active = 1 and <#FULL_DATA_NAME#>.[date] <= getdate()|_parent_id section;section._id section_id, section.name section_name|topic_id topic;topic.name topic_name;;left|autor_id autor;autor.name autor_name, autor.descr autor_descr;;left|importance_id importance|import_source_id source;;;left1010TrueTrue0Trueselect top 20 IDENTITY(int, 1,1) AS __id, Convert(varchar(64), [hi_news_times].dbo.[_News]._id) as _id_as_str into #tmpTable from [hi_news_times].dbo.[_News] join [hi_news_times].dbo.[_Rubricator] as section on [hi_news_times].dbo.[_News]._parent_id = section._id left join [hi_news_times].dbo.[_Rubricator] as topic on [hi_news_times].dbo.[_News].topic_id = topic._id left join [hi_news_times].dbo.[_Autor] as autor on [hi_news_times].dbo.[_News].autor_id = autor._id join [hi_news_times].dbo.[_Importance] as importance on [hi_news_times].dbo.[_News].importance_id = importance._id left join [hi_news_times].dbo.[_Source_RSS] as source on [hi_news_times].dbo.[_News].import_source_id = source._id where ([hi_news_times].dbo.[_News]._id != @excludedArticleId and [hi_news_times].dbo.[_News].rubric_id= and [hi_news_times].dbo.[_News]._id>0 and isnull([hi_news_times].dbo.[_News].import_source_id,'')='' and isnull([hi_news_times].dbo.[_News].link,'') ='' and [hi_news_times].dbo.[_News].is_active = 1 and [hi_news_times].dbo.[_News].[date] <= getdate()) order by [hi_news_times].dbo.[_News].date desc select IDENTITY(int, 1,1) AS __id, _id_as_str AS _id into #tmpTable1 from (select top 20 * from #tmpTable order by __id) tmp select case when [hi_news_times].dbo.[_News].style <> '' then [hi_news_times].dbo.[_News].style else case when importance.css_class <> '' then importance.css_class + '' else '' end end as css_class, *, case when source.is_use_original_url = 1 then [hi_news_times].dbo.[_News].link else '/rubric/' + convert(varchar(4), year([hi_news_times].dbo.[_News].date)) + '/' + convert(varchar(2), month([hi_news_times].dbo.[_News].date)) + '/' + convert(varchar(2), day([hi_news_times].dbo.[_News].date)) + '/razdel/' + convert(varchar(20), [hi_news_times].dbo.[_News]._id) + '.htm' end as url, case when source.is_target_blank = 1 then 'blank' else '' end as target, section._id section_id, section.name section_name , topic.name topic_name , autor.name autor_name, autor.descr autor_descr from [hi_news_times].dbo.[_News] join [hi_news_times].dbo.[_Rubricator] as section on [hi_news_times].dbo.[_News]._parent_id = section._id left join [hi_news_times].dbo.[_Rubricator] as topic on [hi_news_times].dbo.[_News].topic_id = topic._id left join [hi_news_times].dbo.[_Autor] as autor on [hi_news_times].dbo.[_News].autor_id = autor._id join [hi_news_times].dbo.[_Importance] as importance on [hi_news_times].dbo.[_News].importance_id = importance._id left join [hi_news_times].dbo.[_Source_RSS] as source on [hi_news_times].dbo.[_News].import_source_id = source._id join #tmpTable1 on [hi_news_times].dbo.[_News]._id = #tmpTable1._id where ([hi_news_times].dbo.[_News]._id != @excludedArticleId and [hi_news_times].dbo.[_News].rubric_id= and [hi_news_times].dbo.[_News]._id>0 and isnull([hi_news_times].dbo.[_News].import_source_id,'')='' and isnull([hi_news_times].dbo.[_News].link,'') ='' and [hi_news_times].dbo.[_News].is_active = 1 and [hi_news_times].dbo.[_News].[date] <= getdate()) and #tmpTable1.__id > 10 order by __idMESSAGE30
TypeMessage
Ошибка при выборе даных для . DataType = [LastArticles]
Incorrect syntax near the keyword 'and'. Incorrect syntax near the keyword 'and'.
Class : HotIce.Data.HIDataXmlError
UDI : all.news.ua/News:FULL
cache_file_namepASP.NET_SessionIdUCID_user_idAuthorizedUser.RowID@excludedArticleIdaddress_operationaddress_fieldsaddress_restrictionaddress_joinsaddress_orderaddress_groupaddress_maxaddress_is_distinctaddress_first__is_modify_order__query_for_viaddress_restriction_value_countspecific_looking_urludi_debug_store_last_sql_queryout_driverMAX_PAGE_COUNT_FOR_DATA
/life/p_1.htm1xs1pqbidn3sy12qos2gra04588d99e62-844d-40d6-9097-9709bd382550getcase when <#FULL_DATA_NAME#>.style <> '' then <#FULL_DATA_NAME#>.style else case when importance.css_class <> '' then importance.css_class + '' else '' end end as css_class, *, case when source.is_use_original_url = 1 then #.link else '/rubric/' + convert(varchar(4), year(#.date)) + '/' + convert(varchar(2), month(#.date)) + '/' + convert(varchar(2), day(#.date)) + '/razdel/' + convert(varchar(20), #._id) + '.htm' end as url, case when source.is_target_blank = 1 then 'blank' else '' end as target #._id != @excludedArticleId and #.rubric_id= and #._id>0 and isnull(#.import_source_id,'')='' and isnull(#.link,'') ='' and <#FULL_DATA_NAME#>.is_active = 1 and <#FULL_DATA_NAME#>.[date] <= getdate()|_parent_id section;section._id section_id, section.name section_name|topic_id topic;topic.name topic_name;;left|autor_id autor;autor.name autor_name, autor.descr autor_descr;;left|importance_id importance|import_source_id source;;;left1010TrueTrue0Trueselect top 20 IDENTITY(int, 1,1) AS __id, Convert(varchar(64), [hi_news_times].dbo.[_News]._id) as _id_as_str into #tmpTable from [hi_news_times].dbo.[_News] join [hi_news_times].dbo.[_Rubricator] as section on [hi_news_times].dbo.[_News]._parent_id = section._id left join [hi_news_times].dbo.[_Rubricator] as topic on [hi_news_times].dbo.[_News].topic_id = topic._id left join [hi_news_times].dbo.[_Autor] as autor on [hi_news_times].dbo.[_News].autor_id = autor._id join [hi_news_times].dbo.[_Importance] as importance on [hi_news_times].dbo.[_News].importance_id = importance._id left join [hi_news_times].dbo.[_Source_RSS] as source on [hi_news_times].dbo.[_News].import_source_id = source._id where ([hi_news_times].dbo.[_News]._id != @excludedArticleId and [hi_news_times].dbo.[_News].rubric_id= and [hi_news_times].dbo.[_News]._id>0 and isnull([hi_news_times].dbo.[_News].import_source_id,'')='' and isnull([hi_news_times].dbo.[_News].link,'') ='' and [hi_news_times].dbo.[_News].is_active = 1 and [hi_news_times].dbo.[_News].[date] <= getdate()) order by [hi_news_times].dbo.[_News].date desc select IDENTITY(int, 1,1) AS __id, _id_as_str AS _id into #tmpTable1 from (select top 20 * from #tmpTable order by __id) tmp select case when [hi_news_times].dbo.[_News].style <> '' then [hi_news_times].dbo.[_News].style else case when importance.css_class <> '' then importance.css_class + '' else '' end end as css_class, *, case when source.is_use_original_url = 1 then [hi_news_times].dbo.[_News].link else '/rubric/' + convert(varchar(4), year([hi_news_times].dbo.[_News].date)) + '/' + convert(varchar(2), month([hi_news_times].dbo.[_News].date)) + '/' + convert(varchar(2), day([hi_news_times].dbo.[_News].date)) + '/razdel/' + convert(varchar(20), [hi_news_times].dbo.[_News]._id) + '.htm' end as url, case when source.is_target_blank = 1 then 'blank' else '' end as target, section._id section_id, section.name section_name , topic.name topic_name , autor.name autor_name, autor.descr autor_descr from [hi_news_times].dbo.[_News] join [hi_news_times].dbo.[_Rubricator] as section on [hi_news_times].dbo.[_News]._parent_id = section._id left join [hi_news_times].dbo.[_Rubricator] as topic on [hi_news_times].dbo.[_News].topic_id = topic._id left join [hi_news_times].dbo.[_Autor] as autor on [hi_news_times].dbo.[_News].autor_id = autor._id join [hi_news_times].dbo.[_Importance] as importance on [hi_news_times].dbo.[_News].importance_id = importance._id left join [hi_news_times].dbo.[_Source_RSS] as source on [hi_news_times].dbo.[_News].import_source_id = source._id join #tmpTable1 on [hi_news_times].dbo.[_News]._id = #tmpTable1._id where ([hi_news_times].dbo.[_News]._id != @excludedArticleId and [hi_news_times].dbo.[_News].rubric_id= and [hi_news_times].dbo.[_News]._id>0 and isnull([hi_news_times].dbo.[_News].import_source_id,'')='' and isnull([hi_news_times].dbo.[_News].link,'') ='' and [hi_news_times].dbo.[_News].is_active = 1 and [hi_news_times].dbo.[_News].[date] <= getdate()) and #tmpTable1.__id > 10 order by __idMESSAGE30
TypeMessage
 
 
style="font-size:18px; font-family:Arial"> Загрузка...
Спецтема
Самое читаемое
все новости
Гороскоп
 
Овен
(21.03-20.04)
Телец
(21.04-20.05)
Близнецы
(21.05-21.06)
Рак
(22.06-22.07)
Лев
(23.07-23.08)
Дева
(24.08-23.09)
Весы
(24.09-23.10)
Скорпион
(24.10-22.11)
Стрелец
(23.11-21.12)
Козерог
(22.12-20.01)
Водолей
(21.01-20.02)
Рыбы
(21.02-20.03)
 
Погода Киев -23°C    
Последние новости
В США из-за снега отменены 10 тысяч рейсов 30.12.10, 12:01
В Мексике открылся музей текилы 30.12.10, 11:56
Испанки массово требуют от врачей вызвать преждевременные роды 30.12.10, 11:35
Рианна рассталась с бойфрендом 30.12.10, 10:20
Американец пытался ограбить ресторан с помощью iPhone 30.12.10, 09:51
Сегодня на ТВ
00:00 Х/ф "Монтана".
TV1000 Русское кино
00:00 Х/ф "Конан-варвар".
1+1
00:00 Тайны судьбы.
Тонис
Телепрограмма на сегодня >>
Ошибка при выборе даных для . DataType = [DigestNews2]
Invalid column name 'double_calc'.
Class : HotIce.Data.HIDataXmlError
UDI : all.news.ua/News:FULL
cache_file_namepASP.NET_SessionIdUCID_user_idAuthorizedUser.RowID@excludedArticleIdaddress_operationaddress_fieldsaddress_restrictionaddress_joinsaddress_orderaddress_groupaddress_maxaddress_is_distinctaddress_first__is_modify_order__query_for_vidata_driver_table_aliasaddress_restriction_value_countspecific_looking_urludi_debug_store_last_sql_queryout_driverMAX_PAGE_COUNT_FOR_DATA
/life/p_1.htm1xs1pqbidn3sy12qos2gra04588d99e62-844d-40d6-9097-9709bd382550getcase when <#FULL_DATA_NAME#>.style <> '' then <#FULL_DATA_NAME#>.style else case when importance.css_class <> '' then importance.css_class + '' else '' end end as css_class, *, case when (datediff(mi, n1.[date], getdate())/cast(60 as float)) = 0 then n1.moder_koef else (n1.number_doubles + (cast(n2.count_stat as float)/100))/(datediff(mi, n1.[date], getdate())/cast(60 as float)) + n1.moder_koef end double_calc, case when source.is_use_original_url = 1 then #.link else '/rubric/' + convert(varchar(4), year(#.date)) + '/' + convert(varchar(2), month(#.date)) + '/' + convert(varchar(2), day(#.date)) + '/razdel/' + convert(varchar(20), #._id) + '.htm' end as url, case when source.is_target_blank = 1 then 'blank' else '' end as target #.link <> '' and <#FULL_DATA_NAME#>.is_active = 1 and <#FULL_DATA_NAME#>.[date] <= getdate()|sql:(<#SUB_QUERY:CALC_STAT#>) n2;;;left;_id;_id|_parent_id section;section._id section_id, section.name section_name|topic_id topic;topic.name topic_name;;left|autor_id autor;autor.name autor_name, autor.descr autor_descr;;left|importance_id importance|import_source_id source;;;leftdouble_calc desc, #.date desc1010TrueTruen10Trueselect top 20 IDENTITY(int, 1,1) AS __id, Convert(varchar(64), n1._id) as _id_as_str into #tmpTable from [hi_news_times].dbo.[_News] n1 left join ((select n._id, COUNT(*) count_stat from [hi_news_times].dbo.[_News] n left join [hi_news_times].dbo.[_News_Statistic] as ns on n._id = ns._parent_id where (n.[date] >= convert(datetime, convert(varchar, DATEADD(d, -2, GETDATE()), 104), 104)) group by n._id)) as n2 on n1._id = n2._id join [hi_news_times].dbo.[_Rubricator] as section on n1._parent_id = section._id left join [hi_news_times].dbo.[_Rubricator] as topic on n1.topic_id = topic._id left join [hi_news_times].dbo.[_Autor] as autor on n1.autor_id = autor._id join [hi_news_times].dbo.[_Importance] as importance on n1.importance_id = importance._id left join [hi_news_times].dbo.[_Source_RSS] as source on n1.import_source_id = source._id where (n1.link <> '' and n1.is_active = 1 and n1.[date] <= getdate()) order by n1.double_calc desc, n1.date desc select IDENTITY(int, 1,1) AS __id, _id_as_str AS _id into #tmpTable1 from (select top 20 * from #tmpTable order by __id) tmp select case when n1.style <> '' then n1.style else case when importance.css_class <> '' then importance.css_class + '' else '' end end as css_class, *, case when (datediff(mi, n1.[date], getdate())/cast(60 as float)) = 0 then n1.moder_koef else (n1.number_doubles + (cast(n2.count_stat as float)/100))/(datediff(mi, n1.[date], getdate())/cast(60 as float)) + n1.moder_koef end double_calc, case when source.is_use_original_url = 1 then n1.link else '/rubric/' + convert(varchar(4), year(n1.date)) + '/' + convert(varchar(2), month(n1.date)) + '/' + convert(varchar(2), day(n1.date)) + '/razdel/' + convert(varchar(20), n1._id) + '.htm' end as url, case when source.is_target_blank = 1 then 'blank' else '' end as target, section._id section_id, section.name section_name , topic.name topic_name , autor.name autor_name, autor.descr autor_descr from [hi_news_times].dbo.[_News] n1 left join ((select n._id, COUNT(*) count_stat from [hi_news_times].dbo.[_News] n left join [hi_news_times].dbo.[_News_Statistic] as ns on n._id = ns._parent_id where (n.[date] >= convert(datetime, convert(varchar, DATEADD(d, -2, GETDATE()), 104), 104)) group by n._id)) as n2 on n1._id = n2._id join [hi_news_times].dbo.[_Rubricator] as section on n1._parent_id = section._id left join [hi_news_times].dbo.[_Rubricator] as topic on n1.topic_id = topic._id left join [hi_news_times].dbo.[_Autor] as autor on n1.autor_id = autor._id join [hi_news_times].dbo.[_Importance] as importance on n1.importance_id = importance._id left join [hi_news_times].dbo.[_Source_RSS] as source on n1.import_source_id = source._id join #tmpTable1 on n1._id = #tmpTable1._id where (n1.link <> '' and n1.is_active = 1 and n1.[date] <= getdate()) and #tmpTable1.__id > 10 order by __idMESSAGE30
TypeMessage
Горячие предложения
Погода, Новости, загрузка...
Загрузка...
Все проекты ЛIГА.net
 
Новости
Политика
Экономика
Общество
Происшествия
Мир
Культура
Спорт
Столица
Финансы
Финансовый супермаркет
Курс валют
Курс валют НБУ
Банковские металлы
Конвертер валют
Ставки НБУ
Торги на UX
Торги на ПФТС
Финансовые новости
Цены на нефть
Рынки BIZ.liga.net
Недвижимость
IT
Авто
Потребительские товары
Карьера и Образование
Лента реальных зарплат
Деловое общение
Интернет-конференции
ЛІГА Экспертов
Блоги
Форумы
Юридический бизнес-форум
Бухгалтерские посиделки
Финансовый форум
Политфорум
Автофорум
Проекты
Мониторинг СМИ
Досье Персоны
Досье Компании
Досье Регионы
Досье Партии
Рейтинги
Праздники
Отдых и туризм
Телепрограмма
Чемпионат мира
по футболу 2010
Поздравления с 8 марта
Погода
Группа компаний ЛІГА
ЛІГА.net
ЛІГА:ЗАКОН
ИА ЛІГАБізнесІнформ
Пресс-центр
Рекламная сеть AdRock
 
О проекте Реклама Обратная связь Правила комментирования
bigmir)net TOP 100 Система Orphus
© Газета "СЕЙЧАС", 2011
© Информационное агентство ЛIГАБiзнесIнформ, 2007-2011
© Информационно-аналитический центр "ЛІГА", 1991-2011

Перепечатка каких-либо материалов со страниц Интернет-газеты "СЕЙЧАС" запрещена. Использование материалов возможно только с разрешения редакций, которым принадлежат авторские права на материалы, обозреваемые на страницах Интернет-газеты "СЕЙЧАС".