SELECT
arch.id,
arch.title,
arch.litpic,
arch.description,
arch.click,
arch.writer,
arch.pubdate,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
FROM
dede_archives AS arch LEFT JOIN `#@__arctype` tp on arch.typeid=tp.id
WHERE arch.id<2000 and
`arcrank` !=- 2
AND `arcrank` = 0
ORDER BY
arch.title LIKE "%实验小学60寸智慧黑板云教室建设系统%" DESC,arch.title LIKE "%智慧黑板%"DESC ,arch.title LIKE "%云教室%"DESC ,arch.title LIKE "%实验%"DESC ,arch.title LIKE "%小学%"DESC ,arch.title LIKE "%智慧%"DESC ,arch.title LIKE "%黑板%"DESC ,arch.title LIKE "%教室%"DESC ,arch.title LIKE "%建设%"DESC ,arch.title LIKE "%系统%"DESC ,arch.title LIKE "%60寸%"DESC limit 0,10