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

Warning: mysqli_errno() expects exactly 1 parameter, 0 given in /var/www/clients/client3/web13/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/web13/web/includes/class_mysql.php on line 19
Home - Premium Nutrition
Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /var/www/clients/client3/web13/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 ('142', '143') 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%'
AND p.id_product NOT IN ('1547')
AND p.id_product NOT IN ('1551')

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/web13/web/includes/class_mysql.php on line 34

Join to Premium Team

+

View More

Join to Premium Team

+

View More

Premium Products

COOPERATION

START
WORKING
TOGETHER

With attention to the highest quality of our products, we want to invite you to join us on a journey through the world of supplements.

+

View More

Catalogs

Check Products

Catalog PL / EU

Check Products

Catalog PL / EU

POLAND QUALITY

MASTERING
THE ART OF
SUPPLEMENTS

The PREMIUM NUTRITION line was created with professional sports in mind. Our products are dedicated to both professionals and those who are just beginning their adventure with sports.

+

View More

Distributors