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 (category = LIXIL(�T���E�G�[�u) ���ւ��L) AND (maker = 18) AND (title LIKE '%%' OR title LIKE '%%' OR content LIKE '%%' OR content LIKE '%%' OR content LIKE '%%' OR content LIKE '%%' OR content2 LIKE '%%' OR content2 LIKE '%%' OR content2 LIKE '%%' OR content2 LIKE '%%' OR comment1 LIKE '%%' OR comment1 LIKE '%%' OR comment2 LIKE '%%' OR comment2 LIKE '%%' OR comment3 LIKE '%%' OR comment3 LIKE '%%' OR page4 LIKE '%%' OR page4 LIKE '%%' OR page5 LIKE '%%' OR page5 LIKE '%%' OR product_code LIKE '%%' OR REPLACE(title ,'-','') LIKE '%%' OR REPLACE(content ,'-','') LIKE '%%' OR REPLACE(product_code ,'-','') LIKE '%%' OR photo_folder LIKE '%%' OR maker = '49' OR maker = '320' OR maker = '318' OR maker = '18' OR maker = '19' OR maker = '20' OR maker = '21' OR maker = '23' OR maker = '319' OR maker = '43' OR maker = '5004' OR maker = '40' OR maker = '316' OR maker = '33' OR maker = '34' OR maker = '44' OR maker = '315' OR maker = '4031' OR maker = '50' OR maker = '51' OR maker = '416' OR maker = '314' OR maker = '54' OR maker = '323' OR maker = '60' OR maker = '61' OR maker = '62' OR maker = '63' OR maker = '64' OR maker = '94' OR maker = '351' OR maker = '285' OR maker = '420' OR maker = '69' OR maker = '355' OR maker = '78' OR maker = '74' OR maker = '75' OR maker = '77' OR maker = '79' OR maker = '80' OR maker = '81' OR maker = '82' OR maker = '335' OR maker = '85' OR maker = '369' OR maker = '87' OR maker = '88' OR maker = '89' OR maker = '140' OR maker = '288' OR maker = '93' OR maker = '399' OR maker = '98' OR maker = '4033' OR maker = '100' OR maker = '102' OR maker = '106' OR maker = '380' OR maker = '417' OR maker = '381' OR maker = '379' OR maker = '144' OR maker = '294' OR maker = '128' OR maker = '129' OR maker = '130' OR maker = '424' OR maker = '132' OR maker = '133' OR maker = '134' OR maker = '305' OR maker = '237' OR maker = '238' OR maker = '357' OR maker = '246' OR maker = '247' OR maker = '251' OR maker = '252' OR maker = '253' OR maker = '255' OR maker = '257' OR maker = '281' OR maker = '276' OR maker = '278' OR maker = '360' OR maker = '346' OR maker = '4032' OR maker = '289' OR maker = '297' OR maker = '298' OR maker = '299' OR maker = '302' OR maker = '405' OR maker = '304' OR maker = '306' OR maker = '310' OR maker = '418' OR maker = '333' OR maker = '370' OR maker = '372' OR maker = '345' OR maker = '326' OR maker = '327' OR maker = '328' OR maker = '329' OR maker = '425' OR maker = '5007' OR maker = '371' OR maker = '343' OR maker = '2001' OR maker = '5002' OR maker = '2003' OR maker = '2007' OR maker = '2008' OR maker = '350' OR maker = '361' OR maker = '2019' OR maker = '353' OR maker = '358' OR maker = '5001' OR maker = '354' OR maker = '359' OR maker = '4028' OR maker = '4029' OR maker = '4001' OR maker = '4002' OR maker = '427' OR maker = '4005' OR maker = '4006' OR maker = '4007' OR maker = '426' OR maker = '4013' OR maker = '4014' OR maker = '4016' OR maker = '404' OR maker = '4018' OR maker = '4019' OR maker = '4020' OR maker = '406' OR maker = '4022' OR maker = '407' OR maker = '2029' OR maker = '356' OR maker = '4030' OR maker = '4024' OR maker = '4026' OR maker = '4027' OR maker = '403' OR maker = '5005' OR maker = '91' OR maker = '376' OR maker = '421' OR maker = '382' OR maker = '383' OR maker = '384' OR maker = '385' OR maker = '386' OR maker = '388' OR maker = '389' OR maker = '390' OR maker = '391' OR maker = '5003' OR maker = '362' OR maker = '393' OR maker = '394' OR maker = '396' OR maker = '395' OR maker = '397' OR maker = '398' OR maker = '9999' OR maker = '400' OR maker = '402' OR maker = '415' OR maker = '5006' OR maker = '408' OR maker = '409' OR maker = '412' OR maker = '413' OR maker = '414' ) AND (website != 'catalog') ORDER BY page10,price ASC :