SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'discounts' AND categoryid = 86389 AND manufacturerid = 0 LIMIT 1
Filter

Aanbiedingen

1 - 6 van 6
Sorteer op:
MEPHISTO Sandanyl 2830 - Helen_Mix_Graal_72368/Sandalyn 2830
object(stdClass)#128 (46) { ["id"]=> string(4) "4265" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5258" ["serial_number"]=> string(0) "" ["article_number"]=> string(35) "Helen_Mix_Graal_72368/Sandalyn 2830" ["price"]=> string(6) "109.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(60) "MEPHISTO Sandanyl 2830 - Helen_Mix_Graal_72368/Sandalyn 2830" ["keyname"]=> string(13) "sandanyl-2830" ["label"]=> string(0) "" ["path"]=> string(22) "/dames/muilen-slippers" ["manufacturer_id"]=> string(4) "1345" ["manufacturer_name"]=> string(8) "Mephisto" ["manufacturer_keyname"]=> string(8) "mephisto" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "30.00" ["discount_color"]=> string(2) "30" ["discount_label"]=> string(0) "" ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> string(7) "percent" ["value"]=> string(5) "30.00" ["price_lowest"]=> string(5) "76.97" }
MephistoMEPHISTO Sandanyl 2830 - Helen_Mix_Graal_72368/Sandalyn 2830
€ 109,95€ 76,97
HARTJES HIP Wijdte H - 192.0202/30_49.00  wijdte H
object(stdClass)#96 (46) { ["id"]=> string(4) "3502" ["children"]=> string(1) "0" ["photoid"]=> string(4) "4597" ["serial_number"]=> string(0) "" ["article_number"]=> string(27) "192.0202/30_49.00 wijdte H" ["price"]=> string(6) "219.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(50) "HARTJES HIP Wijdte H - 192.0202/30_49.00 wijdte H" ["keyname"]=> string(12) "hip-wijdte-h" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(2) "20" ["manufacturer_name"]=> string(7) "Hartjes" ["manufacturer_keyname"]=> string(7) "hartjes" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "30.00" ["discount_color"]=> string(2) "30" ["discount_label"]=> string(0) "" ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> string(7) "percent" ["value"]=> string(5) "30.00" ["price_lowest"]=> string(6) "153.97" }
HartjesHARTJES HIP Wijdte H - 192.0202/30_49.00 wijdte H
€ 219,95€ 153,97
HARTJES POP wijdte G - 132.2102/41_77.77 Wijdte G
object(stdClass)#128 (46) { ["id"]=> string(4) "2832" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3921" ["serial_number"]=> string(0) "" ["article_number"]=> string(26) "132.2102/41_77.77 Wijdte G" ["price"]=> string(6) "149.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(49) "HARTJES POP wijdte G - 132.2102/41_77.77 Wijdte G" ["keyname"]=> string(12) "pop-wijdte-g" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/sandalen" ["manufacturer_id"]=> string(2) "20" ["manufacturer_name"]=> string(7) "Hartjes" ["manufacturer_keyname"]=> string(7) "hartjes" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "30.00" ["discount_color"]=> string(2) "30" ["discount_label"]=> string(0) "" ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> string(7) "percent" ["value"]=> string(5) "30.00" ["price_lowest"]=> string(6) "104.97" }
HartjesHARTJES POP wijdte G - 132.2102/41_77.77 Wijdte G
€ 149,95€ 104,97
TEVA Verra W - 1006263_BCBK
object(stdClass)#96 (46) { ["id"]=> string(4) "2834" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3925" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "1006263_BCBK" ["price"]=> string(5) "79.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(27) "TEVA Verra W - 1006263_BCBK" ["keyname"]=> string(7) "verra-w" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/sandalen" ["manufacturer_id"]=> string(2) "36" ["manufacturer_name"]=> string(4) "Teva" ["manufacturer_keyname"]=> string(4) "teva" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "30.00" ["discount_color"]=> string(2) "30" ["discount_label"]=> string(0) "" ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> string(7) "percent" ["value"]=> string(5) "30.00" ["price_lowest"]=> string(5) "55.97" }
TevaTEVA Verra W - 1006263_BCBK
€ 79,95€ 55,97
AQA SHOES Valencia - A8537_A76B79
object(stdClass)#128 (46) { ["id"]=> string(4) "2468" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3493" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8537_A76B79" ["price"]=> string(6) "149.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(33) "AQA SHOES Valencia - A8537_A76B79" ["keyname"]=> string(8) "valencia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "33.00" ["discount_color"]=> string(0) "" ["discount_label"]=> string(0) "" ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> string(7) "percent" ["value"]=> string(5) "33.00" ["price_lowest"]=> string(6) "100.47" }
AQA SHOESAQA SHOES Valencia - A8537_A76B79
€ 149,95€ 100,47
THINK DUMIA - 0_80373_04
object(stdClass)#96 (46) { ["id"]=> string(3) "247" ["children"]=> string(1) "0" ["photoid"]=> string(3) "388" ["serial_number"]=> string(0) "" ["article_number"]=> string(10) "0_80373_04" ["price"]=> string(6) "104.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(24) "THINK DUMIA - 0_80373_04" ["keyname"]=> string(5) "dumia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/sandalen" ["manufacturer_id"]=> string(2) "24" ["manufacturer_name"]=> string(5) "Think" ["manufacturer_keyname"]=> string(5) "think" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "30.00" ["discount_color"]=> string(2) "30" ["discount_label"]=> string(0) "" ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> string(7) "percent" ["value"]=> string(5) "30.00" ["price_lowest"]=> string(5) "73.47" }
ThinkTHINK DUMIA - 0_80373_04
€ 104,95€ 73,47