bdm256642228_db

select ca.goodsid,ca.photopath,ca.url from cy_adproperty as ca 
  where pid=1 and subid=2 order by indexid asc

bdm256642228_db

bdm256642228_db

bdm256642228_db

select type from cy_goodstype where typeid=8

select typeid,type from cy_goodstype where categoryTypeid=8

select goodsid,goodsname,goodsdescription,goodsprice,goodsnewprice from cy_goods where goodstypeid=8

select goodsid,goodsname,goodsdescription,goodsprice,goodsnewprice from cy_goods where goodstypeid=8

select goodsid,goodsname,goodsdescription,goodsprice,goodsnewprice from cy_goods where goodstypeid=8 order by goodsid desc limit 0,8

bdm256642228_db

select cy_goods.goodsid,cy_goods.goodsname,cy_goods.goodsdescription,cy_goods.goodsprice,cy_goods.goodsnewprice,
	        			cy_photo.photopath
						from cy_goods,cy_photo,cy_gphoto
						where cy_goods.goodsid = cy_gphoto.goodsid
						and cy_photo.photoid = cy_gphoto.photoid
						and cy_goods.goodstypeid = '1'
						and cy_photo.photoid in (select cy_photo.photoid from cy_goods,cy_photo,cy_gphoto where
											cy_goods.goodsid = cy_gphoto.goodsid
                                            and cy_photo.photoid = cy_gphoto.photoid
                                            group by cy_goods.goodsid);