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 (1295038,27102569,27624665,4014397,26667275,27135563,35154007,35159839,35152567,34942979,35158341,30401849,35160280,26754233,26985839,34892990,34840497,34852457,30376835,26348103,30170833,26661193,30353078,3541415,30327897,24325829,33425206,34927945,34953936,30444960,33459184,34801105,27013048,35162724,30486641,35162723,27131969,35051512,34922185,34842226,30262631,35154209,30171424,26826330,35125443) order by FIELD(doubanid, 1295038,27102569,27624665,4014397,26667275,27135563,35154007,35159839,35152567,34942979,35158341,30401849,35160280,26754233,26985839,34892990,34840497,34852457,30376835,26348103,30170833,26661193,30353078,3541415,30327897,24325829,33425206,34927945,34953936,30444960,33459184,34801105,27013048,35162724,30486641,35162723,27131969,35051512,34922185,34842226,30262631,35154209,30171424,26826330,35125443) limit 0, 12SELECT id,cname, ename, dbrate, mpicurl, pubtime, lastshowid FROM `ygp_movie` WHERE doubanid in (34888476,34462775,30216114,26871906,26969541,33446524,33428622,30212622,30145117,35088569,26705567,30482645,35027709,32591373,30271841,30166972,33379493,25887288,30318116,35161256) order by FIELD(doubanid, 34888476,34462775,30216114,26871906,26969541,33446524,33428622,30212622,30145117,35088569,26705567,30482645,35027709,32591373,30271841,30166972,33379493,25887288,30318116,35161256) 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