Could you please post here the result of the following query:
select
child.id as id, pm.start as s1, membership.start as s2,
ifnull(pm.start,membership.start) as s3 from organisation
child
left join organisation pmorg on child.parent_organisation_id=pmorg.id
left join membership on child.id=membership.organisation_id
left join membership pm on pmorg.id=pm.organisation_id
where child.id in (1,3) and
coalesce(pm.start,membership.start) is not null and
((membership.active=1 and membership.amount_paid> 0.00 ) or
(pm.active=1 and pm.amount_paid> 0.00))
On 08/07/11 16:32, Jochen Daum wrote:
Hi,
What is "323031312d30372d30312030303a30303a3030" in the output? Is it what
is supposed to be the result of
max(ifnull(pm.start,membership.start))
thats what I wonder!
Jochen
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
