    
  <!-- SQL su intangible_search = SELECT maincounter, idk, esc, reh, red, rex, repd, reps, repr, repp, repc, repl, rept, repg, rerd, reca, reca1, reca2, recb, recs, rea, reu, reva, revm, aggt, substr(cmpd, 1, 11), rez,substr(aggd, 1, 11),concat(a.UTDN,' ', a.utdc),ree, concat(aess_users.aessent_sub_ut.UTDN, ' ', aess_users.aessent_sub_ut.utdc) operatore_inserimento,cmpn        FROM (SELECT maincounter, idk, esc, reh, red, rex, repd, reps, repr, repp, repc, repl, rept, repg, rerd, reca, reca1, reca2, recb, recs, rea, reu, reva, revm, aggt, cmpd, rez,aggd,UTDN, utdc,ree ,cmpn FROM intangible_search.AESSICH_SCHEDA_AESSICH LEFT JOIN aess_users.aessent_sub_ut on aess_users.aessent_sub_ut.utu=intangible_search.AESSICH_SCHEDA_AESSICH.aggn  WHERE idk = 'ICH-TRY00-0000001476') a  LEFT JOIN aess_users.aessent_sub_ut ON aess_users.aessent_sub_ut.utu = a.cmpn -->  Invalid query: 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 'AND docn IS NOT NULL
AND docw = 'S'
and docp = 'ÍMG'
ORDER BY
docm,
	substr(doc' at line 13 - SELECT DISTINCT
	docn,DOCM,docp,
	docv,
	
	doci,
	docd,
	doca,
	doco
FROM
	AESSICH_SUB_DOC
WHERE
	mainreference = 
AND docn IS NOT NULL
AND docw = 'S'
and docp = 'ÍMG'
ORDER BY
docm,
	substr(docd, 7, 4),
	substr(docd, 4, 2),
	substr(docd, 1, 2),
	doco