SELECT
wall.id,
wall.owner_id,
wall.user_id,
wall.text,
wall.active,
wall.date,
GROUP_CONCAT(DISTINCT(wall_photos.photo)),
GROUP_CONCAT(DISTINCT(wall_audios.audio))
FROM wall
LEFT JOIN wall_photos
ON wall.id = wall_photos.wall
AND wall_photos.active = 1
LEFT JOIN wall_audios
ON wall.id = wall_audios.wall
AND wall_audios.active = 1
WHERE owner_id = ?
AND wall.active = 1
GROUP BY wall.id
ORDER BY wall.date DESC
A phrase that is enclosed within double quote (") characters matches only rows that contain the phrase literally, as it was typed
... HAVING (COUNT(DISTINCT('sp.service_id'))) ...
json_encode работает вне while, но не работает внутри while.
НО, просто невозможно сделать так
Как переписать код в более простой и понятный вид?
There is no way to clear the session history or to disable the back/forward navigation from unprivileged code.