ЭЛЬБОР (г.Боровичи)

user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM source_node node LEFT JOIN source_content_type_product node_data_field_keys ON node.vid = node_data_field_keys.vid LEFT JOIN source_uc_products uc_products ON node.vid = uc_products.vid LEFT JOIN source_content_type_product node_data_field_poryadok ON node.vid = node_data_field_poryadok.vid WHERE (node.type IN ('product')) AND (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.vid IN ( SELECT tn.vid FROM source_term_node tn LEFT JOIN source_term_hierarchy th ON th.tid = tn.tid LEFT JOIN source_term_hierarchy th1 ON th.parent = th1.tid LEFT JOIN source_term_hierarchy th2 ON th1.parent = th2.tid LEFT JOIN source_term_hierarchy th3 ON th2.parent = th3.tid LEFT JOIN source_term_hierarchy th4 ON th3.parent = th4.tid LEFT JOIN source_term_hierarchy th5 ON th4.parent = th5.tid LEFT JOIN source_term_hierarchy th6 ON th5.parent = th6.tid WHERE tn.tid = 23 OR th1.tid = 23 OR th2.tid = 23 OR th3.tid = 23 OR th4.tid = 23 OR th5.tid = 23 OR th6.tid = 23 )) ) count_alias in /home/users/1/1001kraska/domains/zamkizamki.ru/sites/all/modules/views/includes/view.inc on line 805.