Notice: Error: Out of resources when opening file '/tmp/#sql_7b97_0.MAD' (Errcode: 24 "Too many open files") Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Notice: Error: Out of resources when opening file '/tmp/#sql_7b97_0.MAD' (Errcode: 24 "Too many open files") Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Notice: Error: Out of resources when opening file '/tmp/#sql_7b97_0.MAD' (Errcode: 24 "Too many open files") Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Notice: Error: Out of resources when opening file '/tmp/#sql_7b97_0.MAD' (Errcode: 24 "Too many open files") Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Notice: Error: Out of resources when opening file '/tmp/#sql_7b97_0.MAD' (Errcode: 24 "Too many open files") Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`m`.*
FROM
`oc_manufacturer` AS `m`
INNER JOIN
`oc_manufacturer_to_store` AS `m2s`
ON
`m`.`manufacturer_id` = `m2s`.`manufacturer_id` AND `m2s`.`store_id` = '0'
INNER JOIN `oc_product` AS `p` ON `p`.`manufacturer_id` = `m`.`manufacturer_id`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY `m`.`manufacturer_id`
ORDER BY
`m`.`name` ASC
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2198Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2198Notice: Error: Out of resources when opening file '/tmp/#sql_7b97_0.MAD' (Errcode: 24 "Too many open files") Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2522Notice: Error: Got error 24 "Too many open files" from storage engine MyISAM Error No: 1030
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` = '132'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/vhosts/zevra.gr/httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zevra.gr/httpdocs/catalog/model/module/mega_filter.php on line 2295basis
