Halltorp Rördelar

JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.

Produkter

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_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 (3, 13, 75, 167, 186, 207, 217, 221, 232, 264, 285, 554, 560, 625, 299, 322, 330, 421, 422, 423, 424, 425, 405, 4, 527, 523, 168, 187, 208, 218, 222, 676, 265, 286, 300, 323, 331, 426, 453, 460, 464, 555, 611, 626, 526, 529, 524, 171, 193, 211, 229, 677, 268, 292, 301, 324, 354, 428, 454, 461, 465, 547, 556, 612, 627, 646, 180, 196, 214, 231, 274, 295, 302, 325, 374, 455, 462, 548, 557, 5, 181, 201, 279, 513, 303, 326, 393, 544, 463, 558, 6, 182, 282, 514, 304, 327, 630, 7, 183, 693, 305, 328, 559, 8, 185, 306, 329, 307, 10, 308, 309, 12, 310, 311, 312, 542, 313, 314, 315, 316, 317, 318, 319, 509, 510, 511, 512, 320, 321, 169, 172, 188, 194, 197, 539, 209, 212, 215, 219, 223, 230, 661, 269, 275, 280, 283, 650, 293, 296, 332, 355, 375, 394, 427, 443, 457, 458, 297, 298, 77, 78, 15, 16, 496, 549, 561, 578, 603, 587, 596, 613, 619, 631, 233, 678, 170, 175, 189, 195, 198, 540, 210, 213, 216, 220, 226, 545, 662, 271, 276, 281, 284, 649, 294, 333, 356, 376, 395, 429, 444, 456, 459, 80, 81, 18, 19, 494, 550, 562, 579, 588, 597, 614, 620, 632, 234, 679, 695, 179, 190, 648, 199, 277, 334, 357, 377, 396, 430, 445, 83, 86, 84, 20, 23, 497, 551, 581, 598, 633, 651, 680, 191, 200, 278, 658, 335, 358, 378, 397, 431, 446, 89, 87, 22, 26, 498, 552, 634, 235, 681, 192, 671, 336, 359, 379, 398, 432, 447, 92, 90, 25, 29, 499, 553, 635, 653, 682, 516, 337, 360, 380, 399, 433, 448, 95, 93, 28, 32, 500, 636, 654, 683, 517, 338, 361, 381, 400, 434, 449, 98, 96, 31, 35, 501, 637, 652, 684, 507, 362, 382, 533, 435, 450, 101, 99, 34, 416, 538, 638, 236, 685, 339, 363, 383, 401, 436, 451, 104, 102, 415, 39, 534, 639, 655, 686, 340, 364, 384, 402, 437, 452, 107, 105, 38, 42, 645, 640, 656, 687, 341, 365, 385, 530, 438, 110, 108, 41, 50, 641, 237, 688, 342, 366, 386, 531, 439, 419, 111, 43, 53, 642, 238, 689, 343, 367, 387, 532, 440, 114, 420, 49, 56, 239, 690, 508, 368, 388, 403, 441, 117, 115, 45, 59, 240, 691, 344, 369, 404, 442, 120, 118, 46, 68, 657, 692, 345, 370, 390, 122, 123, 44, 71, 241, 346, 371, 125, 126, 647, 74, 242, 347, 372, 128, 129, 52, 62, 243, 348, 373, 131, 132, 55, 244, 349, 502, 134, 135, 58, 245, 350, 503, 137, 138, 67, 246, 351, 504, 140, 141, 70, 247, 352, 505, 143, 144, 73, 248, 353, 506, 146, 147, 61, 249, 149, 150, 250, 151, 525, 47, 251, 152, 155, 541, 252, 154, 158, 253, 157, 164, 254, 159, 166, 255, 160, 256, 161, 257, 162, 258, 163, 165, 259, 262, 263, 173, 176, 224, 227, 270, 272, 535, 202, 417, 563, 569, 585, 589, 604, 615, 617, 621, 623, 287, 289, 659, 267, 663, 696, 174, 177, 225, 228, 543, 273, 536, 203, 206, 564, 570, 586, 590, 605, 616, 618, 622, 624, 288, 290, 660, 266, 664, 697, 178, 537, 204, 571, 591, 674, 546, 643, 628, 629, 592, 593, 594, 595, 565, 567, 572, 574, 577, 606, 608, 644, 675, 566, 568, 573, 575, 607, 609, 576, 610)) AND (t_d.attribute_id IN ('45')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))

Meny

MEJERIRÖRDELAR

Läs mer >>

KLÄMRINGSKOPPLINGAR

Läs mer >>