Warning: in_array() expects parameter 2 to be array, null given in /var/www/virtual/cms.210.aveqimedia.nl/aveqcms10.php(1769) : eval()'d code on line 507
SELECT a.id as id, actionId, executionDate, deadline, employeeId, orderId, briefing, s.Title as pakketOnderdeel, s.Variabele5 as pakketOnderdeelFriendly,
w.Variabele2 as functie, w.Title as werkcode, customer.Title as klant, w.Variabele3 as logic,
a.componentId as componentId ,employee.Title as medewerker, functie.Title as functieNaam,
a.componentId, o.id as orderId, o.note as orderNote, planning.id as planningId, planning.Title as planningName, planning.note as note,
planning.start as startDate, planning.end as endDate, o.customerId as partnerId, planning.channels as channels,
planning.start as startDateStamp, planning.end as endDateStamp
FROM `table_component_action` a
LEFT JOIN site_content w on w.nr = actionId
LEFT JOIN table_component_planning planning on planning.id = a.planningId
LEFT JOIN table_order_component c on c.id = planning.componentId
LEFT JOIN table_order o on o.id = c.orderId
LEFT JOIN site_content s on s.nr = c.componentId
LEFT JOIN site_content customer on customer.nr = o.customerId
LEFT JOIN site_content functie on functie.nr = w.Variabele2 LEFT JOIN site_content employee on employee.nr = employeeId
WHERE a.done = 1 AND o.status!=3 AND (a.employeeId = -1 OR (a.employeeId = 0 AND w.Variabele2 IN (PAGE function error: field not found.))) AND o.id!='' AND o.status !=2
ORDER BY
o.id, customer.Title ASC, planning.id ASC, planning.componentId, IF(a.executionDate = '0000-00-00',a.deadline , a.executionDate) ASC <>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function error: field not found.))) AND o.id!='' AND o.status !=2
ORDER ' at line 17