SELECT
products.id, products.images, products.video, products.products_colors_id, products.code, products.status, products.expected_date, products.bestPrice, products.price, products.price_offer, products.new_flag, products.new_start, products.new_end, products.offer_start, products.offer_end, products_text.title, products_text.description, products_text.files, slug.slug_url, (CASE WHEN (products.price_offer > 0 AND products.price > 0) THEN ((1 - (products.price_offer/products.price))*100) ELSE NULL END) as discount,
products_vs_attributes.quantity, products_vs_attributes.min_quantity, products_vs_attributes.products_sizes_id,
SUM(quantity) AS sum_quantity,
(SELECT COUNT(id) FROM products_vs_attributes WHERE products_vs_attributes.products_id = products.id) AS count_rows,
(SELECT MIN(products_vs_attributes.price) FROM products_vs_attributes WHERE products_vs_attributes.products_id = products.id) AS min_extra_price,
(SELECT MAX(products_vs_attributes.price) FROM products_vs_attributes WHERE products_vs_attributes.products_id = products.id) AS max_extra_price,
(CASE WHEN EXISTS (SELECT id FROM compare WHERE compare.products_id = products.id and compare.visitor_session = '9166252297153596287054215')
THEN 1
ELSE 0
END) AS compare
FROM products
INNER JOIN products_vs_attributes
ON products_vs_attributes.products_id=products.id
INNER JOIN products_text
ON products_text.products_id=products.id AND products_text.language_id='5'
INNER JOIN slug
ON slug.products_id=products.id AND slug.language_id='5'
WHERE slug.slug_url = 'calvin-klein-spellbound-bracelet-small-stainless-steel-amp-leather-kj0dbd09020s' AND products.pub='1'
GROUP BY products.id
order by products.id ASC
CALVIN KLEIN Spellbound Bracelet Small Stainless Steel & Leather KJ0DBD09020S
Κοσμήματα CALVIN KLEIN με μοντέρνο, μίνιμαλ σχεδιασμό με απλές γράμμες, άψογους συνδιασμούς χρωμάτων και σχέδια ξεχωριστά για τον άνδρα ή την γυναίκα με κορυφαία ποιότητα κατασκευής.
