SELECT id,product_code,title,content,content2,teika,price,price2,photo,photo2,photo3,photo4,website,category,upload_id,maker,photo_folder,comment1,comment2,comment3,catalog,page,page2,page3,page4,page5,page6,page7,page8,page9,page10,shipping,points,furikomi,card,daibiki,loan,jikanshitei,REPLACE(content ,'-','') AS content_sub,REPLACE(title ,'-','') AS title2,REPLACE(product_code ,'-','') AS product_code2 FROM products WHERE (title LIKE '%none%' OR title LIKE '%%' OR content LIKE '%none%' OR content LIKE '%%' OR content LIKE '%none%' OR content LIKE '%%' OR content2 LIKE '%none%' OR content2 LIKE '%%' OR content2 LIKE '%none%' OR content2 LIKE '%%' OR comment1 LIKE '%none%' OR comment1 LIKE '%%' OR comment2 LIKE '%none%' OR comment2 LIKE '%%' OR comment3 LIKE '%none%' OR comment3 LIKE '%%' OR page4 LIKE '%none%' OR page4 LIKE '%%' OR page5 LIKE '%none%' OR page5 LIKE '%%' OR product_code LIKE '%none%' OR REPLACE(title ,'-','') LIKE '%none%' OR REPLACE(content ,'-','') LIKE '%none%' OR REPLACE(product_code ,'-','') LIKE '%none%' OR photo_folder LIKE '%none%' ) AND (website != 'catalog') AND (website != 'tokka') ORDER BY title DESC4 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC4 LIMIT 400, 50' at line 26