Timeline for Converting MySQL to db_select with subquery count
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 19, 2014 at 10:49 | vote | accept | mediaashley | ||
| Nov 18, 2014 at 17:25 | answer | added | tenken | timeline score: 0 | |
| Nov 18, 2014 at 16:58 | comment | added | mediaashley | @tenken, I have managed to get access to Devel and have attached to the question. | |
| Nov 18, 2014 at 16:58 | history | edited | mediaashley | CC BY-SA 3.0 |
added 770 characters in body
|
| Nov 18, 2014 at 16:29 | comment | added | mediaashley | @tenken, I don't have access to Devel (long story) but I have updated the question with the generated query string. | |
| Nov 18, 2014 at 16:28 | history | edited | mediaashley | CC BY-SA 3.0 |
added 849 characters in body
|
| Nov 18, 2014 at 15:56 | comment | added | mediaashley | Yes. It is as if the subquery wasn't there at all. | |
| Nov 18, 2014 at 15:56 | comment | added | tenken |
did you install the Devel module and do dpq($query) to see what output drupal is generating for your db_select ?
|
|
| Nov 18, 2014 at 15:10 | comment | added | Paul | Just to make sure, you removed them from the left join in your subquery as well? | |
| Nov 18, 2014 at 14:54 | comment | added | mediaashley | Hmm... didn't notice that, but removing them has no effect. | |
| Nov 18, 2014 at 14:51 | comment | added | Pravin Ajaaz | db_select has the curly braces around it '{'... eg: '{field_data_field_field_route_matrix}'.. ?? | |
| Nov 18, 2014 at 14:48 | history | asked | mediaashley | CC BY-SA 3.0 |