filterpro filter Pro [Поддержка]

[freelancer]

@Sunjahman такое уже реализовано через seo функционал

[Zapuzin]

freelancer, посмотрите ЛС, пожалуйста.

[Zapuzin]

Опишу свою проблему здесь, может кроме разработчика кто поможет.

 

ocStore-1.5.5.1.2. Установлен модуль "FilterPro v2.4.4 (seo)". 

Модуль работает отлично, но заметил одну проблему в фильтрации атрибутов.

Например, страница категории стальных радиаторов: https://teplopl.com.ua/otoplenie/radiatory/stalnye-radiatory

Фильтр зависает, если одновременно выбрать три атрибута. Например: 1. Панельный (22) (102)   2. Нижний / боковой (95)  3. Высота, мм

 

 

Настройки фильтра:

 

 

Может кто знает, как справиться с данной проблемой?

[Zapuzin]

Лог ошибок:

 

Спойлер

2020-02-12 12:58:23 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 12:59:48 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:00:02 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:00:37 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:02:07 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (33)' OR p2a0.text like 'Панельний (33):%' OR p2a0.text like '%:Панельний (33)' OR p2a0.text like '%:Панельний (33):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:03:17 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Бокове' OR p2a1.text like 'Бокове:%' OR p2a1.text like '%:Бокове' OR p2a1.text like '%:Бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '400' OR p2a2.text like '400:%' OR p2a2.text like '%:400' OR p2a2.text like '%:400:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:04:36 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Бокове' OR p2a1.text like 'Бокове:%' OR p2a1.text like '%:Бокове' OR p2a1.text like '%:Бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 300))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:06:42 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 400))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:25:04 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 500))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:25:18 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 500))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:50:38 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 300))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 17:40:01 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 900))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 17:40:28 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 500))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 17:43:07 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT CONCAT(`name`, ' (', count(*), ')') as 'name', `category_id` FROM (SELECT DISTINCT p.product_id, cd.name, cd.category_id, c.sort_order, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN `oc_category` c ON(p2c.category_id=c.category_id)  LEFT JOIN oc_category_description cd ON(cd.category_id=c.category_id)  LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 81 AND (p2a0.text = 'Водяной' OR p2a0.text like 'Водяной:%' OR p2a0.text like '%:Водяной' OR p2a0.text like '%:Водяной:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 121 AND (p2a1.text = '5' OR p2a1.text like '5:%' OR p2a1.text like '%:5' OR p2a1.text like '%:5:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 70 AND 810))  AND p.price >=1066 AND c.status=1 AND c.parent_id = '201' AND cd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=1066 AND realprice <=13787 GROUP BY category_id ORDER BY sort_order, name in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:14:58 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=2197 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:15:30 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (11)' OR p2a0.text like 'Панельный (11):%' OR p2a0.text like '%:Панельный (11)' OR p2a0.text like '%:Панельный (11):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=4442 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:16:29 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (33)' OR p2a0.text like 'Панельний (33):%' OR p2a0.text like '%:Панельний (33)' OR p2a0.text like '%:Панельний (33):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '500' OR p2a2.text like '500:%' OR p2a2.text like '%:500' OR p2a2.text like '%:500:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:18:19 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (11)' OR p2a0.text like 'Панельный (11):%' OR p2a0.text like '%:Панельный (11)' OR p2a0.text like '%:Панельный (11):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=2237 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:24:00 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '900' OR p2a2.text like '900:%' OR p2a2.text like '%:900' OR p2a2.text like '%:900:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:35:27 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (11)' OR p2a0.text like 'Панельный (11):%' OR p2a0.text like '%:Панельный (11)' OR p2a0.text like '%:Панельный (11):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:36:12 - PHP Notice:  Error: 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<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
 

 

Лог ошибок.txt

Змінено 12 лютого 2020 користувачем Zapuzin

[Zapuzin]

Проблема уже не актуальна.

Сайт переходит с ocStore 1.5.5.1.2 на ocStore 2.3.0.2.3.

Куплен другой фильтр с нормальной тех. поддержкой.

Змінено 24 лютого 2020 користувачем Zapuzin

[Quantumua]

Купил модуль.

Установил на OpenCart 1.5.5.1

При попытке зайти в настройки ошибка: 

"Fatal error: Call to undefined method ModelModuleFilterpro::getLicense() "

Помогите, пожалуйста, решить проблему.

[pustota666]

Добрый день, очень нужна помощь. Покупала у вас  фильтр  для сайта pech-center.ru.  

все нормально но не хватает сортировки по значениям,

 

можно ли атрибуты отбирать из базы по нарастающей, от меньшего к большему значению?

спасибо

[pustota666]

В 24.02.2020 в 16:42, Zapuzin сказал:

Проблема уже не актуальна.

Сайт переходит с ocStore 1.5.5.1.2 на ocStore 2.3.0.2.3.

Куплен другой фильтр с нормальной тех. поддержкой.

Скажите пожалуйста, что выбрали  в итоге. Не могу достучаться до этого "мастера" ...

[Zapuzin]

42 минуты назад, pustota666 сказал:

Скажите пожалуйста, что выбрали  в итоге. Не могу достучаться до этого "мастера" ...

OCFilter - Модуль фильтра товаров

Тех. поддержка отличная. Иногда нужно немного подождать, так как обращений к автору может быть много.

Уже трудится на обновлённом сайте teplopl.com.ua. Проблема, которая была с "FilterPro v2.4.4 (seo)", и не решалась, в этом фильтре отсутствует.

Заменой доволен на все 100%

 

Змінено 29 квітня 2020 користувачем Zapuzin

[pustota666]

Добрый день, установили ваш модуль, он закодирован  - не можем  отсортировать значения от большего к меньшему, только вразброс.

[Nubilus]

Купил модуль, установил, но он не работает. Писал разработчику в лс ещё 21 мая, но сообщение до сих пор не прочитано... (( Хотелось бы получить какую-то реакцию. 

[pav12398]

Фильтр сдох!!!!

 

Когда нажимаю "Настройки модуля" он долга грузит грузит  и не открывается.

 

а когда удаляю модуль и тыкаю установить от тоже долго грузит и после погрузки выскакивает кнопка активировать вручную нажимаю кнопку и он перекидывает меня на сайт http://orcart.ru/license/ который сдох 

я смотрел копию страницу в яндексе этот сайт еще работал 30 June 2020 
 

Автор тупа всех к и н у л у кого была лицензия.

 

Змінено 15 липня 2020 користувачем pav12398

[freelancer]

@pav12398 скачайте фильтр на форуме

[pav12398]

16 часов назад, freelancer сказал:

@pav12398 скачайте фильтр на форуме

 

Это что получается опять платить деньги чтобы скачать? 

[freelancer]

@pav12398 зачем еще раз... вы же покупали фильтр. просто скачайте новую версию

[pav12398]

В 17.07.2020 в 16:05, freelancer сказал:

@pav12398 зачем еще раз... вы же покупали фильтр. просто скачайте новую версию

 

покупал не я, у этого фильтра была лицензия на домен zscom.ru а теперь она не работает . версии opencart 1.5 FilterPro v2.5.17.6_beta (speed)

Змінено 21 липня 2020 користувачем pav12398

[freelancer]

@pav12398 напишите в личку, я вам скину файл

[Nubilus]

В 13.06.2020 в 15:40, Nubilus сказал:

Купил модуль, установил, но он не работает. Писал разработчику в лс ещё 21 мая, но сообщение до сих пор не прочитано... (( Хотелось бы получить какую-то реакцию. 

Разработчик, ответьте на моё сообщение.

[pav12398]

В 21.07.2020 в 18:35, freelancer сказал:

@pav12398 напишите в личку, я вам скину файл

Вы в лс ответите или нет?

[pav12398]

В 21.07.2020 в 18:35, freelancer сказал:

@pav12398 напишите в личку, я вам скину файл

 

Вы ответите в лс или нет?

[dimli]

Автор прочитайте личку! по заказу и активации модуля!

 

[Ohrikon]

Фильтр FilterPro v2.3Seo  Не сохраняет выбор параметров при переходе на страницы пагинации 2,3,4 страницу, Help поддержка аууу...  (Чем лечить?)

[sergdzhura]

Добрый день, при переходе в модуль появляется сообщение

Неверная лицензия! Ваш домен не активирован. Обратитесь к разработчику

Домен https://mob.com.ua/

Куда обращаться?

[freelancer]

я убрал лицензии и куб из фильтра и других своих модулей, домен orcart.ru мне не принадлежит

на форуме сейчас все мои дополнения работают без лицензий

[dinox]

32 минуты назад, freelancer сказал:

я убрал лицензии и куб из фильтра и других своих модулей, домен orcart.ru мне не принадлежит

на форуме сейчас все мои дополнения работают без лицензий

@freelancer обратились бы сразу в поддержку с описанием проблемы мы бы оперативно разослали всем клиентам соообщение о необхомости срочного обновления с ссылками на скачивание версий. А так получается часть клиентов может даже не догадыватся о том что у Вас утрачен доступ к домену лицензий. Это плохая ситуация это можно решать более оперативно при своевременном обращении к нам в техническую поддержку. Мы готовим рассылку для оповещения покупателей, о необходимости оперативного обновления в связи с проблемами с лицензированием. Это еще раз показывает что лицензирование с запросом на сервер не такое уж безопасное и может остановить даже продажи клиентов в предверьи таких дней как черная пятница....