Repairing table C:\DOCUME~1\mysqld\LOCALS~1\Temp\#sql_5cc_0...1 : Can't create/write to file 'C:\DOCUME~1\mysqld\LOCALS~1\Temp\#sql_5cc_0.MYD' (Errcode: 17) INVALID SQL: 1064 : 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 ':\DOCUME~1\mysqld\LOCALS~1\Temp\#sql_5cc_0 EXTENDED' at line 1 SQL QUERY FAILURE:SELECT jknr_manufacturers.*, IFNULL(jknr_manufacturers_lng.manufacturer, jknr_manufacturers.manufacturer) as manufacturer, IFNULL(jknr_manufacturers_lng.descr, jknr_manufacturers.descr) as descr FROM jknr_manufacturers USE INDEX (avail) LEFT JOIN jknr_manufacturers_lng ON jknr_manufacturers.manufacturerid = jknr_manufacturers_lng.manufacturerid AND jknr_manufacturers_lng.code = 'CN' WHERE avail = 'Y' ORDER BY orderby, manufacturer LIMIT 10 Repairing table C:\DOCUME~1\mysqld\LOCALS~1\Temp\#sql_5cc_0...1 : Can't create/write to file 'C:\DOCUME~1\mysqld\LOCALS~1\Temp\#sql_5cc_0.MYD' (Errcode: 17) INVALID SQL: 1064 : 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 ':\DOCUME~1\mysqld\LOCALS~1\Temp\#sql_5cc_0 EXTENDED' at line 1 SQL QUERY FAILURE:SELECT
IF (L1.value IS NOT NULL, L1.value,
IF (L2.value IS NOT NULL, L2.value, L3.value)
) AS country,
jknr_countries.code as country_code,
jknr_countries.display_states,
jknr_countries.region
FROM
jknr_countries
LEFT JOIN jknr_languages L1 ON
L1.name = CONCAT('country_',jknr_countries.code)
AND
L1.code = 'CN'
LEFT JOIN jknr_languages L2 ON
L2.name = CONCAT('country_',jknr_countries.code)
AND
L2.code = 'CN'
LEFT JOIN jknr_languages L3 ON
L3.name = CONCAT('country_',jknr_countries.code)
AND
L3.code = 'CN'
WHERE
jknr_countries.active='Y'
ORDER BY country 礼券 :: 健康女人(jknr.com)保健品，化妆品,护肤,香水,彩妆,美体塑身,个人护理,男士护肤,解酒茶|防辐射服|防辐射茶|抗辐射服|抗辐射茶|保健品免费体验,减肥产品,健康食品
