SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'new' AND categoryid = 0 AND manufacturerid = 80 LIMIT 1
Filter
![HASSIA Turin H - 4_306924_3200](upload/products/167/836/turin-h.jpg)
![HASSIA Piazenca G - 4_301688_0100](upload/products/167/832/piazenca-g.jpg)
![HASSIA metallizzard J - 303333_0100](upload/products/167/500/metallizzard-j.jpg)
Kleur
Wijdtemaat
Maat
Prijs
t/m
Nieuwe producten Hassia
1 - 3 van 3
Sorteer op:
![HASSIA Turin H - 4_306924_3200](upload/products/167/836/turin-h.jpg)
object(stdClass)#171 (46) {
["id"]=>
string(3) "527"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "836"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(13) "4_306924_3200"
["price"]=>
string(6) "189.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(30) "HASSIA Turin H - 4_306924_3200"
["keyname"]=>
string(7) "turin-h"
["label"]=>
string(0) ""
["path"]=>
string(14) "/dames/laarzen"
["manufacturer_id"]=>
string(2) "80"
["manufacturer_name"]=>
string(6) "Hassia"
["manufacturer_keyname"]=>
string(6) "hassia"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["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"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(6) "189.95"
}
HassiaHASSIA Turin H - 4_306924_3200€ 189,95
![HASSIA Piazenca G - 4_301688_0100](upload/products/167/832/piazenca-g.jpg)
object(stdClass)#166 (46) {
["id"]=>
string(3) "525"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "832"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(13) "4_301688_0100"
["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) "HASSIA Piazenca G - 4_301688_0100"
["keyname"]=>
string(10) "piazenca-g"
["label"]=>
string(0) ""
["path"]=>
string(27) "/dames/instappers-trotteurs"
["manufacturer_id"]=>
string(2) "80"
["manufacturer_name"]=>
string(6) "Hassia"
["manufacturer_keyname"]=>
string(6) "hassia"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["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"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(6) "149.95"
}
HassiaHASSIA Piazenca G - 4_301688_0100€ 149,95
![HASSIA metallizzard J - 303333_0100](upload/products/167/500/metallizzard-j.jpg)
object(stdClass)#171 (46) {
["id"]=>
string(3) "327"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "500"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(11) "303333_0100"
["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(35) "HASSIA metallizzard J - 303333_0100"
["keyname"]=>
string(14) "metallizzard-j"
["label"]=>
string(0) ""
["path"]=>
string(24) "/dames/pumps-ballerina-s"
["manufacturer_id"]=>
string(2) "80"
["manufacturer_name"]=>
string(6) "Hassia"
["manufacturer_keyname"]=>
string(6) "hassia"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["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"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(6) "149.95"
}
HassiaHASSIA metallizzard J - 303333_0100€ 149,95