Unknown column 'ii.画像パス' in 'field list'<br>
SELECT i.`JAN`, ii.`JAN` as `FLAG`, ii.`画像パス` as `THM_FLAG` ,unix_timestamp(ii.`最終更新`) as `最終更新` FROM itemdata as i left join amazondata as ii on i.`JAN`=ii.`JAN` WHERE  (`中分類`='0001洋画' OR `中分類`='0002邦画' OR `中分類`='0004アラカルト') AND `商品名` not like '◆%' AND `小分類`!='0005DVDPG' AND `小分類` != '0999全巻セット'   and `最終更新` < 1560626486 ORDER BY `発売日` ASC , `中分類` ASC LIMIT 0 , 40