SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'discounts' AND categoryid = 0 AND manufacturerid = 0 LIMIT 1
Filter
Kleur
Maat
Merk
Prijs
t/m
Aanbiedingen
1 - 5 van 5
Sorteer op:
object(stdClass)#96 (46) {
["id"]=>
string(4) "1507"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "2289"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(9) "13443_839"
["price"]=>
string(5) "99.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(41) "RED RAG Low cut sneaker laces - 13443_839"
["keyname"]=>
string(21) "low-cut-sneaker-laces"
["label"]=>
string(0) ""
["path"]=>
string(26) "/jongens/molieres-sneakers"
["manufacturer_id"]=>
string(2) "93"
["manufacturer_name"]=>
string(7) "Red Rag"
["manufacturer_keyname"]=>
string(7) "red-rag"
["discount_type"]=>
string(8) "relative"
["discount_value"]=>
string(5) "30.00"
["discount_color"]=>
string(0) ""
["discount_label"]=>
string(6) "Outlet"
["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(8) "relative"
["value"]=>
string(5) "30.00"
["price_lowest"]=>
string(5) "69.95"
}
Red RagRED RAG Low cut sneaker laces - 13443_839€ 99,95€ 69,95
object(stdClass)#101 (46) {
["id"]=>
string(3) "927"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "1458"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(14) "25N_grey combi"
["price"]=>
string(6) "129.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(25) "BERKELMANS 25N_grey combi"
["keyname"]=>
string(14) "25n_grey-combi"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["discount_type"]=>
string(8) "relative"
["discount_value"]=>
string(5) "30.00"
["discount_color"]=>
string(0) ""
["discount_label"]=>
string(6) "Outlet"
["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(8) "relative"
["value"]=>
string(5) "30.00"
["price_lowest"]=>
string(5) "99.95"
}
BERKELMANSBERKELMANS 25N_grey combi€ 129,95€ 99,95
object(stdClass)#96 (46) {
["id"]=>
string(3) "253"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "346"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(18) "668102PN_Noce Lino"
["price"]=>
string(6) "139.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(41) "PIEDI NUDI Noce_Lino - 668102PN_Noce Lino"
["keyname"]=>
string(9) "noce_lino"
["label"]=>
string(0) ""
["path"]=>
string(15) "/dames/molieres"
["manufacturer_id"]=>
string(2) "15"
["manufacturer_name"]=>
string(10) "Piedi Nudi"
["manufacturer_keyname"]=>
string(10) "piedi-nudi"
["discount_type"]=>
string(8) "relative"
["discount_value"]=>
string(5) "30.00"
["discount_color"]=>
string(0) ""
["discount_label"]=>
string(6) "Outlet"
["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(8) "relative"
["value"]=>
string(5) "30.00"
["price_lowest"]=>
string(6) "109.95"
}
Piedi NudiPIEDI NUDI Noce_Lino - 668102PN_Noce Lino€ 139,95€ 109,95
object(stdClass)#101 (46) {
["id"]=>
string(3) "245"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "330"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(11) "70037N_0145"
["price"]=>
string(5) "99.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) "PIEDRO Piedro sport - 70037N_0145"
["keyname"]=>
string(12) "piedro-sport"
["label"]=>
string(0) ""
["path"]=>
string(17) "/meisjes/sportief"
["manufacturer_id"]=>
string(2) "45"
["manufacturer_name"]=>
string(6) "PIEDRO"
["manufacturer_keyname"]=>
string(6) "piedro"
["discount_type"]=>
string(8) "relative"
["discount_value"]=>
string(5) "30.00"
["discount_color"]=>
string(0) ""
["discount_label"]=>
string(6) "Outlet"
["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(8) "relative"
["value"]=>
string(5) "30.00"
["price_lowest"]=>
string(5) "69.95"
}
PIEDROPIEDRO Piedro sport - 70037N_0145€ 99,95€ 69,95
object(stdClass)#96 (46) {
["id"]=>
string(1) "1"
["children"]=>
string(1) "0"
["photoid"]=>
string(1) "1"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(5) "20598"
["price"]=>
string(5) "89.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(28) "TIMBERLAND zz K band - 20598"
["keyname"]=>
string(9) "zz-k-band"
["label"]=>
string(0) ""
["path"]=>
string(22) "/heren/muilen-slippers"
["manufacturer_id"]=>
string(1) "1"
["manufacturer_name"]=>
string(10) "Timberland"
["manufacturer_keyname"]=>
string(10) "timberland"
["discount_type"]=>
string(8) "relative"
["discount_value"]=>
string(5) "30.00"
["discount_color"]=>
string(0) ""
["discount_label"]=>
string(6) "Outlet"
["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(8) "relative"
["value"]=>
string(5) "30.00"
["price_lowest"]=>
string(5) "59.95"
}
TimberlandTIMBERLAND zz K band - 20598€ 89,95€ 59,95