|
|
|
Querie:
SELECT
A.id,
C.city,
C.id AS Cityid,
P.agName,
A.type,
A.titel,
A.tekst,
A.imageOrg,
A.imageS,
A.imageM,
A.aantPers,
A.tijdsduur,
A.prijs,
A.prijs_eenheid,
A.optioneel,
A.time,
A.urlname,
IF
(
A.urlname = 'walking-dinner-beppen-opschepen-en-steppen-brunch'
OR
A.urlname = 'walking-brunch-beppen-opschepen-en-steppen-brunch'
,
1,
0
) AS position1,
IF(A.id IN (), 1, 0) AS position2
FROM
arrangementen A
LEFT JOIN
agTypes P
ON
P.id = A.type
LEFT JOIN
cities C
ON
A.city = C.id
WHERE
(
P.id = 6
AND
C.city_url = 'beppen-opschepen-en-steppen-brunch'
)
OR
(
A.id IN ()
)
ORDER BY
position1 DESC,
position2 DESC,
A.titel
LIMIT
0, 30
Error: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 '), 1, 0) AS position2
FROM
arrangementen A
LEFT JOIN
agTypes P
ON
' at line 28
| |
 |
Geen arrangementen in Beppen opschepen en steppen brunch |
|
|
|
|
|
|
|
