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 `中分類`='0003アニメ' AND `商品名` not like '◆%' AND `小分類`!='0005DVDPG' AND `小分類` != '0999全巻セット' AND `発売日` BETWEEN '2019-01-07' and '2019-01-13' and `最終更新` < 1566260519 ORDER BY `発売日` ASC , `中分類` ASC LIMIT 360 , 40