miteam

sql_query			= \
		SELECT ((pd.language_id << 22) | pd.product_id) as pr_id, pd.product_id AS product_id_attr, pd.name as name, description, pm.name as manufacturer, p.manufacturer_id as manufacturer_id, model, sku, ean, jan, isbn, mpn, price, quantity, p.status AS status, pd.language_id as language_id, date_available, \
		(SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = pd.product_id) as rating \
		FROM oc_product p \
		LEFT JOIN oc_product_description pd ON p.product_id = pd.product_id \
		LEFT JOIN oc_manufacturer pm ON p.manufacturer_id = pm.manufacturer_id
	
	sql_attr_uint 		= product_id_attr
	sql_field_string 	= name
	sql_field_string 	= description
	sql_field_string 	= model
	sql_field_string 	= sku
	sql_field_string 	= ean
	sql_field_string 	= jan
	sql_field_string 	= isbn
	sql_field_string 	= mpn
	sql_attr_float 	 	= price
	sql_attr_uint 	 	= quantity
	sql_attr_uint 	 	= status
	sql_attr_uint 	 	= language_id
	sql_attr_uint 		= manufacturer_id
	sql_attr_timestamp 	= date_available
	sql_attr_float 		= rating
	sql_attr_multi      = uint categories_filter from query; \
							SELECT ((cd.language_id << 22) | pc.product_id) as product_id, pc.category_id \
							FROM oc_product_to_category pc \
							LEFT JOIN oc_category c ON pc.category_id = c.category_id \
							LEFT JOIN oc_category_description cd ON c.category_id = cd.category_id \
							WHERE c.status=1;
	
	sql_attr_multi      = uint store_filter from query; \
							SELECT ((pd.language_id << 22) | ps.product_id) as product_id, ps.store_id \
							FROM oc_product_to_store ps \
							LEFT JOIN oc_product_description pd ON ps.product_id = pd.product_id;
							
	sql_attr_multi = uint product_attribute from query; \
      SELECT ((pa.language_id << 22) | pa.product_id) as product_id, \
      CRC32(CONCAT(pa.attribute_id,pa.text)) \
      FROM oc_product_attribute pa;