File: /home/hyperc/public_html/plugins/product/classes/Product.php
Line: 1273
Exception: Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")
Query:
/* Product::doSelectList */
SELECT
a.id,
a.sku,
a.weight,
a.parent,
a.parent_sku,
a.allow_backorders,
a.backorder_delivery,
a.stock_management,
a.stock,
a.brand,
a.stock_status,
b.code,
b.rating,
b.rating_count,
b.price,
b.list_price,
b.special_price,
b.price_with_vat,
b.price_vat,
b.name,
b.description,
b.url,
b.display_if_outofstock,
b.display_price_label,
b.display_list_price_label,
b.display_special_price_label,
b.display_discount_value,
b.image_alt_text,
b.public_stock_status,
d.file,
f.url AS category_url,
GROUP_CONCAT(f.data_id) AS category_id,
g.name AS brand_name,
b.group_name,
GROUP_CONCAT(e.id_product_category) AS category,
c.reduced_min_price,
c.reduced_max_price,
c.min_price,
c.max_price
FROM
(`product_scope` AS b,
product AS a,
`rule_product` AS c,
`product_display` AS pd)
INNER JOIN
(`product_category_link` AS e,
`product_category_scope` AS f)
ON
a.id = e.id_product
AND
e.id_product_category = f.`data_id`
AND
f.`website_id` = 2
AND
f.`view_id` = 4
AND
f.active = 1
LEFT JOIN
product_image AS d
ON
a.`id` = d.id_product
AND
d.main = 1
INNER JOIN `product_attribute_option_link` AS t0 ON a.id = t0.id_product AND t0.id_attribute = "11" AND t0.id_option = "254" INNER JOIN `product_attribute_option_link` AS t1 ON a.id = t1.id_product AND t1.id_attribute = "3" AND t1.id_option = "289" INNER JOIN `product_attribute_option_link` AS t2 ON a.id = t2.id_product AND t2.id_attribute = "3" AND t2.id_option = "288" INNER JOIN `product_attribute_option_link` AS t3 ON a.id = t3.id_product AND t3.id_attribute = "3" AND t3.id_option = "266" INNER JOIN `product_attribute_option_link` AS t4 ON a.id = t4.id_product AND t4.id_attribute = "3" AND t4.id_option = "261" INNER JOIN `product_attribute_option_link` AS t5 ON a.id = t5.id_product AND t5.id_attribute = "10" AND t5.id_option = "290" INNER JOIN `product_attribute_option_link` AS t6 ON a.id = t6.id_product AND t6.id_attribute = "11" AND t6.id_option = "253"
LEFT JOIN
`product_brand` AS g
ON
a.brand = g.id
WHERE
b.`data_id` = a.id
AND
b.`website_id` = "2"
AND
b.`view_id` = 4
AND
a.temporary = 0
AND
b.enabled = 1
AND
b.display_start <= "2025-07-01"
AND
(b.display_end = "0000-00-00" OR b.display_end >= "2025-07-01")
AND
a.`id` = c.product_id
AND
c.website_id = "2"
AND
pd.`website_id` = b.`website_id`
AND
pd.`view_id` = b.`view_id`
AND
pd.product_id = a.id
AND
pd.type = "buys"
AND e.id_product_category = "53" AND c.price BETWEEN "10" AND "20"
GROUP BY
pd.id
LIMIT 0, 16