SELECT td_stock.id, td_stock.bar_code, td_stock.main_code, td_stock.name, td_stock.reg_id, td_stock.quantity, td_stock.discr, td_stock.pht_invis, td_stock.site_invis, td_stock.price, td_stock.brand_id, td_stock.1_level_id, td_stock.2_level_id, td_stock.photo_id, td_stock.discon, td_stock.fragility, td_stock.is_del, td_brands.name as brand_name, td_1_level_type.name as 1level_name, td_2_level_type.name as 2level_name, tab_real_stock.shop_quant, tab_real_stock.wareh_quant FROM td_stock JOIN (SELECT td_stock_shop.bar_code as bar_code_shop, td_stock_shop.quantity as shop_quant, td_stock_shop_warehouse.quantity as wareh_quant FROM td_stock_shop INNER JOIN td_stock_shop_warehouse ON td_stock_shop.bar_code = td_stock_shop_warehouse.bar_code )as tab_real_stock ON td_stock.bar_code = tab_real_stock.bar_code_shop INNER JOIN td_brands ON td_stock.brand_id=td_brands.id INNER JOIN td_1_level_type ON td_stock.1_level_id=td_1_level_type.id INNER JOIN td_2_level_type ON td_stock.2_level_id=td_2_level_type.id WHERE ORDER BY Query failed :