SELECT
SUB_AREA_MST.SUB_AREA_ID,
SUB_AREA_MST.SUB_AREA_NAME
FROM
`SHOP_SUB_AREA_MST`
LEFT JOIN
SHOP_MST
ON
SHOP_SUB_AREA_MST.SHOP_ID = SHOP_MST.SHOP_ID
LEFT JOIN
SUB_AREA_MST
ON
SHOP_SUB_AREA_MST.SUB_AREA = SUB_AREA_MST.SUB_AREA_ID
LEFT JOIN
SHOP_BUSINESS_MST
ON
SHOP_MST.SHOP_ID = SHOP_BUSINESS_MST.SHOP_ID
WHERE
SHOP_MST.DELETE_DATE IS NULL
AND
SHOP_MST.TYPE = 2
AND SHOP_BUSINESS_MST.BUSINESS_ID = Array
AND
SHOP_SUB_AREA_MST.DELETE_DATE IS NULL
GROUP BY
SUB_AREA_MST.SUB_AREA_ID
Unknown column 'Array' in 'where clause'
SELECT count( DISTINCT SHOP_MST.SHOP_ID ) as cnt
FROM
`SHOP_MST`
LEFT JOIN
SHOP_BUSINESS_MST
ON
SHOP_MST.SHOP_ID = SHOP_BUSINESS_MST.SHOP_ID
LEFT JOIN
SHOP_SUB_AREA_MST
ON
SHOP_MST.SHOP_ID = SHOP_SUB_AREA_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_BUSINESS_MST.BUSINESS_ID = Array
AND
SHOP_MST.OPEN != 1
AND
SHOP_MST.DELETE_DATE IS NULL
AND
SHOP_BUSINESS_MST.DELETE_DATE IS NULL
AND
SHOP_MST.TYPE = 2
GROUP BY
SHOP_BUSINESS_MST.BUSINESS_ID
Unknown column 'Array' in 'where clause'
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 = 2
AND SHOP_BUSINESS_MST.BUSINESS_ID = Array
ORDER BY
SHOP_MST.REGIST_DATE DESC,
SHOP_MST.RANK IS NULL,
SHOP_MST.RANK ASC
LIMIT 0, 20 Unknown column 'Array' in 'where clause'SELECT NAME FROM BUSINESS_MST WHERE DELETE_DATE IS NULL AND ID = Array ORDER BY ID ASC Unknown column 'Array' in 'where clause'
|業種検索|高収入女性求人情報サイト|リクポケガールズ