ERRORE: Unknown column 'p.id_category' in 'on clause' query SQL: [
SELECT p.*, p.id AS id_photo, t.*, c.*, l.*, u.* FROM tbl_photo p, tbl_photo_tags pt
LEFT JOIN tbl_tags t ON (pt.id_tags = t.id)
LEFT JOIN tbl_categories c ON (p.id_category=c.id)
LEFT JOIN tbl_albums l ON (p.id_album=l.id)
LEFT JOIN tbl_users u ON (p.id_users=u.id)
WHERE pt.id_photo = p.id AND t.id IN (22242) AND p.active = '1'
GROUP BY p.id
ORDER BY p.click DESC
LIMIT 20
]
ERRORE: Unknown column 'p.id_category' in 'on clause' query SQL: [
SELECT p.*, p.id AS id_photo, t.*, c.*, l.*, u.* FROM tbl_photo p, tbl_photo_tags pt
LEFT JOIN tbl_tags t ON (pt.id_tags = t.id)
LEFT JOIN tbl_categories c ON (p.id_category=c.id)
LEFT JOIN tbl_albums l ON (p.id_album=l.id)
LEFT JOIN tbl_users u ON (p.id_users=u.id)
WHERE pt.id_photo = p.id AND p.id_category = '10' AND p.active = '1'
GROUP BY p.id
ORDER BY p.click DESC
LIMIT 20 ]