нет цифрового образа
select
*,@diid:=id_digital_image as id_digital_image,
p.title AS places, a.title AS authors
from digital_image
LEFT JOIN places p ON p.id=id_places
LEFT JOIN authors a ON a.id=id_authors
WHERE `id_digital_image`='9346' limit 1;
нет цифрового образаSELECT FKOD,FNAME,OKOD,ONAME,L1,L4,@OPIS_IS:=OPIS as OPIS_ID FROM digital_image di LEFT JOIN DELO D ON(DELO_ID=D.KOD) LEFT JOIN opis o ON(o.OPIS_ID=di.OPIS_ID) WHERE id_digital_image=@diid;
нет цифрового образаselect * from section_fotos_links_sys where `item_id`=@diid and `plugins_name`='foto_index' order by section_fotos_id;
нет цифрового образаselect * from rubrikator_links_sys where `item_id`=@diid and `plugins_name`='foto_index' order by rubrikator_id;
нет цифрового образаselect KOD,L1 from DELO where OPIS=@OPIS_IS order by cast(L1 as signed );