select cy_photo.photopath,yw_scenicphoto.recommendation,yw_scenic.id
            from yw_scenic,yw_scenicphoto,cy_photo
            where yw_scenic.cityid=yw_scenicphoto.cityid
            AND yw_scenic.cityid=
            AND yw_scenicphoto.photoid=cy_photo.photoid
            AND yw_scenic.id=yw_scenicphoto.scenicid
            AND yw_scenicphoto.undercarriage=1
            AND yw_scenicphoto.precommendation=6
            order by yw_scenicphoto.recommendation
            limit 0,4

select cy_photo.photopath,yw_scenic.viewname,yw_scenic.id
            from cy_photo,yw_scenic,yw_scenicphoto
            where yw_scenicphoto.cityid=
            AND yw_scenic.id=yw_scenicphoto.scenicid
            AND yw_scenicphoto.photoid=cy_photo.photoid
            AND yw_scenicphoto.precommendation=3
            AND yw_scenicphoto.undercarriage=1
            order by yw_scenicphoto.recommendation ASC
            limit 0,14;