Error [select HIGH_PRIORITY a.oan,a.fid,a.rid,a.allbuy,a.itemID,a.sritemID,a.searchid,a.item_name,a.addit_name,a.brand,a.b_price,a.sell_price,a.sell_price_super,a.sell_price_rent,a.section,a.btype,a.time_price,a.dis_price,a.mileage_price,a.titem_write_rate,a.oyear,a.byear,a.holdnum,a.pid,a.pno,a.pnick,a.inum,a.giftID,a.item_age,a.sellnum,a.rdirname,a.lrfile1,a.sfile,u.d_cost,u.d_cost_limit,u.credit,s.sopen_fid,s.hcode,s.b_auth,s.compare_cnt from nlkb_itemDB a left join nlkb_sritemDB_isbn_avg s on a.sritemID=s.sritemID left join users_addinfo u on a.pno=u.num where a.edate>'2024-04-16 13:40:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'RANDOMHOUSEINC%' or a.brand in ('RANDOM HOUSE','Scholastic Inc','Arrow/Children S (a Division of Random House','Artech House','August House Pub Inc','Authorhouse','Baikaltai House','Award Pub Inc','B*Tween Productions Inc','Jan BerenstainRandom House Childrens Books','John Wiley & Sons Inc','Jossey-Bass Inc Pub','Laurel SnyderRandom House Childrens Books','Learning English HOUSE','Lampo Group Inc','Langenscheidt Pub Inc','Learning Horizons, Incorporated','Penguin Random House Grupo USA','Parragon Inc','Parragon, Incorporated','Pedestal Publishing, Inc.','Penguin Group (USA) Incorporated','Penton Overseas Inc','Penton Overseas Inc. Distributed by Ideals Publications','Random','Random House (UK)','Random House Audio','Random House Books for Young Rea','Random House Books for Young Readers','Random House Business Books','Random House Canada','Random House Children's Books','Random House Children's Books |','Random House Children's Publishers UK','Random House Childrens Books','Random House Childrens Publishers UK','Random House Disney','Random House Distribution childrens','Random House Inc','Random House Large Print','Random House Spanish','Random House SpanishP. D. Eastman','Random House USA Inc','Random House, Inc.','RandomHouse','Raincoast Book Dist Ltd','Reader's Digest Young Families, Inc.','Regnery Publishing, Inc.','Stan BerenstainRandom House Childrens Books','Somerville House USA','Snowbound Press, Inc.','Sourcebooks Inc')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30]