Warning: pg_exec(): Query failed: ERROR: syntax error at or near "group" at character 483 in /usr/home/z109146/html/cgi-bin/a-avenue/include/function.inc on line 155
SQLエラーです。
SELECT tbl_dsp_item.itemncd, mst_item.ncd, mst_item.name, mst_item.gazou, mst_item.syoumoukbn, mst_item.hanbai, mst_item.tokubaikbn, mst_item.tokubai, mst_item.stokubaikbn, mst_item.stokubai, mst_item.explan, mst_item.makerncd, mst_item.upday, mst_maker.name as m_name FROM (tbl_dsp_item INNER JOIN mst_item ON tbl_dsp_item.itemncd = mst_item.ncd) INNER JOIN mst_maker ON mst_item.makerncd = mst_maker.ncd WHERE tbl_dsp_item.largenkd IN(1,2,3,4,9) AND group by tbl_dsp_item.itemncd, mst_item.ncd, mst_item.name, mst_item.tokubaikbn, mst_item.stokubaikbn, mst_item.gazou, mst_item.syoumoukbn, mst_item.hanbai, mst_item.tokubai, mst_item.stokubai, mst_item.explan, mst_item.makerncd, mst_item.upday, m_name order by mst_item.name limit 20 offset 0;