SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = c.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_shop` = 1)
LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.id_shop = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 4
AND c.`id_parent` = 33
AND c.id_category IN (
WHERE `id_group` IN (1)
ORDER BY `level_depth` ASC, cs.`position` ASC
iPhone 8 Plus
iPhone is celebrating it's tenth birthday !
That is why we're entitled to 3 new devices in 2017. Where the iPhone X really slices with the previous models, the iPhone 8 and 8 Plus stay in line. However, they deserve a closer look; their highly refined and polished design unveils serious cutting-edge hardware and a powerful performance that's ahead of the pack.
Our i-Phone 8 Plus devices have been rigorously diagnosed before being refurbished and evaluated to ensure the highest possible quality. A smart alternative at a low price!