<!-- QuickQuote.SQL = SELECT DISTINCT l.YEAR, l.CATEGORY_DESC, l.SUBCAT_NAME, ceil(hb.highbuy) as highbuy, bc.buycount, ceil(ls.lowsell) as lowsell, sc.sellcount,
                pghl.hi_price, pghl.HI_DATE, pghl.lo_price, pghl.lo_date,
                pg7.hbprice7, pg7.lsprice7, pg7.cr7, 
                pg30.hbprice30, pg30.lsprice30, pg30.cr30,
                pg11.HBPRICE, pg11.LSPRICE, pg11.thisyrdate, 
                pgly.lyhbprice, pgly.lylsprice, pgly.lastyrdate,
                pg5yr.hbprice5yr, pg5yr.lsprice5yr, pg5yr.date5yr,
                fc.factory_cost,  pr.rating, 
                tqty.tquantity, tq30.tquantity30, tqty.tsold, tq30.tsold30 
  FROM  price_guide l
  LEFT OUTER JOIN (
            SELECT YEAR, category_id, subcategory_id, max(price) as highbuy
              FROM LISTINGS_V
             WHERE type = 'Wanted'
               AND uom = 'box'
               AND category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
            GROUP BY YEAR, category_id, subcategory_id
            ) hb ON  l.YEAR             = hb.year 
                 AND l.category_id      = hb.category_id
                 AND l.subcategory_id   = hb.subcategory_id
  LEFT OUTER JOIN (
            SELECT YEAR, category_id, subcategory_id, count(1) as buycount
              FROM LISTINGS_V
             WHERE type = 'Wanted'
               AND uom = 'box'
               AND category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
            GROUP BY YEAR, category_id, subcategory_id
            ) bc ON  l.YEAR             = bc.year 
                 AND l.category_id      = bc.category_id
                 AND l.subcategory_id   = bc.subcategory_id
  LEFT OUTER JOIN (
            SELECT YEAR, category_id, subcategory_id, min(price)*1.05 as lowsell
              FROM LISTINGS_V
             WHERE type = 'For Sale'
               AND uom = 'box'
               AND category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
            GROUP BY YEAR, category_id, subcategory_id
            ) ls ON  l.YEAR             = ls.year 
                 AND l.category_id      = ls.category_id
                 AND l.subcategory_id   = ls.subcategory_id
  LEFT OUTER JOIN (
            SELECT YEAR, category_id, subcategory_id, count(1) as sellcount
              FROM LISTINGS_V
             WHERE type = 'For Sale'
               AND uom = 'box'
               AND category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
            GROUP BY YEAR, category_id, subcategory_id
            ) sc ON  l.YEAR             = sc.year 
                 AND l.category_id      = sc.category_id
                 AND l.subcategory_id   = sc.subcategory_id
  LEFT OUTER JOIN (
            SELECT year, cat_desc, subcat_name, hi_price * 1.05 as hi_price, lo_price * 1.05 as lo_price, hi_date, lo_date, cat_id, subcat_id
              FROM PRICE_GUIDE_HILO
             WHERE cat_id = 21
               AND subcat_id = 33178
               AND year = '2017' 
             ) pghl ON  l.year          = pghl.year
                    AND l.CATEGORY_id   = pghl.cat_id
                    AND l.subcategory_id = pghl.subcat_id
  LEFT OUTER JOIN (
            SELECT year, category_id, subcategory_id, high_buy as hbprice7, low_sell as lsprice7, trunc(create_date) as cr7
              FROM PRICE_GUIDE 
             WHERE category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
               AND trunc(create_date) = trunc(sysdate)-7
           ) pg7 ON  l.year             = pg7.year
                 AND l.category_id      = pg7.category_id
                 AND l.subcategory_id   = pg7.subcategory_id
  LEFT OUTER JOIN (
            SELECT year, category_id, subcategory_id, high_buy as hbprice30, low_sell as lsprice30, trunc(create_date) as cr30
              FROM PRICE_GUIDE 
             WHERE category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
               AND trunc(create_date) = trunc(sysdate)-30
           ) pg30 ON  l.year            = pg30.year
                  AND l.category_id     = pg30.category_id
                  AND l.subcategory_id  = pg30.subcategory_id
  LEFT OUTER JOIN (
            SELECT year, category_id, subcategory_id, high_buy as hbprice, low_sell as lsprice, trunc(create_date) as thisyrdate
              FROM PRICE_GUIDE 
             WHERE category_id = 21
               AND subcategory_id = 33178
               AND year = '2017' 
               AND trunc(create_date) = (
                                        SELECT min(trunc(create_date))
                                          FROM PRICE_GUIDE 
                                         WHERE category_id = 21
                                           AND subcategory_id = 33178
                                           AND year = '2017' 
                                           AND to_char(create_date, 'RRRR') = cast(to_char(sysdate, 'RRRR') as varchar(4))
                                      )
           ) pg11 ON  l.year            = pg11.year
                  AND l.category_id     = pg11.category_id
                  AND l.subcategory_id  = pg11.subcategory_id
  LEFT OUTER JOIN (
            SELECT year, category_id, subcategory_id, high_buy as lyhbprice, low_sell as lylsprice, trunc(create_date) as lastyrdate
              FROM PRICE_GUIDE 
             WHERE category_id      = 21
               AND subcategory_id   = 33178
               AND year             = '2017' 
               AND trunc(create_date) = (
                                        SELECT trunc(min(create_date))
                                          FROM PRICE_GUIDE 
                                         WHERE category_id = 21
                                           AND subcategory_id = 33178
                                           AND year = '2017' 
                                           AND to_char(create_date, 'RRRR') = cast(to_char(sysdate, 'RRRR')-1 as varchar(4))
                                      )
           ) pgly ON  l.year             = pgly.year
                  AND l.category_id      = pgly.category_id
                  AND l.subcategory_id   = pgly.subcategory_id
  LEFT OUTER JOIN (
            SELECT year, category_id, subcategory_id, high_buy as hbprice5yr, low_sell as lsprice5yr, trunc(create_date) as date5yr
              FROM PRICE_GUIDE 
             WHERE category_id      = 21
               AND subcategory_id   = 33178
               AND year             = '2017' 
               AND trunc(create_date) = (
                                        SELECT trunc(min(create_date))
                                          FROM PRICE_GUIDE 
                                         WHERE category_id = 21
                                           AND subcategory_id = 33178
                                           AND year = '2017' 
                                           AND to_char(create_date, 'RRRR') = cast(to_char(sysdate, 'RRRR')-5 as varchar(4))
                                      )
           ) pg5yr ON  l.year             = pg5yr.year
                   AND l.category_id      = pg5yr.category_id
                   AND l.subcategory_id   = pg5yr.subcategory_id
  LEFT OUTER JOIN product_review pr on  l.category_id    = pr.cat_id
                                    and l.subcategory_id = pr.subcat_id 
                                    and l.year           = pr.year 
  LEFT OUTER JOIN ( 
             SELECT lst.id, lst.year, lst.category_id, lst.subcategory_id, lst.price as factory_cost
               FROM listings lst 
               JOIN USER_INFO ui   on  ui.id = lst.user_id 
                                   and ui.user_name = 'COST' 
              WHERE lst.category_id      = 21
                AND lst.subcategory_id   = 33178
                AND lst.year             = '2017' 
                AND upper(lst.hobby) = 'Y' 
           ) fc   ON  l.year            = fc.year
                  AND l.category_id     = fc.category_id
                  AND l.subcategory_id  = fc.subcategory_id
  LEFT OUTER JOIN (
            SELECT year, cat_id, subcat_id, nvl(sum(quantity),0) as tquantity,
                   nvl(sum(quantity*(price*1.05)),0) as tSold
              FROM CATEGORY_PRICES
             WHERE cat_id = 21
               AND subcat_id = 33178
               AND year = '2017' 
               AND upper(uom) = 'BOX' 
               AND upper(hobby) = 'Y' 
            GROUP BY year, cat_id, subcat_id              ) tqty ON  l.year          = tqty.year
                    AND l.CATEGORY_id   = tqty.cat_id
                    AND l.subcategory_id = tqty.subcat_id
  LEFT OUTER JOIN (
            SELECT year, cat_id, subcat_id, nvl(sum(quantity),0) as tquantity30,
                   nvl(sum(quantity*(price*1.05)),0) as tSold30
              FROM CATEGORY_PRICES
             WHERE cat_id = 21
               AND subcat_id = 33178
               AND year = '2017' 
               AND upper(uom) = 'BOX' 
               AND upper(hobby) = 'Y' 
               AND trunc(create_date) > trunc(sysdate)-30
            GROUP BY year, cat_id, subcat_id              ) tq30 ON  l.year          = tq30.year
                    AND l.CATEGORY_id   = tq30.cat_id
                    AND l.subcategory_id = tq30.subcat_id
 WHERE l.category_id       = 21
   AND l.subcategory_id    = 33178
   AND l.year              = '2017'
 ORDER BY l.category_desc, l.subcat_name, l.year 
 -->


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<HTML>
<HEAD>
<TITLE>DealerNetB2B.com - Quick Quote</TITLE>
<LINK REL="ICON" HREF="/favicon.ico" type="image/x-icon" />
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css">
<meta name="viewport" content="width=device-width"/>
<LINK REL="stylesheet" TYPE="text/css" HREF="b2b.css"><LINK REL="stylesheet" TYPE="text/css" HREF="print.css" media="print" />



<!-- Search Engine Script DO NOT REMOVE -->
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
function openSS(fname,wid,hig){
 window.open(fname,"downpop","width="+wid+",height="+hig+"+,directories=no,toolbar=no,resizable=yes,menubar=no,scrollbars=yes");
 }

 // -->
</SCRIPT>

<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-27396787-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>

<BASE Target="_parent">
</HEAD>

<BODY STYLE="margin: 0 10px 10px 10px; background-color: #FFF;">
<div class="outer-mobile-div">
  <div class="mid2-mobile-div">
    <A HREF='http://www.dealernetmall.com'><IMG SRC='images/malllogo.jpg' WIDTH='265' HEIGHT='92' BORDER='0' CLASS='logo'></A>
    <div style='clear:both; text-align: center; padding:5px; margin:2px; background-color: #FFF;margin: 0px auto; border:1px solid; border-radius:25px;'>
      <P class="mobile-selector-label" style="font-size:125%;">2017 Leaf Metal Perfect Game All-American Classic Hobby Baseball Box<BR><SPAN STYLE="font-weight:bold;font-size:90%;padding-right:15px;">Current Price:&nbsp;$69.00</SPAN>
<A HREF='login.asp?dsturl=%2Flistings%2Easp%3FSubCategory%5FID%3D33178%26Category%5FID%3D21%26searchstring%3D2017%26sort%3DPrice%26type%3DFor+Sale%26GO%3DYES'><img src='/images/buy-now.png' border='0'></A></P>
      <TABLE CELLSPACING='1' CELLPADDING='2' STYLE='margin:5px;margin-left:auto;margin-right:auto;'>
        <TBODY>
          <TR>
    <TD class="mobile-selector-copy" style="vertical-align:top;padding-right:3px;">
      <div style='float:left;padding-top: 5px;'><img src='thumbnailstream.asp?id=images/listings/7621-1498142.jpg&w=200' border='0'></div>
    </td>
            <TD style='vertical-align:top;'>
              <TABLE CELLSPACING='1' CELLPADDING='2' STYLE='margin:5px;margin-left:auto;margin-right:auto;'>
                <TBODY>
                  <TR>
                    <TD class="mobile-selector-label">Factory Cost:</TD>
                    <TD class="mobile-selector-copy">&nbsp;</TD>
                  </TR>
                  <TR>
                    <TD class="mobile-selector-label">Boxes Sold:</TD>
                    <TD class="mobile-selector-copy">7 (total)</TD>
                  </TR>
                  <TR>
                    <TD class="mobile-selector-copy">&nbsp;</TD>
                    <TD class="mobile-selector-copy">none (last 30 days)</TD>
                  </TR>
                  <TR>
                    <TD class="mobile-selector-label">Average Price:</TD>
                  <TD class="mobile-selector-copy">$50.40 (from initial sale)</TD>
                  </TR>
                  <TR>
                    <TD class="mobile-selector-copy">&nbsp;</TD>
                  <TD class="mobile-selector-copy">none (last 30 days)</TD>
                  </TR>
                  <TR>
                     <TD colspan='2'>&nbsp;</TD>
                  </TR>
                  <TR>
                    <TD class="mobile-selector-label">Historical High:</TD>
                    <TD class="mobile-selector-copy">$68.25&nbsp;&nbsp;&nbsp;(6/8/2018)</TD>
                  </TR>
                  <TR>
                    <TD class="mobile-selector-label">Historical Low:</TD>
                    <TD class="mobile-selector-copy">$63.00&nbsp;&nbsp;&nbsp;(5/24/2018)</TD>
                  </TR>
                </TBODY>
              </TABLE>
            </TD>
          </TR>
        </TBODY>
      </TABLE>
    </div>
    <P><SPAN STYLE="font-weight:bold;">Dealernet Premium Membership</SPAN><br>      Post your own bid and ask offers and let members compete for your business at the best available price.<BR>      Please email us for more details and premium membership options: <a href="mailto:admin@dealernetb2b.com">admin@dealernetb2b.com</a>    </P>
    <P>&nbsp;</P>
    <DIV CLASS="footer">
      <DIV CLASS="bottnav">
        <A HREF="mobilelogin.asp?dsturl=%2Flistings%2Easp%3FSubCategory%5FID%3D33178%26Category%5FID%3D21%26searchstring%3D2017%26sort%3DPrice%26type%3DFor+Sale%26GO%3DYES">Login</A>
        | <A HREF="quickquotecats.asp">Change Sport</A>
        | <A HREF="quickquotesubcats.asp?catid=21">Change Product</A>
      </DIV>
    </DIV>
    <P>&nbsp;</P>
  </div>
</div>

</BODY>
</HTML>


<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3588264-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>