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 bt.biblio_id FROM biblio_topic AS bt LEFT JOIN mst_topic AS t ON bt.topic_id=t.topic_id WHERE topic LIKE '%CANADA%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
10 1 20 Integrated marketing communications : strategic planning perspectives. Fifth Edition Tuckwell, Keith Primary Author mixed material 9780134270371 Don Mills Pearson Canada 2018 dfdfdgfhfgdfgdg.jpg.jpg Management. Fourteenth Edition Robbins, Stephen P Primary Author Coulter, Mary K Primary Author mixed material 9781292215839 Sydney Pearson 2018 1292215836-min.jpg.jpg Sociology. Sixteenth Global Edition Macionis, John J. Primary Author Gerber, Linda M. Primary Author mixed material 9781292161471 Harlow Pearson 2018 dfdgfgdgdfdgf.jpg.jpg Business communication essentials. Seventh Global Edition Bovée, Courtland L. Primary Author Thill, John V. Primary Author Schatzman, Barbara E. Primary Author Scribner, Jean Primary Author mixed material 9781292093260 Boston Pearson 2016 %2B-%2B939609304_70.gif.gif Safdie Safdie, Moshe Primary Author mixed material 9781864705591 South Melbourne Images Publishing Group 2015 9781864705591.gif.gif Criminology. Eighth Edition Adler, Freda Primary Author Mueller, Gerhard O. W. Primary Author Laufer, William S. Primary Author mixed material 9780078026423 New York McGraw-Hill 2013 asffdgfhfdsfsf.gif.gif Economics : brief edition. Second Edition McConnell, Campbell R. Primary Author Brue, Stanley L. Primary Author Flynn, Sean Masaki Primary Author Grant, Randy R. Primary Author mixed material 9780073511467 New York McGraw-Hill Irwin 2013 ajhdhjdhjdj.gif.gif Fundamentals of corporate finance. Tenth Edition Ross, Stephen A. Primary Author Jordan, Bradford D. Primary Author Westerfield, Randolph W. Primary Author mixed material 9780077479459 New York McGraw-Hill/Irwin 2013 hgfhgf.gif.gif Marketing : the core. Fifth Edition Kerin, Roger A. Primary Author Rudelius, William Primary Author Hartley, Steven William Primary Author mixed material 9780078028922 New York McGraw-Hill 2013 hfhdgdsfszf.gif.gif Excellent public relations and effective organizations : a study of communication management in three countries Grunig, Larissa A. Primary Author Dozier, David M. Primary Author Grunig, James E. Primary Author mixed material 9780805818185 New York Routledge 2009 %2B-%2B232041002_70.gif.gif