So, the issue is the sql_query then... which means, it's very likely one of two things... the joins stop the relevant values, or the where- clause does.
The latter: `expenses`.`delta` = 0 AND repeated_template = false -- would either of these stop the relevant expenses from appearing? -- Pat On 11/02/2009, at 9:09 AM, Steven Bristol wrote: > > Forgot to mention: > > I ran the query in mysql and searched for the business_id 4988 and it > returned zero. I'm not sure what in the sql is omitting those records. > > steve > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
