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

Aanbiedingen

1 - 6 van 6
Sorteer op:
VERHULST wijdte H Lana - 1356_146-186_2584 wijdte H
object(stdClass)#100 (46) { ["id"]=> string(4) "2491" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3556" ["serial_number"]=> string(0) "" ["article_number"]=> string(26) "1356_146-186_2584 wijdte H" ["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(51) "VERHULST wijdte H Lana - 1356_146-186_2584 wijdte H" ["keyname"]=> string(13) "wijdte-h-lana" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/sandalen" ["manufacturer_id"]=> string(2) "26" ["manufacturer_name"]=> string(8) "Verhulst" ["manufacturer_keyname"]=> string(8) "verhulst" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "25.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) "25.00" ["price_lowest"]=> string(6) "112.46" }
VerhulstVERHULST wijdte H Lana - 1356_146-186_2584 wijdte H
€ 149,95€ 112,46
TWINS wijdte 5 - 322200_500_wijdte 5_Lola Legend
object(stdClass)#105 (46) { ["id"]=> string(4) "2170" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3162" ["serial_number"]=> string(0) "" ["article_number"]=> string(31) "322200_500_wijdte 5_Lola Legend" ["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(48) "TWINS wijdte 5 - 322200_500_wijdte 5_Lola Legend" ["keyname"]=> string(8) "wijdte-5" ["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(7) "percent" ["discount_value"]=> string(5) "25.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) "25.00" ["price_lowest"]=> string(6) "104.96" }
TWINSTWINS wijdte 5 - 322200_500_wijdte 5_Lola Legend
€ 139,95€ 104,96
RED RAG 19260_359
object(stdClass)#100 (46) { ["id"]=> string(4) "1267" ["children"]=> string(1) "0" ["photoid"]=> string(4) "1946" ["serial_number"]=> string(0) "" ["article_number"]=> string(9) "19260_359" ["price"]=> string(5) "69.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 19260_359" ["keyname"]=> string(9) "19260_359" ["label"]=> string(0) "" ["path"]=> string(17) "/meisjes/sandalen" ["manufacturer_id"]=> string(2) "93" ["manufacturer_name"]=> string(7) "Red Rag" ["manufacturer_keyname"]=> string(7) "red-rag" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "25.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) "25.00" ["price_lowest"]=> string(5) "52.46" }
Red RagRED RAG 19260_359
€ 69,95€ 52,46
TRACKSTYLE Wijdte 2.5 - 320370_129 wijdte 2.5
object(stdClass)#105 (46) { ["id"]=> string(4) "1173" ["children"]=> string(1) "0" ["photoid"]=> string(4) "1806" ["serial_number"]=> string(0) "" ["article_number"]=> string(21) "320370_129 wijdte 2.5" ["price"]=> string(6) "114.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(45) "TRACKSTYLE Wijdte 2.5 - 320370_129 wijdte 2.5" ["keyname"]=> string(9) "wijdte-25" ["label"]=> string(0) "" ["path"]=> string(26) "/jongens/molieres-sneakers" ["manufacturer_id"]=> string(2) "31" ["manufacturer_name"]=> string(10) "Trackstyle" ["manufacturer_keyname"]=> string(10) "trackstyle" ["discount_type"]=> string(7) "percent" ["discount_value"]=> string(5) "25.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) "25.00" ["price_lowest"]=> string(5) "86.21" }
TrackstyleTRACKSTYLE Wijdte 2.5 - 320370_129 wijdte 2.5
€ 114,95€ 86,21
THINK Julia Fisherman - 2-82343-25
object(stdClass)#100 (46) { ["id"]=> string(3) "652" ["children"]=> string(1) "0" ["photoid"]=> string(4) "1043" ["serial_number"]=> string(0) "" ["article_number"]=> string(10) "2-82343-25" ["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(34) "THINK Julia Fisherman - 2-82343-25" ["keyname"]=> string(15) "julia-fisherman" ["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) "50.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) "50.00" ["price_lowest"]=> string(5) "49.98" }
ThinkTHINK Julia Fisherman - 2-82343-25
€ 99,95€ 49,98
TIMBERLAND zz K band - 20598
object(stdClass)#105 (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(7) "percent" ["discount_value"]=> string(5) "50.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) "50.00" ["price_lowest"]=> string(5) "44.98" }
TimberlandTIMBERLAND zz K band - 20598
€ 89,95€ 44,98