PDO::errorInfo():

Disk full (/tmp/#sql_378_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

			SELECT
				p.id AS id,
				p.wallet_friendly,
				pa_name.value AS name,
				pa_slug.value AS slug,
				pa_list.value AS popup,
				COUNT(DISTINCT(r.id)) as `count`,
				AVG(r.star) as `average`,
				pr.nett_price,
				pr.nett_price_de,
				pr.nett_price_ro,
				pr.off,
				pr.vat
			FROM
				products AS p
			LEFT JOIN
				product_brands AS b
				ON
					p.id = b.product_id
			LEFT JOIN
				product_ratings AS r
				ON
					p.id = r.product_id
			LEFT JOIN
				products_consumer_roles_price AS pr
				ON
					p.id = pr.product_id
				AND
					pr.consumer_role_id = :role
			LEFT JOIN
				products_attributes AS pa_name
				ON
					p.id = pa_name.product_id
				AND
					pa_name.attribute = 'name'
				AND
					pa_name.`language` = :language
			LEFT JOIN
				products_attributes AS pa_quantity
				ON
					p.id = pa_quantity.product_id
				AND
					pa_quantity.attribute = 'quantity'
				AND
					pa_quantity.`language` = :language
			LEFT JOIN
				products_attributes AS pa_list
				ON
					p.id = pa_list.product_id
				AND
					pa_list.attribute = 'popup'
				AND
					pa_list.`language` = :language
			LEFT JOIN
				products_attributes AS pa_slug
				ON
					p.id = pa_slug.product_id
				AND
					pa_slug.attribute = 'slug'
				AND
					pa_slug.`language` = :language
			
			WHERE
				 p.active = :active  AND  p.frontend_hu != :frontend  AND  p.category_id = :category_id 
			GROUP BY
				p.id  ORDER BY pa_name.value DESC LIMIT 0, 9