A Database Error Occurred

Error Number: 1052

Column 'id' in field list is ambiguous

select *, CASE pid WHEN -1 THEN CONCAT_WS('.',id,LPAD((SELECT MAX(id)+1 FROM vtv_comment WHERE pid = C.id),3,'0')) ELSE CONCAT_WS('.',pid,LPAD(id,3,'0')) END AS sort, (select COUNT(*) from vtv_comment r where r.pid = C.id ) AS hasreply, if(pid<>-1,(select MIN(id) from vtv_comment r where r.pid = C.pid),-1) as lastreply from vtv_comment as C JOIN vtv_member ON vtv_member.email=C.email where vid=10331 ORDER BY sort DESC

Filename: models/Vdata.php

Line Number: 526