SELECT * FROM `ygp_movieset` where name = 'laterdbids' or name = 'doubanhot' limit 2SELECT id,cname, ename, dbrate, mpicurl, pubtime, lastshowid FROM `ygp_movie` WHERE doubanid in (27619748,30306570,25907124,30128916,26342391,27195078,34768418,34825886,33457717,20469905,26371812,33437509,33459184,30170546,26348103,26871465,30274965,30170833,26661193,34434006,27131218,34892990,27000981,34670218,34834769,27202818,30389258,27131969,27624665,34822531,27203005,27121248,34922185,34933879,30216731,30378158,30464542,33973077,34839328,26826330) order by FIELD(doubanid, 27619748,30306570,25907124,30128916,26342391,27195078,34768418,34825886,33457717,20469905,26371812,33437509,33459184,30170546,26348103,26871465,30274965,30170833,26661193,34434006,27131218,34892990,27000981,34670218,34834769,27202818,30389258,27131969,27624665,34822531,27203005,27121248,34922185,34933879,30216731,30378158,30464542,33973077,34839328,26826330) limit 0, 12SELECT id,cname, ename, dbrate, mpicurl, pubtime, lastshowid FROM `ygp_movie` WHERE doubanid in (30327842,27119724,30150661,27202818,30394535,6981153,30318116,30170546,6538866,30166972,27010768,30299311,27087724,3097572,30257175,30362186,33400376,30271841,32659890,30295905) order by FIELD(doubanid, 30327842,27119724,30150661,27202818,30394535,6981153,30318116,30170546,6538866,30166972,27010768,30299311,27087724,3097572,30257175,30362186,33400376,30271841,32659890,30295905) limit 0, 12SELECT id,cname, ename, mpicurl, dbrate, pubtime, lastshowid FROM `ygp_movie` WHERE ticketlink >= 1 order by ticketlink asc limit 0, 12SELECT id,cname, ename, mpicurl, dbrate, pubtime, lastshowid FROM `ygp_movie` WHERE trailernum >= 1 order by updatetime desc limit 0, 12