SELECT biblio.biblio_id, biblio.title, biblio.image, biblio.isbn_issn, biblio.publish_year, pbl.publisher_name AS `publisher`, pplc.place_name AS `publish_place`, biblio.labels, biblio.input_date FROM biblio LEFT JOIN mst_publisher AS pbl ON biblio.publisher_id=pbl.publisher_id LEFT JOIN mst_place AS pplc ON biblio.publish_place_id=pplc.place_id WHERE opac_hide=0 AND (biblio.biblio_id IN (SELECT ba.biblio_id FROM biblio_author AS ba LEFT JOIN mst_author AS a ON ba.author_id=a.author_id WHERE author_name LIKE '%Universitas Andalas%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 Jurnal Ilmu Fisika (JIF) vol. 14 no. 1, Maret 2022 Universitas Andalas Primary Author mixed material 19794657 Padang Universitas Andalas 2022 168366275663e310064c38e2.17662651.png Jurnal Ilmu Fisika (JIF) vol. 14 no. 2, September 2022 Universitas Andalas Primary Author mixed material 19794657 Padang Universitas Andalas 2022 214252248163e3107924e724.71614017.png Jurnal Ilmu Fisika (JIF) vol. 13 no. 1, Maret 2021 Universitas Andalas Primary Author mixed material 19794657 Padang Universitas Andalas 2021 140208931463e30f5c648be5.95074612.png Jurnal Ilmu Fisika (JIF) vol. 13 no. 2, September 2021 Universitas Andalas Primary Author mixed material 19794657 Padang Universitas Andalas 2021 55569876263e30fbf78cb19.69709408.png Jurnal Ilmu Fisika (JIF) vol. 12 no. 1, Maret 2020 Universitas Andalas Primary Author mixed material 19794657 Padang Universitas Andalas 2020 78901769863e30a29617924.21630210.jpg Jurnal Ilmu Fisika (JIF) vol. 12 no. 2, September 2020 Universitas Andalas Primary Author mixed material 19794657 Padang Universitas Andalas 2020 136887905763e30a094c8395.17053193.png Seminar nasional ke-1 FISIP : peran ilmu-ilmu sosial dalam pembangunan Indonesia baru Padang, 15-17 Oktober 2014 Gedung Convention Hall Universitas Andalas Fakultas Ilmu Soal dan Ilmu Politik Universitas Andalas Primary Author mixed material 9786027154001 Padang Fakultas Ilmu Soal dan Ilmu Politik Universitas Andalas 2014