Query: | SELECT a.*, at.name,v.volume_year, v.volume_number FROM jss_articles a LEFT JOIN jss_article_types at ON a.article_type = at.id LEFT JOIN jss_article_volume v ON a.volume_id = v.id
WHERE CONCAT(a.article_ref_jj,a.article_ref_yy,a.article_ref_nnnn) = 'JSS17B007' |