bdm256642228_db

select * from cy_goods where showtype =2 and goodsid=3

select *
            from wai_good where gid =3

select * from cy_photo,cy_gphoto
                where cy_gphoto.goodsid=3
                AND cy_gphoto.photoid=cy_photo.photoid
                 and cy_gphoto.photouseid=1
                

select * from cy_photo,cy_gphoto
                where cy_gphoto.goodsid=3
                AND cy_gphoto.photoid=cy_photo.photoid
                 and cy_gphoto.photouseid=0
                

select count(gdiscuss) from cy_gdiscuss where goodsid=3

select a.gdiscuss,a.gdiscussgrade,b.username,c.ordernum from cy_gdiscuss as a
    left join cy_user as b on a.userid=b.userid
    left join cy_order as c on a.orderid=c.orderid
    where a.goodsid=3 ORDER BY a.gdiscusstime DESC limit 0,10

select count(gdiscuss) from cy_gdiscuss where gdiscussgrade>3 and goodsid=3

select gdiscuss,gdiscussgrade,username,ordernum from cy_gdiscuss
    left join cy_user on cy_gdiscuss.userid=cy_user.userid
    left join cy_order on cy_gdiscuss.orderid=cy_order.orderid
    where cy_gdiscuss.goodsid=3 and cy_gdiscuss.gdiscussgrade>3 order by cy_gdiscuss.gdiscusstime DESC limit 0,10

select count(gdiscuss) from cy_gdiscuss where gdiscussgrade=3 and goodsid=3

select gdiscuss,gdiscussgrade,username,ordernum from cy_gdiscuss
    left join cy_user on cy_gdiscuss.userid=cy_user.userid
    left join cy_order on cy_gdiscuss.orderid=cy_order.orderid
    where cy_gdiscuss.goodsid=3 and cy_gdiscuss.gdiscussgrade=3 order by cy_gdiscuss.gdiscusstime DESC limit 0,10

select count(gdiscuss) from cy_gdiscuss where gdiscussgrade<3 and goodsid=3

select gdiscuss,gdiscussgrade,username,ordernum from cy_gdiscuss
    left join cy_user on cy_gdiscuss.userid=cy_user.userid
    left join cy_order on cy_gdiscuss.orderid=cy_order.orderid
    where cy_gdiscuss.goodsid=3 and cy_gdiscuss.gdiscussgrade<3 order by cy_gdiscuss.gdiscusstime DESC limit 0,10