krasnofff

$results = $this->model_catalog_review->getReviewsByProductId($this->request->get['product_id'], ($page - 1) * 50, 50);

        foreach ($results as $result) {
            $data['reviews'][] = array(
                'author'     => $result['author'],
                'text'       => nl2br($result['text']),
                'rating'     => (int)$result['rating'],
                'date_added' => date($this->language->get('date_format_short'), strtotime($result['date_added']))

$pagination = new Pagination();
        $pagination->total = $review_total;
        $pagination->page = $page;
        $pagination->limit = 50;
        $pagination->url = $this->url->link('product/product/review', 'product_id=' . $this->request->get['product_id'] . '&page={page}');

        $data['pagination'] = $pagination->render();

        $data['results'] = sprintf($this->language->get('text_pagination'), ($review_total) ? (($page - 1) * 5) + 1 : 0, ((($page - 1) * 5) > ($review_total - 5)) ? $review_total : ((($page - 1) * 5) + 5), $review_total, ceil($review_total / 5));

        if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/product/review.tpl')) {
            $this->response->setOutput($this->load->view($this->config->get('config_template') . '/template/product/review.tpl', $data));
        } else {
            $this->response->setOutput($this->load->view('default/template/product/review.tpl', $data));
        }
    }

2018-03-14 4:00:56 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 4:00:56 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 4:00:56 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 4:04:46 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 4:04:46 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 4:04:46 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 8:03:46 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 8:03:46 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 8:03:46 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 9:34:24 - PHP Notice:  Undefined index: thumb2 in /home/a/amigo/public_html/system/storage/modification/catalog/view/theme/royal/template/product/product.tpl on line 72
2018-03-14 9:34:24 - PHP Notice:  Undefined index: thumb2 in /home/a/amigo/public_html/system/storage/modification/catalog/view/theme/royal/template/product/product.tpl on line 72
2018-03-14 9:34:24 - PHP Notice:  Undefined index: thumb2 in /home/a/amigo/public_html/system/storage/modification/catalog/view/theme/royal/template/product/product.tpl on line 72
2018-03-14 12:25: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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 12:25:28 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 12:25:28 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 15:04:57 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 15:04:57 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 15:04:57 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 17:26:57 - PHP Notice:  Undefined index: thumb2 in /home/a/amigo/public_html/system/storage/modification/catalog/view/theme/royal/template/product/product.tpl on line 72
2018-03-14 17:26:57 - PHP Notice:  Undefined index: thumb2 in /home/a/amigo/public_html/system/storage/modification/catalog/view/theme/royal/template/product/product.tpl on line 72
2018-03-14 17:26:57 - PHP Notice:  Undefined index: thumb2 in /home/a/amigo/public_html/system/storage/modification/catalog/view/theme/royal/template/product/product.tpl on line 72
2018-03-14 18:29:55 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 18:29:55 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 18:29:55 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 18:33:26 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 18:33:26 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 18:33:26 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 18:41:03 - 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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id)
            INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' AND pr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price UNION ALL SELECT  RAND() as rnd,cpr.product_id,cpr.price,pr.price as cprice, 1 as quan FROM oc_product pr LEFT JOIN oc_product cpr ON (pr.product_id <> cpr.product_id and cpr.status = 1)
                INNER JOIN oc_product_to_category cat_source ON (pr.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat ON (cpr.product_id = cat.product_id AND cat.category_id = cat_source.category_id) AND cpr.quantity > 0 GROUP BY cpr.product_id,pr.price,cpr.price order by quan desc) t1 INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) LEFT JOIN (select '' as name, '' as text, 0 as attribute_id) as t2 on (0=0) WHERE 0=0 GROUP BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),product_id,name,text,attribute_id ORDER BY IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price), t1.product_id LIMIT 7 in /home/a/amigo/public_html/system/library/db/mysqli.php on line 41
2018-03-14 18:41:03 - PHP Notice:  Trying to get property of non-object in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130
2018-03-14 18:41:03 - PHP Warning:  Invalid argument supplied for foreach() in /home/a/amigo/public_html/catalog/model/module/autofeatured.php on line 130