$categories{"id_category":"118","name":"Nike Dunk","link_rewrite":"nike-dunk","id_shop":"1","children":{"124":{"id_category":"124","name":"Nike Dunk High","link_rewrite":"nike-dunk-high","id_shop":"1"},"125":{"id_category":"125","name":"Nike Dunk Low","link_rewrite":"nike-dunk-low","id_shop":"1","children":{"263":{"id_category":"263","name":"Nike Dunk Low Next Nature","link_rewrite":"nike-dunk-low-next-nature","id_shop":"1"},"162":{"id_category":"162","name":"Nike Dunk Low Disrupt","link_rewrite":"nike-dunk-low-disrupt","id_shop":"1"},"212":{"id_category":"212","name":"Nike Dunk Low Off White","link_rewrite":"nike-dunk-low-off-white","id_shop":"1"},"168":{"id_category":"168","name":"Nike Dunk Low SB","link_rewrite":"nike-dunk-low-sb","id_shop":"1"}}},"293":{"id_category":"293","name":"Svart Dunk","link_rewrite":"svart-dunk","id_shop":"1"},"294":{"id_category":"294","name":"Vit Dunk","link_rewrite":"vit-dunk","id_shop":"1"},"295":{"id_category":"295","name":"Bl\u00e5 Dunk","link_rewrite":"bla-dunk","id_shop":"1"},"296":{"id_category":"296","name":"Gr\u00f6n Dunk","link_rewrite":"gron-dunk","id_shop":"1"},"297":{"id_category":"297","name":"Dunk Rose","link_rewrite":"dunk-rose","id_shop":"1"},"298":{"id_category":"298","name":"Dunk Orange","link_rewrite":"dunk-orange","id_shop":"1"}}}

idcategory

idparent60

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"211","name":"Air Jordan 1","link_rewrite":"air-jordan-1","id_shop":"1"}

idcategory

idparent61

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"131","name":"New Balance 327","link_rewrite":"new-balance-327","id_shop":"1"}

idcategory

idparent113

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"208","name":"Yeezy 350 V1","link_rewrite":"yeezy-350-v1","id_shop":"1"}

idcategory

idparent57

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"236","name":"Adidas Samba","link_rewrite":"adidas-samba","id_shop":"1"}

idcategory

idparent119

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"258","name":"UGG Ultra Mini","link_rewrite":"ugg-ultra-mini","id_shop":"1"}

idcategory

idparent229

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"122","name":"Sneakers","link_rewrite":"sneakers","id_shop":"1","children":{"142":{"id_category":"142","name":"Sneakers levereras inom 48 timmar","link_rewrite":"sneakers-levereras-inom-48-timmar","id_shop":"1","children":{"171":{"id_category":"171","name":"35","link_rewrite":"35","id_shop":"1"},"172":{"id_category":"172","name":"35.5","link_rewrite":"355","id_shop":"1"},"164":{"id_category":"164","name":"36","link_rewrite":"36","id_shop":"1"},"173":{"id_category":"173","name":"36.5","link_rewrite":"365","id_shop":"1"},"165":{"id_category":"165","name":"37","link_rewrite":"37","id_shop":"1"},"176":{"id_category":"176","name":"37.5","link_rewrite":"375","id_shop":"1"},"166":{"id_category":"166","name":"38","link_rewrite":"38","id_shop":"1"},"177":{"id_category":"177","name":"38.5","link_rewrite":"385","id_shop":"1"},"169":{"id_category":"169","name":"39","link_rewrite":"39","id_shop":"1"},"180":{"id_category":"180","name":"39.5","link_rewrite":"395","id_shop":"1"},"170":{"id_category":"170","name":"40","link_rewrite":"40","id_shop":"1"},"181":{"id_category":"181","name":"40.5","link_rewrite":"405","id_shop":"1"},"183":{"id_category":"183","name":"41","link_rewrite":"41","id_shop":"1"},"185":{"id_category":"185","name":"41.5","link_rewrite":"415","id_shop":"1"},"186":{"id_category":"186","name":"42","link_rewrite":"42","id_shop":"1"},"187":{"id_category":"187","name":"42.5","link_rewrite":"425","id_shop":"1"},"189":{"id_category":"189","name":"43","link_rewrite":"43","id_shop":"1"},"191":{"id_category":"191","name":"43.5","link_rewrite":"435","id_shop":"1"},"192":{"id_category":"192","name":"44","link_rewrite":"44","id_shop":"1"},"193":{"id_category":"193","name":"44.5","link_rewrite":"445","id_shop":"1"},"195":{"id_category":"195","name":"45","link_rewrite":"45","id_shop":"1"},"197":{"id_category":"197","name":"45.5","link_rewrite":"455","id_shop":"1"},"198":{"id_category":"198","name":"46","link_rewrite":"46","id_shop":"1"},"199":{"id_category":"199","name":"46.5","link_rewrite":"465","id_shop":"1"},"201":{"id_category":"201","name":"47","link_rewrite":"47","id_shop":"1"}}},"145":{"id_category":"145","name":"Sneakers f\u00f6r kvinnor","link_rewrite":"sneakers-for-kvinnor","id_shop":"1","children":{"301":{"id_category":"301","name":"Jordan Kvinna","link_rewrite":"jordan-kvinna","id_shop":"1"},"302":{"id_category":"302","name":"Dunk Low Kvinna","link_rewrite":"dunk-low-kvinna","id_shop":"1"}}},"144":{"id_category":"144","name":"Sneakers f\u00f6r m\u00e4n","link_rewrite":"sneakers-for-man","id_shop":"1","children":{"303":{"id_category":"303","name":"Jordan M\u00e4n","link_rewrite":"jordan-man","id_shop":"1"},"304":{"id_category":"304","name":"Dunk Low M\u00e4n","link_rewrite":"dunk-low-man","id_shop":"1"}}},"204":{"id_category":"204","name":"Sneakers f\u00f6r barn och bebisar","link_rewrite":"sneakers-for-barn-och-bebisar","id_shop":"1","children":{"215":{"id_category":"215","name":"Nike Dunk barn och bebisar","link_rewrite":"nike-dunk-barn-och-bebisar","id_shop":"1"},"216":{"id_category":"216","name":"Air Jordan barn och bebisar","link_rewrite":"air-jordan-barn-och-bebisar","id_shop":"1"},"217":{"id_category":"217","name":"Air Force 1 barn och bebisar","link_rewrite":"air-force-1-barn-och-bebisar","id_shop":"1"},"218":{"id_category":"218","name":"Yeezy barn och bebisar","link_rewrite":"yeezy-barn-och-bebisar","id_shop":"1"}}},"227":{"id_category":"227","name":"Vita sneakers","link_rewrite":"vita-sneakers","id_shop":"1"},"251":{"id_category":"251","name":"Sneakers Svart","link_rewrite":"sneakers-svart","id_shop":"1"},"244":{"id_category":"244","name":"Gr\u00e5 sneakers","link_rewrite":"gra-sneakers","id_shop":"1"},"252":{"id_category":"252","name":"Beige Sneakers","link_rewrite":"beige-sneakers","id_shop":"1"},"250":{"id_category":"250","name":"Sneakers Brun","link_rewrite":"sneakers-brun","id_shop":"1"},"246":{"id_category":"246","name":"R\u00f6da sneakers","link_rewrite":"roda-sneakers","id_shop":"1"},"248":{"id_category":"248","name":"Gr\u00f6na sneakers","link_rewrite":"grona-sneakers","id_shop":"1"},"242":{"id_category":"242","name":"Sneakers Bl\u00e5","link_rewrite":"sneakers-bla","id_shop":"1"},"247":{"id_category":"247","name":"Gula sneakers","link_rewrite":"gula-sneakers","id_shop":"1"},"249":{"id_category":"249","name":"Orange sneakers","link_rewrite":"orange-sneakers","id_shop":"1"},"245":{"id_category":"245","name":"Violetta sneakers","link_rewrite":"violetta-sneakers","id_shop":"1"},"243":{"id_category":"243","name":"Rosa sneakers","link_rewrite":"rosa-sneakers","id_shop":"1"},"126":{"id_category":"126","name":"Nya sneakers","link_rewrite":"nya-sneakers","id_shop":"1"},"121":{"id_category":"121","name":"Kommande utg\u00e5vor av Sneakers","link_rewrite":"kommande-utgavor-av-sneakers","id_shop":"1"},"129":{"id_category":"129","name":"Sneakers B\u00e4sts\u00e4ljare","link_rewrite":"sneakers-bastsaljare","id_shop":"1"},"203":{"id_category":"203","name":"Trender f\u00f6r sneakers","link_rewrite":"trender-for-sneakers","id_shop":"1"},"149":{"id_category":"149","name":"Milj\u00f6anpassade sneakers","link_rewrite":"miljoanpassade-sneakers","id_shop":"1"},"134":{"id_category":"134","name":"Sneakers f\u00f6r under 200 euro","link_rewrite":"sneakers-for-under-200-euro","id_shop":"1"},"223":{"id_category":"223","name":"Presentkort","link_rewrite":"presentkort","id_shop":"1"},"148":{"id_category":"148","name":"Sneakers Rea","link_rewrite":"sneakers-rea","id_shop":"1"},"210":{"id_category":"210","name":"Sneakers \u00e5terinf\u00f6rs","link_rewrite":"sneakers-aterinfors","id_shop":"1"},"226":{"id_category":"226","name":"Julskor","link_rewrite":"julskor","id_shop":"1"},"225":{"id_category":"225","name":"Sneakers Black Friday","link_rewrite":"sneakers-black-friday","id_shop":"1"},"143":{"id_category":"143","name":"Sneakers f\u00f6r alla hj\u00e4rtans dag","link_rewrite":"sneakers-for-alla-hjartans-dag","id_shop":"1"},"140":{"id_category":"140","name":"Halloween-skor","link_rewrite":"halloween-skor","id_shop":"1"},"205":{"id_category":"205","name":"Sneakers f\u00f6r h\u00f6sten","link_rewrite":"sneakers-for-hosten","id_shop":"1"},"275":{"id_category":"275","name":"Mors dag","link_rewrite":"mors-dag","id_shop":"1"}}}

idcategory

idparent2

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"279","name":"Birkenstock Boston","link_rewrite":"birkenstock-boston","id_shop":"1"}

idcategory

idparent38

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"142","name":"Sneakers levereras inom 48 timmar","link_rewrite":"sneakers-levereras-inom-48-timmar","id_shop":"1","children":{"171":{"id_category":"171","name":"35","link_rewrite":"35","id_shop":"1"},"172":{"id_category":"172","name":"35.5","link_rewrite":"355","id_shop":"1"},"164":{"id_category":"164","name":"36","link_rewrite":"36","id_shop":"1"},"173":{"id_category":"173","name":"36.5","link_rewrite":"365","id_shop":"1"},"165":{"id_category":"165","name":"37","link_rewrite":"37","id_shop":"1"},"176":{"id_category":"176","name":"37.5","link_rewrite":"375","id_shop":"1"},"166":{"id_category":"166","name":"38","link_rewrite":"38","id_shop":"1"},"177":{"id_category":"177","name":"38.5","link_rewrite":"385","id_shop":"1"},"169":{"id_category":"169","name":"39","link_rewrite":"39","id_shop":"1"},"180":{"id_category":"180","name":"39.5","link_rewrite":"395","id_shop":"1"},"170":{"id_category":"170","name":"40","link_rewrite":"40","id_shop":"1"},"181":{"id_category":"181","name":"40.5","link_rewrite":"405","id_shop":"1"},"183":{"id_category":"183","name":"41","link_rewrite":"41","id_shop":"1"},"185":{"id_category":"185","name":"41.5","link_rewrite":"415","id_shop":"1"},"186":{"id_category":"186","name":"42","link_rewrite":"42","id_shop":"1"},"187":{"id_category":"187","name":"42.5","link_rewrite":"425","id_shop":"1"},"189":{"id_category":"189","name":"43","link_rewrite":"43","id_shop":"1"},"191":{"id_category":"191","name":"43.5","link_rewrite":"435","id_shop":"1"},"192":{"id_category":"192","name":"44","link_rewrite":"44","id_shop":"1"},"193":{"id_category":"193","name":"44.5","link_rewrite":"445","id_shop":"1"},"195":{"id_category":"195","name":"45","link_rewrite":"45","id_shop":"1"},"197":{"id_category":"197","name":"45.5","link_rewrite":"455","id_shop":"1"},"198":{"id_category":"198","name":"46","link_rewrite":"46","id_shop":"1"},"199":{"id_category":"199","name":"46.5","link_rewrite":"465","id_shop":"1"},"201":{"id_category":"201","name":"47","link_rewrite":"47","id_shop":"1"}}}

idcategory

idparent122

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"122","name":"Sneakers","link_rewrite":"sneakers","id_shop":"1","children":{"142":{"id_category":"142","name":"Sneakers levereras inom 48 timmar","link_rewrite":"sneakers-levereras-inom-48-timmar","id_shop":"1","children":{"171":{"id_category":"171","name":"35","link_rewrite":"35","id_shop":"1"},"172":{"id_category":"172","name":"35.5","link_rewrite":"355","id_shop":"1"},"164":{"id_category":"164","name":"36","link_rewrite":"36","id_shop":"1"},"173":{"id_category":"173","name":"36.5","link_rewrite":"365","id_shop":"1"},"165":{"id_category":"165","name":"37","link_rewrite":"37","id_shop":"1"},"176":{"id_category":"176","name":"37.5","link_rewrite":"375","id_shop":"1"},"166":{"id_category":"166","name":"38","link_rewrite":"38","id_shop":"1"},"177":{"id_category":"177","name":"38.5","link_rewrite":"385","id_shop":"1"},"169":{"id_category":"169","name":"39","link_rewrite":"39","id_shop":"1"},"180":{"id_category":"180","name":"39.5","link_rewrite":"395","id_shop":"1"},"170":{"id_category":"170","name":"40","link_rewrite":"40","id_shop":"1"},"181":{"id_category":"181","name":"40.5","link_rewrite":"405","id_shop":"1"},"183":{"id_category":"183","name":"41","link_rewrite":"41","id_shop":"1"},"185":{"id_category":"185","name":"41.5","link_rewrite":"415","id_shop":"1"},"186":{"id_category":"186","name":"42","link_rewrite":"42","id_shop":"1"},"187":{"id_category":"187","name":"42.5","link_rewrite":"425","id_shop":"1"},"189":{"id_category":"189","name":"43","link_rewrite":"43","id_shop":"1"},"191":{"id_category":"191","name":"43.5","link_rewrite":"435","id_shop":"1"},"192":{"id_category":"192","name":"44","link_rewrite":"44","id_shop":"1"},"193":{"id_category":"193","name":"44.5","link_rewrite":"445","id_shop":"1"},"195":{"id_category":"195","name":"45","link_rewrite":"45","id_shop":"1"},"197":{"id_category":"197","name":"45.5","link_rewrite":"455","id_shop":"1"},"198":{"id_category":"198","name":"46","link_rewrite":"46","id_shop":"1"},"199":{"id_category":"199","name":"46.5","link_rewrite":"465","id_shop":"1"},"201":{"id_category":"201","name":"47","link_rewrite":"47","id_shop":"1"}}},"145":{"id_category":"145","name":"Sneakers f\u00f6r kvinnor","link_rewrite":"sneakers-for-kvinnor","id_shop":"1","children":{"301":{"id_category":"301","name":"Jordan Kvinna","link_rewrite":"jordan-kvinna","id_shop":"1"},"302":{"id_category":"302","name":"Dunk Low Kvinna","link_rewrite":"dunk-low-kvinna","id_shop":"1"}}},"144":{"id_category":"144","name":"Sneakers f\u00f6r m\u00e4n","link_rewrite":"sneakers-for-man","id_shop":"1","children":{"303":{"id_category":"303","name":"Jordan M\u00e4n","link_rewrite":"jordan-man","id_shop":"1"},"304":{"id_category":"304","name":"Dunk Low M\u00e4n","link_rewrite":"dunk-low-man","id_shop":"1"}}},"204":{"id_category":"204","name":"Sneakers f\u00f6r barn och bebisar","link_rewrite":"sneakers-for-barn-och-bebisar","id_shop":"1","children":{"215":{"id_category":"215","name":"Nike Dunk barn och bebisar","link_rewrite":"nike-dunk-barn-och-bebisar","id_shop":"1"},"216":{"id_category":"216","name":"Air Jordan barn och bebisar","link_rewrite":"air-jordan-barn-och-bebisar","id_shop":"1"},"217":{"id_category":"217","name":"Air Force 1 barn och bebisar","link_rewrite":"air-force-1-barn-och-bebisar","id_shop":"1"},"218":{"id_category":"218","name":"Yeezy barn och bebisar","link_rewrite":"yeezy-barn-och-bebisar","id_shop":"1"}}},"227":{"id_category":"227","name":"Vita sneakers","link_rewrite":"vita-sneakers","id_shop":"1"},"251":{"id_category":"251","name":"Sneakers Svart","link_rewrite":"sneakers-svart","id_shop":"1"},"244":{"id_category":"244","name":"Gr\u00e5 sneakers","link_rewrite":"gra-sneakers","id_shop":"1"},"252":{"id_category":"252","name":"Beige Sneakers","link_rewrite":"beige-sneakers","id_shop":"1"},"250":{"id_category":"250","name":"Sneakers Brun","link_rewrite":"sneakers-brun","id_shop":"1"},"246":{"id_category":"246","name":"R\u00f6da sneakers","link_rewrite":"roda-sneakers","id_shop":"1"},"248":{"id_category":"248","name":"Gr\u00f6na sneakers","link_rewrite":"grona-sneakers","id_shop":"1"},"242":{"id_category":"242","name":"Sneakers Bl\u00e5","link_rewrite":"sneakers-bla","id_shop":"1"},"247":{"id_category":"247","name":"Gula sneakers","link_rewrite":"gula-sneakers","id_shop":"1"},"249":{"id_category":"249","name":"Orange sneakers","link_rewrite":"orange-sneakers","id_shop":"1"},"245":{"id_category":"245","name":"Violetta sneakers","link_rewrite":"violetta-sneakers","id_shop":"1"},"243":{"id_category":"243","name":"Rosa sneakers","link_rewrite":"rosa-sneakers","id_shop":"1"},"126":{"id_category":"126","name":"Nya sneakers","link_rewrite":"nya-sneakers","id_shop":"1"},"121":{"id_category":"121","name":"Kommande utg\u00e5vor av Sneakers","link_rewrite":"kommande-utgavor-av-sneakers","id_shop":"1"},"129":{"id_category":"129","name":"Sneakers B\u00e4sts\u00e4ljare","link_rewrite":"sneakers-bastsaljare","id_shop":"1"},"203":{"id_category":"203","name":"Trender f\u00f6r sneakers","link_rewrite":"trender-for-sneakers","id_shop":"1"},"149":{"id_category":"149","name":"Milj\u00f6anpassade sneakers","link_rewrite":"miljoanpassade-sneakers","id_shop":"1"},"134":{"id_category":"134","name":"Sneakers f\u00f6r under 200 euro","link_rewrite":"sneakers-for-under-200-euro","id_shop":"1"},"223":{"id_category":"223","name":"Presentkort","link_rewrite":"presentkort","id_shop":"1"},"148":{"id_category":"148","name":"Sneakers Rea","link_rewrite":"sneakers-rea","id_shop":"1"},"210":{"id_category":"210","name":"Sneakers \u00e5terinf\u00f6rs","link_rewrite":"sneakers-aterinfors","id_shop":"1"},"226":{"id_category":"226","name":"Julskor","link_rewrite":"julskor","id_shop":"1"},"225":{"id_category":"225","name":"Sneakers Black Friday","link_rewrite":"sneakers-black-friday","id_shop":"1"},"143":{"id_category":"143","name":"Sneakers f\u00f6r alla hj\u00e4rtans dag","link_rewrite":"sneakers-for-alla-hjartans-dag","id_shop":"1"},"140":{"id_category":"140","name":"Halloween-skor","link_rewrite":"halloween-skor","id_shop":"1"},"205":{"id_category":"205","name":"Sneakers f\u00f6r h\u00f6sten","link_rewrite":"sneakers-for-hosten","id_shop":"1"},"275":{"id_category":"275","name":"Mors dag","link_rewrite":"mors-dag","id_shop":"1"}}}

idcategory

idparent2

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0