Полезные запросы для интернет-магазинов

SELECT * FROM shop_items_catalog_table;
shop_items_catalog_table

SELECT * FROM shop_items_catalog_table ORDER BY shop_items_catalog_price;

shop_items_catalog_price

update shop_items_catalog_table set shop_items_catalog_price = '00.00'

UPDATE `shop_items` SET `showed` = 0;

UPDATE `shop_items` a
LEFT JOIN `shop_warehouse_items` b ON
    a.id = b.shop_item_id
SET
    a.yandex_market = IF(b.count <= 0, '0', '1')