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
p.id_product AS 'product_id',
p.ean13 AS 'ean',
p.reference AS 'code',
/*
(
SELECT cl.id_category
FROM fa_fasklep_new.psshop_category_product cp
JOIN fa_fasklep_new.psshop_category_lang cl ON (cl.id_category = cp.id_category AND cl.id_lang = 2 AND cl.id_shop = 1)
WHERE
cp.id_product = p.id_product AND
cp.id_category IN
(
SELECT c.id_category
FROM fa_fasklep_new.psshop_category c
WHERE c.id_parent = 70 AND c.active = 1
)
LIMIT 1
) AS 'category_id',
*/
p.id_category_default AS 'category_id',
(
SELECT cl.name
FROM fa_fasklep_new.psshop_category_product cp
JOIN fa_fasklep_new.psshop_category_lang cl ON (cl.id_category = cp.id_category AND cl.id_lang = 2 AND cl.id_shop = 1)
WHERE
cp.id_product = p.id_product AND
cp.id_category IN
(
SELECT c.id_category
FROM fa_fasklep_new.psshop_category c
WHERE c.id_parent = 70 AND c.active = 1
)
LIMIT 1
) AS 'category_name',
pl.name AS 'name',
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',
CASE WHEN pl.description_short = '' THEN NULL ELSE pl.description_short END AS 'description_short_en',
(
SELECT CASE WHEN lang_pl.description_short = '' THEN NULL ELSE lang_pl.description_short 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_short_pl',
(
SELECT CASE WHEN PEFL.ingredients = '' THEN NULL ELSE PEFL.ingredients END
FROM fa_fasklep_new.psshop_product_extra_fields PEF
JOIN fa_fasklep_new.psshop_product_extra_fields_lang PEFL ON (PEFL.id_extrafield = PEF.id_extrafield AND PEFL.id_lang = 1)
WHERE PEF.id_product = p.id_product
LIMIT 1
) AS 'nutrition_facts_pl',
(
SELECT CASE WHEN PEFL.ingredients = '' THEN NULL ELSE PEFL.ingredients END
FROM fa_fasklep_new.psshop_product_extra_fields PEF
JOIN fa_fasklep_new.psshop_product_extra_fields_lang PEFL ON (PEFL.id_extrafield = PEF.id_extrafield AND PEFL.id_lang = 2)
WHERE PEF.id_product = p.id_product
LIMIT 1
) AS 'nutrition_facts_en',
CASE p.active WHEN 1 THEN 'Yes' ELSE 'No' END AS 'active'
FROM fa_fasklep_new.psshop_product p
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)
WHERE
pl.id_shop = p.id_shop_default AND
pl.id_lang = '2' AND
p.id_product = '775'
LIMIT 1
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 pl.id_lang = 1 AND pal.id_lang = 1 AND pa.reference <> '' AND pa.ean13 <> '' AND p.id_product like '0' GROUP BY pac.id_product_attribute Refresh browser!
ICE to marka suplementów diety, które zawierają kompozycje idealnie dobranych dawek i synergistycznie działających substancji aktywnych, sprawdzających się u entuzjastów ćwiczeń fizycznych na poziomie podstawowym i zaawansowanym. Produkty z linii ICE gwarantują uczucie niesamowitej świeżości, co jest uwarunkowane obecnością nowatorskiego składnika EVERCOOL.