البيوت القاتلة

تفاصيل الكتاب

SELECT table1.`id`,table1.`depart`, table1.`title`, table1.`desc`, table1.`writer`, table1.`view`, table1.`date`, table1.`keywords`, table1.`seo_desc`,table1.`images` ,authers.title as book_writer,table1.`code`,table1.`price_before`,table1.`price_after`,table1.`shipping`,table1.`video`,table1.`publisher`,table1.`realize`,table1.`printing_date`,table1.`printing_num`,table1.`archive` , table2.title as depart_title FROM books as table1 join departs_books as table2 join authers where table1.depart=table2.id and table1.active=1 and table1.id=1003 and authers.id=table1.writer order by table1.id desc , table1.priority desc