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 ('104', '144') 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 ('1545')
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!
GEAR is a brand of dietary supplements dedicated to fans of strength sports, who are not afraid of challenges and hard workouts. They are tough guys who push their limits every day - they are tenacious and determined to get bigger and stronger. GEAR are supplements for professionals, with maximum ingredient compositions and comprehensive support for the longest and toughest workouts. GEAR products help you reach your goals and discover your potential. Sweat, dedication, determination.
