Napravi svoj (RE)MIKS kojim ćeš obeležiti novu sezonu.
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (908638, 1211399, 1273083, 1274985, 1275205, 1275280, 1275729, 1276174, 1363573, 1363653, 1364143, 1364733, 1376019, 1376229, 1489949, 1518198, 1536954, 1537244, 1537454, 1541811, 1542021, 1542051, 1542112, 1593452, 1597424, 1597799, 1597829, 1610053, 1620809, 1629100, 1652293, 1652953, 1653333, 1653653, 1757883, 1757913, 1780334, 1780649, 1785051, 1859654, 1860084, 1860159, 1864671, 1864696, 1872971)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 121, 124, 135, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 163, 164, 165, 166, 167, 168, 169, 170, 171, 325, 331)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (908638, 1211399, 1273083, 1274985, 1275205, 1275280, 1275729, 1276174, 1363573, 1363653, 1364143, 1364733, 1376019, 1376229, 1489949, 1518198, 1536954, 1537244, 1537454, 1541811, 1542021, 1542051, 1542112, 1593452, 1597424, 1597799, 1597829, 1610053, 1620809, 1629100, 1652293, 1652953, 1653333, 1653653, 1757883, 1757913, 1780334, 1780649, 1785051, 1859654, 1860084, 1860159, 1864671, 1864696, 1872971)) AND (t_d.attribute_id IN (76, 175, 177, 184, 231, 234, 240, 243, 284, 291, 303, 335, 352)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (908638, 1211399, 1273083, 1274985, 1275205, 1275280, 1275729, 1276174, 1363573, 1363653, 1364143, 1364733, 1376019, 1376229, 1489949, 1518198, 1536954, 1537244, 1537454, 1541811, 1542021, 1542051, 1542112, 1593452, 1597424, 1597799, 1597829, 1610053, 1620809, 1629100, 1652293, 1652953, 1653333, 1653653, 1757883, 1757913, 1780334, 1780649, 1785051, 1859654, 1860084, 1860159, 1864671, 1864696, 1872971)) AND (t_d.attribute_id IN (78, 123, 143, 144, 145, 146)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (908638, 1211399, 1273083, 1274985, 1275205, 1275280, 1275729, 1276174, 1363573, 1363653, 1364143, 1364733, 1376019, 1376229, 1489949, 1518198, 1536954, 1537244, 1537454, 1541811, 1542021, 1542051, 1542112, 1593452, 1597424, 1597799, 1597829, 1610053, 1620809, 1629100, 1652293, 1652953, 1653333, 1653653, 1757883, 1757913, 1780334, 1780649, 1785051, 1859654, 1860084, 1860159, 1864671, 1864696, 1872971)) AND (t_d.attribute_id IN (79, 80, 94, 95, 237, 246, 252)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (908638, 1211399, 1273083, 1274985, 1275205, 1275280, 1275729, 1276174, 1363573, 1363653, 1364143, 1364733, 1376019, 1376229, 1489949, 1518198, 1536954, 1537244, 1537454, 1541811, 1542021, 1542051, 1542112, 1593452, 1597424, 1597799, 1597829, 1610053, 1620809, 1629100, 1652293, 1652953, 1653333, 1653653, 1757883, 1757913, 1780334, 1780649, 1785051, 1859654, 1860084, 1860159, 1864671, 1864696, 1872971)) AND (t_d.attribute_id IN (83, 97, 125, 128, 130, 132, 133, 134, 136, 178, 179, 180, 181, 183, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 205, 222, 225, 228, 249, 258, 281, 285, 288, 306, 309, 312, 315, 318, 321, 354, 380, 385, 390, 395, 400, 405)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
Koristimo tehnologiju poznatu kao „kolačići“ za prikupljanje i analizu podataka, kao i za prikazivanje oglašavanja, na osnovu tvog profila i navika pregledanja sajta. Klikom na Detaljnije, možeš pogledati informacije o kolačićima koje koristimo.
Postavke kolačića
Koristimo tehnologiju poznatu kao „kolačići“ za prikupljanje i analizu podataka, kao i za prikazivanje oglašavanja, na osnovu tvog profila i navika pregledanja sajta. Upravljanjem ovim postavkama kolačića, možeš da nam omogućiš ili onemogućiš određeni skup kolačića, po unapred definisanoj kategorizaciji.