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






Kleur
Wijdtemaat
Maat
Merk
Prijs
t/m
Aanbiedingen
1 - 6 van 6
Sorteer op:

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

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

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

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

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

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


