SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'discounts' AND categoryid = 0 AND manufacturerid = 0 LIMIT 1
Filter
Kleur
Wijdtemaat
Maat
Merk
Prijs
t/m
Aanbiedingen
1 - 5 van 5
Sorteer op:
object(stdClass)#101 (46) {
["id"]=>
string(3) "633"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "1016"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(9) "19091_757"
["price"]=>
string(5) "64.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(17) "RED RAG 19091_757"
["keyname"]=>
string(9) "19091_757"
["label"]=>
string(0) ""
["path"]=>
string(17) "/jongens/sandalen"
["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) "34.95"
}
Red RagRED RAG 19091_757€ 64,95€ 34,95
object(stdClass)#93 (46) {
["id"]=>
string(4) "1507"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "2268"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(21) "320655_689_wijdte 3.5"
["price"]=>
string(6) "134.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(40) "TWINS wijdte 3.5 - 320655_689_wijdte 3.5"
["keyname"]=>
string(9) "wijdte-35"
["label"]=>
string(0) ""
["path"]=>
string(20) "/meisjes/boots-jeugd"
["manufacturer_id"]=>
string(2) "30"
["manufacturer_name"]=>
string(5) "TWINS"
["manufacturer_keyname"]=>
string(5) "twins"
["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) "104.95"
}
TWINSTWINS wijdte 3.5 - 320655_689_wijdte 3.5€ 134,95€ 134,95
object(stdClass)#101 (46) {
["id"]=>
string(3) "245"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "348"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(10) "316582_589"
["price"]=>
string(6) "119.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(32) "TRACKSTYLE wijdte 5 - 316582_589"
["keyname"]=>
string(8) "wijdte-5"
["label"]=>
string(0) ""
["path"]=>
string(34) "/jongens/halfhoog-boot-klittenband"
["manufacturer_id"]=>
string(2) "31"
["manufacturer_name"]=>
string(10) "Trackstyle"
["manufacturer_keyname"]=>
string(10) "trackstyle"
["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) "89.95"
}
TrackstyleTRACKSTYLE wijdte 5 - 316582_589€ 119,95€ 89,95
object(stdClass)#93 (46) {
["id"]=>
string(3) "243"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "344"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(11) "76117N_5992"
["price"]=>
string(6) "134.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(31) "PIEDRO wijdte 5.5 - 76117N_5992"
["keyname"]=>
string(9) "wijdte-55"
["label"]=>
string(0) ""
["path"]=>
string(26) "/meisjes/molieres-sneakers"
["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(6) "104.95"
}
PIEDROPIEDRO wijdte 5.5 - 76117N_5992€ 134,95€ 104,95
object(stdClass)#101 (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