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]