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 ('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!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!
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.