O´Che Shop

ชื่อสมาชิก

รหัสสมาชิก

ลืมรหัสผ่าน

สมัครสมาชิก

• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z
• 0
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• other

วิธีใช้่งาน [?] 

• ร้านค้า

ชื่อสินค้า

ประเภท

วันที่ออก

ราคา

ระดับ

Could Not query: SELECT oche_product_info.id as id, oche_product_info.title as title, oche_product_info.activate as activate, oche_product_info.running_time as running_time, oche_product_info.plot_summary as plot_summary, oche_product_info.release_date as release_date, oche_type_media.name as media, oche_type_product.name as product, oche_type_rate.name as rate, oche_type_region.name as region, oche_type_status.name as status, oche_type_status.name_thai as status_thai, oche_type_vdoformat.name as vdoformat, oche_studio_info.studio_name as studio, oche_supplier_info.supplier_name as supplier, oche_director_info.director_thai_name as director, oche_director_info.director_eng_name as director_eng, oche_product_info.special as special, oche_type_video.name as video, oche_product_price.price1 as price, oche_product_price.price2 as price_normal, oche_product_info.year as year, IF(ROUND(SUM(oche_product_comment.rate)/COUNT(oche_product_comment.id)),ROUND(SUM(oche_product_comment.rate)/COUNT(oche_product_comment.id)),0) AS score FROM oche_product_info LEFT JOIN oche_type_media ON oche_product_info.media = oche_type_media.id LEFT JOIN oche_type_product ON oche_product_info.product = oche_type_product.id LEFT JOIN oche_type_rate ON oche_product_info.rate = oche_type_rate.id LEFT JOIN oche_type_region ON oche_product_info.region = oche_type_region.id LEFT JOIN oche_type_status ON oche_product_info.status = oche_type_status.id LEFT JOIN oche_type_vdoformat ON oche_product_info.vdoformat = oche_type_vdoformat.id LEFT JOIN oche_studio_info ON oche_product_info.studio = oche_studio_info.id LEFT JOIN oche_supplier_info ON oche_product_info.supplier = oche_supplier_info.id LEFT JOIN oche_director_info ON oche_product_info.director = oche_director_info.id LEFT JOIN oche_type_video ON oche_product_info.video = oche_type_video.id LEFT JOIN oche_product_price ON oche_product_info.id = oche_product_price.id LEFT JOIN oche_product_comment ON oche_product_info.id=oche_product_comment.product_id AND oche_product_comment.status = 1 WHERE 1 AND oche_product_info.activate = 1 AND CONVERT(oche_studio_info.studio_name USING tis620) LIKE "%Gegege%" AND CONVERT(oche_studio_info.studio_name USING tis620) LIKE "%no%" AND CONVERT(oche_studio_info.studio_name USING tis620) LIKE "%Kitarô%" AND CONVERT(oche_studio_info.studio_name USING tis620) LIKE "%Film%" AND CONVERT(oche_studio_info.studio_name USING tis620) LIKE "%Partners%" GROUP BY oche_product_info.id ORDER BY oche_product_info.title ASC cause:Illegal mix of collations (tis620_thai_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'