Same versions of Mysql and the OS (Ubuntu), Databases synced fully. Even the replica gives different results.
One mysql instance is showing 11 results (from a Select distinct statement) and all the other SYNCED db's are showing 12 results.
One the missing result server, if you change it to distinct by uid instead of *, then all 12 show up. So the record is there it's just not showing up in the select query.
any idea's why this is happening?
mysql server version is 5.1.56
here is the select statement:
select distinct bdtag3_.* from Company bdcompany0_ inner join Company_Tag tags1_ on bdcompany0_.UID=tags1_.COMPANY_UID inner join Tag bdtag2_ on tags1_.TAG_UID=bdtag2_.UID inner join Tag bdtag3_ on bdtag2_.PARENT=bdtag3_.UID, CompanyPostedStatus bdcompanyp4_ where bdcompany0_.POSTED_STATUS_UID=bdcompanyp4_.UID and bdcompanyp4_.IS_POSTED=1 and bdtag2_.TAG_TYPE_UID=14 order by bdtag3_.DESCRIPTION