symfony PHPフレームワークpart2 (531ﾚｽ)

symfony PHPフレームワークpart2 http://medaka.5ch.net/test/read.cgi/php/1268753684/

上下前次1-新
通常表示 512ﾊﾞｲﾄ分割 ﾚｽ栞
抽出解除 必死ﾁｪｯｶｰ(本家) (べ) 自ID ﾚｽ栞 あぼーん

---

ﾘﾛｰﾄﾞ規制です｡10分ほどで解除するので､他のﾌﾞﾗｳｻﾞへ避難してください｡

---

260: nobodyさん [] 2010/11/15(月) 21:25:47 ID:WH+q5o59 こうゆう複雑なSQLはDoctrineでできますか？ Doctrineは単純なSQLだけで、複雑な合成はPHPでやったほうがいいのかな。 SELECT u.id as u__id, u.username as u__username, s.date as s__date, a.access as a__access, s.sales as s__sales FROM sf_guard_user u LEFT OUTER JOIN (SELECT user_id, DATE(created_at) AS date, SUM(amount) AS sales FROM sales GROUP BY user_id, DATE(created_at)) s ON u.username = s.user_id LEFT OUTER JOIN (SELECT user_id, DATE(created_at) AS date, count(*) AS access FROM access_log GROUP BY user_id, DATE(created_at)) a ON u.username = a.user_id AND s.date = a.date WHERE u.username = 'admin' AND s.date > '2010-11-01 00:00:00' AND s.date < '2010-12-01 00:00:00' ORDER BY s.date; http://medaka.5ch.net/test/read.cgi/php/1268753684/260

---

ﾒﾓ帳

(0/65535文字)

---

上下前次1-新書関写板覧索設栞歴

---

ｽﾚ情報 赤ﾚｽ抽出 画像ﾚｽ抽出 歴の未読ｽﾚ AAｻﾑﾈｲﾙ

---

Google検索

Wikipedia

---

ぬこの手 ぬこTOP 0.024s