こちらのsql文の間違いをお分かりの方はご教示いただけると幸いです。
以下のエラーメッセージが出てしまいます。
引用テキストMySQL のメッセージ: ドキュメント
1064 - SQL構文エラーです。バージョンに対応するマニュアルを参照して正しい構文を確認してください。 : '"" LIMIT 0, 30' 付近 1 行目
SELECT main.userId AS mainUser, main.projectId AS id, p.biddingDeadline, COUNT(ps.projectId) AS points, GROUP_CONCAT( DISTINCT s.skillName) AS skills, p.title, p.`categoryId`,c.slug AS cslug,c.`cateName` AS cateName, p.`subcategoryId`,sc.slug AS scslug,sc.`cateName` AS subCateName,IFNULL(AVG(b.`price`), 0) AS averageBid, IFNULL(AVG(b.`duration`), 0) AS averageETA, COUNT(b.id) AS bids, p.userId, p.createdDate, p.slug, p.`description`, p.budget AS budget, p.`isFeatured`, p.`slug`, u.`profileLink`, u.`profilePhoto`, CONCAT_WS(' ', u.firstName, u.lastName) AS fullName FROM (SELECT u.userId, p.projectId FROM (SELECT DISTINCT projectId FROM tbl_project_skills) p CROSS JOIN (SELECT DISTINCT userId FROM tbl_user_skills) u) main LEFT JOIN tbl_user_skills us ON us.userId = main.userId LEFT JOIN tbl_project_skills ps ON main.projectId = ps.projectId LEFT JOIN tbl_skills AS s ON ps.`skillId` = s.`id` AND s.`status` = 'a' LEFT JOIN tbl_projects AS p ON main.projectId = p.id LEFT JOIN tbl_users AS u ON p.userId = u.userId LEFT JOIN tbl_bids AS b ON main.projectId = b.`projectId` AND b.`isFinal` = 'y' AND b.`isNulled` = 'n' LEFT JOIN tbl_categories AS c ON p.categoryid = c.id AND c.`isactive` = 'y' LEFT OUTER JOIN tbl_categories AS sc ON p.subcategoryid = sc.id AND sc.`isactive` = 'y' WHERE p.`isActive` = 'y' AND u.`isActive` = 'y' AND (p.`jobStatus` = 'open' or p.`jobStatus` = 'reopened') "";
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2017/10/13 00:56