Warning: Empty row packet body in /var/www/html/includes/classes/classes.php on line 82

Warning: mysql_query(): Unable to save result set in /var/www/html/includes/classes/classes.php on line 82
ERROR: SELECT * FROM (SELECT eshop_product.`product_id` AS `product_id`, eshop_product.`category_id` AS `category_id`, eshop_product.`product_item_number` AS `product_item_number`, eshop_product.`product_name` AS `product_name`, eshop_product.`product_netto_price` AS `product_netto_price`, eshop_product.`product_netto_discount_price` AS `product_netto_discount_price`, eshop_product.`product_netto_wholeprice` AS `product_netto_wholeprice`, eshop_product.`product_arukereso_price` AS `product_arukereso_price`, eshop_product.`product_emag_price` AS `product_emag_price`, eshop_product.`product_image` AS `product_image`, eshop_product.`product_short_description` AS `product_short_description`, eshop_product.`product_important_note` AS `product_important_note`, eshop_product.`product_brand_id` AS `product_brand_id`, eshop_product.`product_supplier_id` AS `product_supplier_id`, eshop_product.`product_vtsz_number` AS `product_vtsz_number`, eshop_product.`product_barcode` AS `product_barcode`, eshop_product.`product_tax_id` AS `product_tax_id`, eshop_product.`product_webdiscount` AS `product_webdiscount`, eshop_product.`product_discount` AS `product_discount`, eshop_product.`product_discount_start` AS `product_discount_start`, eshop_product.`product_discount_end` AS `product_discount_end`, eshop_product.`product_piece` AS `product_piece`, eshop_product.`product_unit` AS `product_unit`, eshop_product.`product_guarantee` AS `product_guarantee`, eshop_product.`product_power` AS `product_power`, eshop_product.`product_warehouse` AS `product_warehouse`, eshop_product.`product_warehouse_display` AS `product_warehouse_display`, eshop_product.`product_min_order` AS `product_min_order`, eshop_product.`product_min_order_display` AS `product_min_order_display`, eshop_product.`product_max_order` AS `product_max_order`, eshop_product.`product_max_order_display` AS `product_max_order_display`, eshop_product.`product_new_product` AS `product_new_product`, eshop_product.`product_special` AS `product_special`, eshop_product.`product_show` AS `product_show`, eshop_product.`product_rating` AS `product_rating`, eshop_product.`product_voting` AS `product_voting`, eshop_product.`product_social_network` AS `product_social_network`, eshop_product.`product_shipping` AS `product_shipping`, eshop_product.`product_shipping_limit` AS `product_shipping_limit`, eshop_product.`product_cart` AS `product_cart`, eshop_product.`product_is_shipping` AS `product_is_shipping`, eshop_product.`product_advert` AS `product_advert`, eshop_product.`product_short_description_is` AS `product_short_description_is`, eshop_product.`product_only_warehouse` AS `product_only_warehouse`, eshop_product.`product_runway` AS `product_runway`, eshop_product.`product_postapont` AS `product_postapont`, eshop_product.`product_inactive` AS `product_inactive`, eshop_product.`product_order` AS `product_order`, eshop_product.`product_create_user` AS `product_create_user`, eshop_product.`product_create_date` AS `product_create_date`, eshop_product.`product_modify_user` AS `product_modify_user`, eshop_product.`product_modify_date` AS `product_modify_date`, eshop_product.`product_import_flag` AS `product_import_flag`, eshop_product.`product_virtual_is` AS `product_virtual_is`, eshop_product.`product_virtual_id` AS `product_virtual_id`, eshop_product.`product_import_order` AS `product_import_order`, eshop_product.`product_open_userid` AS `product_open_userid`, eshop_product.`product_iskolataska` AS `product_iskolataska`, `cms_nicelink`.`nicelink_id` AS `prod_nicelink_nicelink_id`, `cms_nicelink`.`nicelink_path` AS `prod_nicelink_nicelink_path`, `cms_nicelink`.`nicelink_realpath` AS `prod_nicelink_nicelink_realpath`, `cms_nicelink`.`nicelink_title` AS `prod_nicelink_nicelink_title`, `cms_nicelink`.`nicelink_keyword` AS `prod_nicelink_nicelink_keyword`, `cms_nicelink`.`nicelink_description` AS `prod_nicelink_nicelink_description`, `cms_nicelink`.`nicelink_module` AS `prod_nicelink_nicelink_module`, `cms_nicelink`.`nicelink_module_type` AS `prod_nicelink_nicelink_module_type`, `cms_nicelink`.`nicelink_module_id` AS `prod_nicelink_nicelink_module_id`, `cms_nicelink`.`nicelink_layout_id` AS `prod_nicelink_nicelink_layout_id`, `cms_nicelink`.`nicelink_header_block` AS `prod_nicelink_nicelink_header_block`, `cms_nicelink`.`nicelink_footer_block` AS `prod_nicelink_nicelink_footer_block`, `cms_nicelink`.`nicelink_default` AS `prod_nicelink_nicelink_default`, `cms_nicelink`.`nicelink_locked` AS `prod_nicelink_nicelink_locked`, `cms_nicelink`.`nicelink_visit` AS `prod_nicelink_nicelink_visit`, `cms_nicelink`.`nicelink_parent_id` AS `prod_nicelink_nicelink_parent_id`, `eshop_tax`.`tax_id` AS `prod_tax_tax_id`, `eshop_tax`.`tax_rate` AS `prod_tax_tax_rate`, `eshop_brand`.`brand_id` AS `prod_brand_brand_id`, `eshop_brand`.`brand_name` AS `prod_brand_brand_name`, `eshop_brand`.`brand_image` AS `prod_brand_brand_image`, `eshop_supplier`.`supplier_id` AS `prod_supplier_supplier_id`, `eshop_supplier`.`supplier_name` AS `prod_supplier_supplier_name` FROM eshop_product LEFT JOIN `cms_nicelink` ON `eshop_product`.`product_id`=`cms_nicelink`.`nicelink_module_id` LEFT JOIN `eshop_tax` ON `eshop_product`.`product_tax_id`=`eshop_tax`.`tax_id` LEFT JOIN `eshop_brand` ON `eshop_product`.`product_brand_id`=`eshop_brand`.`brand_id` LEFT JOIN `eshop_supplier` ON `eshop_product`.`product_supplier_id`=`eshop_supplier`.`supplier_id` WHERE ( eshop_product.product_show='1' AND `product_virtual_is`='0' AND `product_inactive`='0' AND (eshop_product.product_tax_id = eshop_tax.tax_id OR eshop_product.product_tax_id = 0) AND (eshop_product.product_brand_id = eshop_brand.brand_id OR eshop_product.product_brand_id = 0) AND (eshop_product.product_supplier_id = eshop_supplier.supplier_id OR eshop_product.product_supplier_id = 0) AND eshop_product.product_id = cms_nicelink.nicelink_module_id AND cms_nicelink.nicelink_module_type = 'product' AND cms_nicelink.nicelink_module = 'eShop' ) AND ( (BINARY LOWER(eshop_brand.brand_name) LIKE LOWER('%Trefl%')) ) ) AS `temp_table` ORDER BY product_id DESC ==>