SELECT count( DISTINCT SHOP_MST.SHOP_ID ) as cnt FROM `SHOP_MST` LEFT JOIN SHOP_SUB_AREA_MST ON SHOP_MST.SHOP_ID = SHOP_SUB_AREA_MST.SHOP_ID LEFT JOIN SHOP_BUSINESS_MST ON SHOP_MST.SHOP_ID = SHOP_BUSINESS_MST.SHOP_ID WHERE SHOP_SUB_AREA_MST.SUB_AREA = AND SHOP_MST.OPEN != 1 AND SHOP_MST.DELETE_DATE IS NULL AND SHOP_SUB_AREA_MST.DELETE_DATE IS NULL AND SHOP_MST.TYPE = 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND SHOP_MST.OPEN != 1 AND SHOP_MST.DELETE_DATE IS NULL AND ' at line 14 SELECT DISTINCT SHOP_MST.SHOP_ID, SHOP_MST.* FROM `SHOP_MST` LEFT JOIN `SHOP_SUB_AREA_MST` ON SHOP_MST.SHOP_ID = SHOP_SUB_AREA_MST.SHOP_ID LEFT JOIN `SHOP_BUSINESS_MST` ON SHOP_MST.SHOP_ID = SHOP_BUSINESS_MST.SHOP_ID LEFT JOIN `SHOP_JOB_MST` ON SHOP_MST.SHOP_ID = SHOP_JOB_MST.SHOP_ID LEFT JOIN `SUB_AREA_MST` ON SHOP_SUB_AREA_MST.SUB_AREA = SUB_AREA_MST.SUB_AREA_ID LEFT JOIN `MAIN_AREA_MST` ON SUB_AREA_MST.PARENT_ID = MAIN_AREA_MST.ID WHERE SHOP_MST.DELETE_DATE IS NULL AND SHOP_SUB_AREA_MST.DELETE_DATE IS NULL AND SHOP_BUSINESS_MST.DELETE_DATE IS NULL AND SHOP_JOB_MST.DELETE_DATE IS NULL AND SHOP_MST.OPEN != 1 AND SHOP_MST.TYPE = 1 AND SHOP_SUB_AREA_MST.SUB_AREA = ORDER BY SHOP_MST.REGIST_DATE DESC, SHOP_MST.RANK IS NULL, SHOP_MST.RANK ASC LIMIT 0, 20
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY SHOP_MST.REGIST_DATE DESC, SHOP_MST.RANK IS NULL, SHOP_M' at line 28SELECT * FROM SUB_AREA_MST WHERE DELETE_DATE IS NULL AND SUB_AREA_ID = ORDER BY SUB_AREA_ID ASC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY SUB_AREA_ID ASC' at line 1 |エリア検索|高収入男性求人情報サイト|リクポケ

高収入求人・高収入男性アルバイト情報ならリクポケ!!
高収入女性求人リクポケガールズはコチラ

エリア検索

新宿(46)
池袋(33)
渋谷(47)
五反田・品川(66)
上野・鴬谷(39)
大塚・日暮里(24)
錦糸町・小岩(33)
立川・町田(13)
その他・23区外(5)
神奈川県(63)
埼玉県(22)
千葉県(25)
茨城県(4)
北海道・東北(21)
東海(1)
関西(4)
九州・沖縄(30)

業種から探す

職種から探す

高収入男性求人情報リクポケ|から探す|
全件| 1/0ページ| 1〜件表示

全件|1/0ページ|1〜件表示 次へ

PAGE TOP