Could not query:
SELECT * FROM sched_homesInfo
WHERE homeBuildGroupingID > 1 && homeDateConstEnd > NOW()
ORDER BY homeBuildGroupingID,homeOrder
Could not query:
SELECT *,COUNT(sched_volunteerScheduleIndex.indexVolunteerID) AS numSched
FROM sched_workDaySchedule,sched_shifts,sched_dayDescriptions,sched_volunteerScheduleIndex
WHERE sched_workDaySchedule.dayDescriptionID = sched_dayDescriptions.dayDescriptionID
&& sched_dayDescriptions.dayDescriptionID = sched_shifts.dayDescriptionID
&& sched_volunteerScheduleIndex.indexScheduleID = sched_workDaySchedule.scheduleID
&& sched_volunteerScheduleIndex.whichShift = sched_shifts.shiftNum
&& scheduleDate >= '2010-09-07' && scheduleDate < '2010-10-01'
GROUP BY indexScheduleID,shiftNum
Could not query:
SELECT scheduleID,shiftNum,SUM(sched_groupScheduleIndex.numThisDay) AS numSched
FROM sched_shifts,sched_dayDescriptions,sched_groupScheduleIndex,sched_workDaySchedule
WHERE sched_workDaySchedule.dayDescriptionID = sched_dayDescriptions.dayDescriptionID
&& sched_shifts.dayDescriptionID = sched_dayDescriptions.dayDescriptionID
&& sched_groupScheduleIndex.indexScheduleID = sched_workDaySchedule.scheduleID
&& sched_groupScheduleIndex.whichShift = sched_shifts.shiftNum
&& scheduleDate >= '2010-09-07' && scheduleDate < '2010-10-01'
GROUP BY indexScheduleID,shiftNum
Could not query:
SELECT *
FROM sched_workDaySchedule,sched_dayDescriptions,sched_shifts,sched_buildTypes,sched_homesInfo,sched_buildGroupings
WHERE sched_workDaySchedule.dayDescriptionID = sched_dayDescriptions.dayDescriptionID
&& sched_shifts.dayDescriptionID = sched_dayDescriptions.dayDescriptionID
&& homeBuildGroupingID = buildGroupingsID
&& homeBuildGroupingID = 1
&& dayDescriptionHomeID = homeID
&& homeBuildTypeID = buildTypeID
&& (scheduleDate >= '2010-09-07' && scheduleDate < '2010-10-01') && homeShowOnSite RLIKE 'web site'
ORDER BY scheduleDate,shiftNum,homeOrder,buildGroupingsID
IF YOU ARE SEEING THIS, THEN THERE IS A PROBLEM.