Warning: mysqli_connect(): (HY000/1045): Access denied for user 'fa_admin'@'10.0.10.254' (using password: YES) in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 18

Warning: mysqli_errno() expects exactly 1 parameter, 0 given in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 18
ERROR!! Application is serviced! 



Warning: mysqli_set_charset() expects parameter 1 to be mysqli, bool given in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 19

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 28
ERROR!! Read problem: 
SELECT

p.id_product AS 'product_id',
p.id_category_default AS 'category_id',

pl.name AS 'name',
SUM(sa.quantity) AS 'quantity',
CASE p.active WHEN 1 THEN 'Yes' ELSE 'No' END AS 'active',

CONCAT('https://fasklep.pl/', CASE WHEN pl.id_lang = 1 THEN 'en' ELSE 'pl' END, '/', pl.link_rewrite, '-', p.id_product, '.html') AS 'url_en',

(
	SELECT CONCAT('https://fasklep.pl/', CASE WHEN lang_pl.id_lang = 1 THEN 'en' ELSE 'pl' END, '/', lang_pl.link_rewrite, '-', p.id_product, '.html')
	FROM fa_fasklep_new.psshop_product_lang lang_pl 
	WHERE 
	lang_pl.id_lang = 1 AND 
	lang_pl.id_shop = p.id_shop_default AND 
	lang_pl.id_product = p.id_product
) AS 'url_pl',

CONCAT('https://fasklep.pl/', i.id_image, '-large_default/', pl.link_rewrite, '.jpg') AS 'image',

CASE WHEN pl.description = '' THEN NULL ELSE pl.description END AS 'description_en',

(
	SELECT CASE WHEN lang_pl.description = '' THEN NULL ELSE lang_pl.description END 
	FROM fa_fasklep_new.psshop_product_lang lang_pl 
	WHERE 
	lang_pl.id_lang = 1 AND 
	lang_pl.id_shop = p.id_shop_default AND 
	lang_pl.id_product = p.id_product
) AS 'description_pl'

FROM fa_fasklep_new.psshop_product p
JOIN fa_fasklep_new.psshop_category c ON (c.id_parent IN (98, 99, 100, 101, 102, 103, 104, 123) /*AND c.active = 1*/)
JOIN fa_fasklep_new.psshop_category_product cp ON (cp.id_product = p.id_product AND cp.id_category = c.id_category)
JOIN fa_fasklep_new.psshop_category_lang cl ON (cl.id_category = cp.id_category AND cl.id_lang = 2 AND cl.id_shop = p.id_shop_default)
LEFT JOIN fa_fasklep_new.psshop_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN fa_fasklep_new.psshop_image i ON (i.id_product = p.id_product AND i.cover = 1)
LEFT JOIN fa_fasklep_new.psshop_stock_available sa ON (sa.id_product = p.id_product)

WHERE 

pl.id_lang = 2 AND
pl.id_shop = p.id_shop_default AND 
p.id_category_default IN ('111') AND 
NOT EXISTS 
(
	SELECT cp_check.id_product
	FROM fa_fasklep_new.psshop_category_product cp_check
	WHERE cp_check.id_product = p.id_product AND cp_check.id_category = 122
)
AND pl.name NOT LIKE '%shaker%'

GROUP BY

p.id_product,
p.id_category_default,

pl.name,
CASE p.active WHEN 1 THEN 'Yes' ELSE 'No' END,
CONCAT('https://fasklep.pl/', CASE WHEN pl.id_lang = 1 THEN 'en' ELSE 'pl' END, '/', pl.link_rewrite, '-', p.id_product, '.html'),
CONCAT('https://fasklep.pl/', i.id_image, '-large_default/', pl.link_rewrite, '.jpg'),
CASE WHEN pl.description = '' THEN NULL ELSE pl.description END

ORDER BY 

pl.name ASC,
p.id_product ASC,
p.active DESC
 Refresh browser!



Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 34

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 28
ERROR!! Read problem: 
	SELECT

	GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ', ') as combination

	FROM fa_fasklep_new.psshop_product p
	LEFT JOIN fa_fasklep_new.psshop_product_attribute pa ON (p.id_product = pa.id_product)
	LEFT JOIN fa_fasklep_new.psshop_stock_available pq ON (p.id_product = pq.id_product AND pa.id_product_attribute = pq.id_product_attribute)
	LEFT JOIN fa_fasklep_new.psshop_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = p.id_shop_default)
	LEFT JOIN fa_fasklep_new.psshop_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute)
	LEFT JOIN fa_fasklep_new.psshop_attribute_lang pal ON (pac.id_attribute = pal.id_attribute)
	LEFT JOIN fa_fasklep_new.psshop_product_attribute_image pai ON (pa.id_product_attribute = pai.id_product_attribute)

	WHERE 

	pal.id_lang = 2 AND 
	pa.reference <> '' AND 
	pa.ean13 <> '' AND 
	p.id_product like '0'

	GROUP BY 

	pac.id_product_attribute

	 Refresh browser!



Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /var/www/clients/client3/web9/web/includes/class_mysql.php on line 34
FA ICE

NEWS


About ICE


ICE is a brand of dietary supplements composed of perfectly selected quantities of active substances that work synergistically, which will prove effective for both beginner and advanced exercise enthusiasts. Products from the ICE line guarantee the feeling of incredible freshness, thanks to the presence of the innovative ingredient EVERCOOL.

Products


Distributors

Contact