Product added to Shopping Cart!!


The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available (-2147220975)
***********************

Sending email

strSendFrom

support@rcring.eu
strSendTo

error@rcring.eu
strSendCC


strSendbCC


strSubject

Slow QUERY! 2,235352
strBody

The following query took way too long to be executed!

SELECT products.*, brands.*, categoriessub.*, getCurrentStock(products.prodid) trueStock, IFNULL(getDiscount(products.prodid), '|0|') discountDetails FROM products INNER JOIN brands ON brands.BrandID = products.ProdBrand INNER JOIN categoriessub ON products.prodcategory = categoriessub.categorysubid INNER JOIN categories ON categories.categoryid = categoriessub.categoryid WHERE prodActive = 1 AND prodSponsored <> 2 AND categoryVisible=1 AND categoryActive=1 AND (CONCAT('|', products.prodspecialcategory, '|') LIKE '%|322|%' OR CONCAT('|', products.prodcategory, '|') LIKE '%|322|%') ORDER BY trueStock DESC, ProdInsertDate DESC, ProdAvailability, ProdCode ASC

needed 2,235352 seconds

Initiated by [3.235.173.24] on 22/03/2023 04:18:29
last Page [page=viewCategory&cat=1&specific=322]

***********************