| Cart ID | id_cart (NUMBER) | * select = 'cp.`id_cart`'; |
| Product ID | id_product (NUMBER) | * select = 'cp.`id_product`'; |
| Combination ID | id_product_attribute (NUMBER) | * select = 'cp.`id_product_attribute`'; |
| Name | name (TEXT) | * select = 'cp.id_product, cp.id_product_attribute';
|
| Quantity | quantity (NUMBER) | * select = 'cp.`quantity`'; |
| Adding date | date_add (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(cp.date_add, '%Y%m%d%H') as date_add';
|
| Category | category (TEXT) | * select = 'COALESCE(`categorylang`.`name`, '') as `category`';
* join = 'LEFT JOIN `ps_product_shop` `pscl` ON `pscl`.id_product = cp.id_product AND `pscl`.id_shop = c.id_shop LEFT JOIN `ps_category_lang` `categorylang` ON `categorylang`.id_category = `pscl`.id_category_default AND `categorylang`.id_shop = c.id_shop AND `categorylang`.id_lang = 1'; |
| Manufacturer | manufacturer (TEXT) | * select = 'COALESCE(`manufacturer`.`name`, '') as `manufacturer`';
* join = 'LEFT JOIN `ps_product` `product_manufacturer` ON `product_manufacturer`.id_product = cp.id_product LEFT JOIN `ps_manufacturer` `manufacturer` ON `manufacturer`.id_manufacturer = `product_manufacturer`.id_manufacturer'; |
| Supplier | supplier (TEXT) | * select = 'COALESCE(`supplier`.`name`, `supplier_2`.`name`, '') as `supplier`';
* join = 'LEFT JOIN `ps_product` `product_id_supplier` ON `product_id_supplier`.id_product = cp.id_product LEFT JOIN `ps_supplier` `supplier` ON `supplier`.id_supplier = `product_id_supplier`.id_supplier LEFT JOIN `ps_product_supplier` `product_supplier` ON `product_supplier`.id_product = cp.id_product AND `product_supplier`.id_product_attribute = cp.id_product_attribute LEFT JOIN `ps_supplier` `supplier_2` ON `supplier_2`.id_supplier = `product_supplier`.id_supplier'; |
| Image | image (TEXT) | * select = 'COALESCE(`product_image`.id_image, '') as image';
* join = 'LEFT JOIN `ps_image` `product_image` ON `product_image`.id_product = cp.id_product AND `product_image`.cover = 1'; |
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name as `shop`, '') as shop';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = c.id_shop'; |