Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "[local]", user "ameyoko", database "ameyoko", SSL off in /home/vps100817857/ameyoko.jp/lib/Common_function.php on line 18
dberror

Warning: pg_exec() expects parameter 1 to be resource, boolean given in /home/vps100817857/ameyoko.jp/lib/Common_function.php on line 23

Warning: pg_errormessage() expects parameter 1 to be resource, string given in /home/vps100817857/ameyoko.jp/lib/Common_function.php on line 25
select m.shop_no,COUNT(*),m.shop_kana,m.shop_name,m.shop_name_e from m_shop as m , r_shop_category as r where shop_name != '' and status = '1' group by m.shop_no,m.shop_name,m.shop_name_e,m.shop_kana order by m.shop_kana,COUNT desc