Unknown column 'ii.画像パス' in 'field list'
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 `発売日` BETWEEN '2019-03-11' and '2019-03-17' and `最終更新` < 1560625736 ORDER BY `発売日` ASC , `中分類` ASC LIMIT 80 , 40