SQL: select count(t1.pra_id) as count_pra from `partner_angebot` as t1 left join clients as t2 on t2.cl_id=t1.cl_id left join categories_type as t3 on t3.ct_id=t1.ct_id left join categories as t4 on t4.pc_id=t1.k_id left join bereich as t5 on t5.br_id=t1.br_id left join categories_unter_type as t6 on t6.cut_id=t1.cut_id left join currencies as t7 on t7.cur_id=t1.cur_id left join begriffe_main as t8 on t8.pra_id=t1.pra_id and t8.trb_id=42 where t1.cl_id>0 and t1.`pra_deleted` = '0' and t1.pra_verkauft = '0' and (LOWER(t8.bm_text) like '%dmg mori seiki%' OR LOWER(t1.pra_title) like '%dmg mori seiki%' ) AND t1.pra_new_product = 0 order by t1.`pra_idate` desc Server shutdown in progress