VbzCart/docs/queries/qryStk Bins w info

About

• Returns: stk_bins with additional information
• Requires: Template:Vbzcart, Template:Vbzcart/query
• Used by: Special:VbzAdmin's stock bin listing page
• History:
  • 2009-04-29 Created for Special:VbzAdmin

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_Bins_w_info AS

 SELECT
   sb.*,
   sp.Name AS PlaceName,
   sq.QtyForSale,
   sq.QtyForShip,
   sq.QtyExisting
 FROM stk_bins AS sb
   LEFT JOIN qryStk_lines_remaining_byBin AS sq

ON sb.ID=sq.ID_Bin

   LEFT JOIN stk_places as sp

ON sb.ID_Place=sp.ID;</mysql> <section end=sql />