CREATE or REPLACE view itemsview as 
 Select items.* , categories.* from items
INNER JOIN categories ON  categories.categories_id=items.items_cat



-- select item1sview.* ,1 AS favorite from item1sview INNER JOIN favorite ON favorite.favorite_itemsid =item1sview.items_id WHERE favorite.favorite_usersid=21

-- UNION ALL 

-- select item1sview.* ,0 AS favorite from item1sview 
-- WHERE items_id !=(select item1sview.items_id from item1sview INNER JOIN favorite ON favorite.favorite_itemsid =item1sview.items_id WHERE favorite.favorite_usersid=21
-- )

CREATE or REPLACE view  myfavorite AS
 SELECT favorite.* , items.* , users.users_id FROM favorite
INNER JOIN users ON users.users_id=favorite.favorite_usersid
INNER JOIN items ON items.items_id=favorite.favorite_itemsid


CREATE OR REPLACE VIEW cartview AS
SELECT COUNT(cart.cart_itemsid) as countitem , SUM(items.items_price - items.items_price * items.items_discount / 100) as itemprice ,cart.* ,items.*  FROM cart
INNER JOIN items on items.items_id=cart.cart_itemsid
WHERE cart_orders=0
GROUP BY cart.cart_usersid ,cart.cart_itemsid


CREATE OR REPLACE VIEW ordersdetailsview AS
SELECT COUNT(cart.cart_itemsid) as countitems , SUM(items.items_price - items.items_price * items.items_discount / 100) as itemprice ,cart.* ,items.*  FROM cart
INNER JOIN items ON items.items_id=cart.cart_itemsid

WHERE cart_orders !=0
GROUP BY cart.cart_itemsid,cart.cart_usersid ,cart.cart_orders


CREATE or REPLACE VIEW ordersview AS

SELECT orders.*, address.* FROM orders
LEFT JOIN address ON address.address_id=orders.orders_address


CREATE OR REPLACE VIEW itemstopselling AS
SELECT COUNT(cart_id) AS countitems , cart.*, items.*  , (items_price - (items_price * items_discount / 100)) AS itempricediscount  FROM cart
INNER JOIN items ON items.items_id=cart.cart_itemsid

WHERE cart_orders !=0
GROUP BY cart_itemsid