SELECT `c` . `cntry_id` AS id ,
`c` . `cntry_eng` FROM `bo_
cntries` c LEFT JOIN `bo_cntries_
lang` cl ON `cl` .`cntry_id` =
`c` . `cntry_id` AND `cl` .`lang_
id` = 2 WHERE IF( `cl` .`cntry_
lang` IS NULL OR TRIM
(`cl` . `cntry_lang` ) = '',
`c` . `cntry_eng` LIKE
'%eng%' , `cl` .`cntry_
lang` LIKE
'%eng%'e )
|