Сортировать по:
Популярные выше
Показать:
20
function fn_category_selector_get_children($parent_id, $lang_code = CART_LANGUAGE) { return db_get_array( "SELECT c.category_id, cd.category FROM ?:categories AS c LEFT JOIN ?:category_descriptions AS cd ON cd.category_id = c.category_id AND cd.lang_code = ?s WHERE c.parent_id = ?i AND c.status = 'A' ORDER BY c.position, cd.category", $lang_code, $parent_id ); }