ERROR!! Application is serviced!
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!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
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
