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!
We have tailored our production to meet customer expectations and the standards of even the most demanding markets. The plant meets the highest standards in terms of production process safety (GMP), quality assurance (HACCP), hygiene (GHP), food safety (IFS) and Halal. In addition, we are FDA-certified by the US Food and Drug Administration, confirming that our products are safe, meet high quality requirements and have no adverse health effects.
GMP certification confirms that our production facilities operate in compliance with international standards for safety and quality control. This allows us to guarantee that every production stage – from the selection of raw materials to the finished product – is carried out under strictly controlled conditions, ensuring the highest quality of our supplements.
HACCP is a quality management system that identifies and controls potential hazards at every production stage. Our HACCP certification assures that the production process is kept under review for safety, which minimizes the risks associated with the products that reach consumers.
IFS encompasses a comprehensive food safety control system. IFS certification demonstrates that our supplements meet rigorous standards and can access international markets without worry.
GHP certification confirms that our production processes meet the highest hygiene standards. We pay special attention to the sanitation of machinery, raw materials, and production environment. This ensures that our dietary supplements are safe and free from contamination. Maintaining hygiene at every stage of production is a top priority for us.
The FDA certification, granted by the US Food and Drug Administration, confirms that our products are safe and meet the highest quality standards. The FDA regulates dietary supplements to ensure they are not hazardous to consumers' health, which gives confidence to our products in the US market.
Halal certification ensures our products comply with religious standards by meeting all composition and manufacturing process requirements. This enables our supplements to be sold in countries where compliance with Halal standards is required and allows us to access new markets where these standards are essential.