Производители

Всё сломалось!

Класс: DB

engine::run();
engine::runComp("catcontent");
catcontent::run();
cTemplate::tplFetch("main");
Smarty_Internal_TemplateBase::fetch("main.html");
Smarty_Internal_TemplateBase::_execute([object],[object],[object],[object],[object]);
Smarty_Internal_Template::render([object],[object]);
Smarty_Template_Compiled::render([object]);
Smarty_Template_Resource_Base::getRenderedTemplateCode([object]);
::content_6290b459af6067_34522475([object]);
Smarty_Internal_Template::_subTemplateRender("file:./outer/default.html",[object],[object],[object],[object],[object],[object],[object]);
Smarty_Internal_Template::render();
Smarty_Template_Compiled::render([object]);
Smarty_Template_Resource_Base::getRenderedTemplateCode([object]);
::content_6762a3cb838ad3_99917632([object]);
Smarty_Internal_Template::_subTemplateRender("file:./../brands.html",[object],[object],[object],[object],[object],[object],[object]);
Smarty_Internal_Template::render();
Smarty_Template_Compiled::render([object]);
Smarty_Template_Resource_Base::getRenderedTemplateCode([object]);
::content_5ebfeac8a9d037_14982418([object]);
::smarty_function_exec([object],[object]);
engine::runComp("catblock",[object]);
catblock::run();
catblock::getItems();
DB::execSQL("SELECT
					cat_data_to_sect_rel.item_id,
					cat_common_props.title,
					ccp_parent.title parent_title,
					cat_common_props.url,
					cat_common_props.target,
					cat_common_props.modify_ts,
					cat_common_props.access,
					cat_common_props.data_cache,
					cat_common_props.data_cache_ts,
					count(comments.id) rating_count,
					avg(comments.rating) rating_avg
				FROM cat_data_to_sect_rel
					LEFT JOIN cat_common_props ON cat_data_to_sect_rel.item_id=cat_common_props.item_id
					LEFT JOIN cat_access ON cat_common_props.item_id=cat_access.item_id
					LEFT JOIN comments ON cat_data_to_sect_rel.item_id=comments.object_id AND comments.moderated=1 AND comments.rating>0
					LEFT JOIN cat_sect_tree ON cat_data_to_sect_rel.sect_id=cat_sect_tree.sect_id
					LEFT JOIN cat_common_props ccp_parent ON cat_sect_tree.sect_id=ccp_parent.item_id
					
					
				WHERE cat_common_props.enable AND 
					IF (cat_common_props.access="groups",0,IF (cat_common_props.access="auth",0,1)) AND cat_data_to_sect_rel.lkey>= AND cat_data_to_sect_rel.rkey<=
				GROUP BY cat_data_to_sect_rel.item_id
				ORDER BY cat_data_to_sect_rel.ord asc
				LIMIT 0,12
			");

SELECT cat_data_to_sect_rel.item_id, cat_common_props.title, ccp_parent.title parent_title, cat_common_props.url, cat_common_props.target, cat_common_props.modify_ts, cat_common_props.access, cat_common_props.data_cache, cat_common_props.data_cache_ts, count(comments.id) rating_count, avg(comments.rating) rating_avg FROM cat_data_to_sect_rel LEFT JOIN cat_common_props ON cat_data_to_sect_rel.item_id=cat_common_props.item_id LEFT JOIN cat_access ON cat_common_props.item_id=cat_access.item_id LEFT JOIN comments ON cat_data_to_sect_rel.item_id=comments.object_id AND comments.moderated=1 AND comments.rating>0 LEFT JOIN cat_sect_tree ON cat_data_to_sect_rel.sect_id=cat_sect_tree.sect_id LEFT JOIN cat_common_props ccp_parent ON cat_sect_tree.sect_id=ccp_parent.item_id WHERE cat_common_props.enable AND IF (cat_common_props.access="groups",0,IF (cat_common_props.access="auth",0,1)) AND cat_data_to_sect_rel.lkey>= AND cat_data_to_sect_rel.rkey<= GROUP BY cat_data_to_sect_rel.item_id ORDER BY cat_data_to_sect_rel.ord asc LIMIT 0,12
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cat_data_to_sect_rel.rkey<= GROUP BY cat_data_to_sect_rel.item_id OR' at line 22