Untitled

SELECT  AVG(xaxis) AS AVG ,
        MIN(xaxis) AS MIN ,
        MAX(xaxis) AS MAX ,
        DAY               ,
        xaxis
FROM
        (SELECT ((item.selling_price - sellingAVG) / sellingStdDev) AS Z  ,
                DATE(item.end_time)                    AS DAY,
                item.selling_price                     AS xaxis
        FROM    item
                LEFT JOIN (extID)
                ON (item.item_id=extID.item_id)
                LEFT JOIN (categoryToIDMap)
                ON (item.primary_category=categoryToIDMap.category_id) ,
                        (







                        SELECT stddev(item.selling_price) AS sellingStdDev   ,
                                AVG(item.selling_price)    AS sellingAVG,
                                stddev(item.listing_price) AS listingStdDev, 
                                avg(item.listing_price)    AS listingAVG 
                        FROM    item
                                LEFT JOIN (extID)
                                ON (item.item_id=extID.item_id)
                                LEFT JOIN (categoryToIDMap)
                                ON (item.primary_category=categoryToIDMap.category_id)
                        WHERE   item.title LIKE '%Nintendo Wii%'
                            AND TO_DAYS(NOW())-TO_DAYS(item.end_time) <= 30
                            AND (categoryToIDMap.category_name         ='Video Games'
                             OR categoryToIDMap.category_name          ='Games'
                             OR categoryToIDMap.category_name          ='Hardware')
                  UNION
                        SELECT stddev(item.selling_price) AS sellingStdDev   ,
                                AVG(item.selling_price)    AS sellingAVG,
                                stddev(item.listing_price) AS listingStdDev, 
                                avg(item.listing_price)    AS listingAVG 
                        FROM    item
                                LEFT JOIN (extID)
                                ON (item.item_id=extID.item_id)
                                LEFT JOIN (categoryToIDMap)
                                ON (item.primary_category=categoryToIDMap.category_id)
                        WHERE   item.title LIKE '%Nintendo Wii%'
                            AND TO_DAYS(NOW())-TO_DAYS(item.end_time) <= 30
                            AND item.selling_price = item.buy_it_now_price
                            AND (categoryToIDMap.category_name         ='Video Games'
                             OR categoryToIDMap.category_name          ='Games'
                             OR categoryToIDMap.category_name          ='Hardware')
                   UNION
                        SELECT stddev(item.selling_price) AS sellingStdDev   ,
                                AVG(item.selling_price)    AS sellingAVG,
                                stddev(item.listing_price) AS listingStdDev, 
                                avg(item.listing_price)    AS listingAVG 
                        FROM    item
                                LEFT JOIN (extID)
                                ON (item.item_id=extID.item_id)
                                LEFT JOIN (categoryToIDMap)
                                ON (item.primary_category=categoryToIDMap.category_id)
                        WHERE   item.title LIKE '%Nintendo Wii%'
                            AND TO_DAYS(NOW())-TO_DAYS(item.end_time) <= 30
                            AND item.selling_price != item.buy_it_now_price
                            AND (categoryToIDMap.category_name         ='Video Games'
                             OR categoryToIDMap.category_name          ='Games'
                             OR categoryToIDMap.category_name          ='Hardware')









                        ) AS woot
        WHERE   TO_DAYS(NOW())-TO_DAYS(item.end_time) <= 30
            AND item.title LIKE '%Nintendo Wii%'
            AND (categoryToIDMap.category_name='Video Games'
             OR categoryToIDMap.category_name ='Games'
             OR categoryToIDMap.category_name ='Hardware')
        ) AS stuff
WHERE (Z  > -1.65
    AND Z < 1.65)
GROUP BY (DAY)