สืบค้นที่ไหนดี
ประเภทวัสดุ
    SELECT *, media_type.id as mid, media_type.name as mname FROM media_type inner join media_mid on media_type.code = media_mid.RESOURCE_TYPE inner join media on media_mid.pid = media.ID inner join media_place on media_place.code = media_mid.place inner join index_db on index_db.mid = media.id WHERE kw LIKE "%เธกเธซเธฒเธงเธดเธ—เธขเธฒเธฅเธฑเธขเธกเธซเธดเธ”เธฅ. เธชเธ–เธฒเธ�เธฑเธ�เธงเธดเธ�เธฑเธขเธ�เธฃเธฐเธ�เธฒเธ�เธฃเน�เธฅเธฐเธชเธฑเธ�เธ�เธก. เน�เธ�เธฃเธ�เธ�เธฒเธฃเธงเธดเธ�เธฑเธขเน€เธ�เธทเน�เธญเธ�เธฑเธ’เธ�เธฒเธฃเธฐเธ�เธ�เธ�เธฃเธดเธ�เธฒเธฃเน�เธฅเธฐเธชเน�เธ�เน€เธชเธฃเธดเธกเธชเธธเธ�เธ เธฒเธ�เน�เธ�เน€เธฃเธทเธญเธ�เธ�เธณ%" and media_type.media_type_side_bar_search = 'yes' group by media_type.id order by media_type.media_type_sort asc