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` = 7 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` = 50 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC

Galaxy S7

Fluidity and power are there.
For the first time, the Korean giant develops his own cores. And he wins where he was expected to fail: the Exynos 8890 is indeed a very powerful SoC that ensures outstanding fluidity.