| Category ID | id_category (NUMBER) | * select = 'c.`id_category`'; |
| Parent category ID | id_parent (NUMBER) | * select = 'c.`id_parent`'; |
| Category Name | category_name (TEXT) | * select = 'COALESCE(`category_lang`.name, '') as `category_name`';
* join = 'LEFT JOIN `ps_category_lang` `category_lang` ON `category_lang`.id_category = c.id_category AND `category_lang`.id_lang = 1'; |
| Turnover HT | turnover_tax_excl (NUMBER) | * select = 'c.nleft, c.nright';
|
| Turnover TTC | turnover_tax_incl (NUMBER) | * select = 'c.nleft, c.nright';
|
| Category depth | level_depth (NUMBER) | * select = 'c.`level_depth`'; |
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = cs.id_shop'; |