Classificados
Brasil
GetValue:: Exec query failed! [SELECT cl.classified_id,cl.category_id,cl.created,cl.created_uid,cl.updated,cl.updated,cl.class,cl.enabled,cl.category_id,cl.category_id,cl.publication_date,cl.expiration_date,cl.classified_no,cl.type,cl.title,cl.description,cl.price,cl.cia_name,cl.title_id,cl.fname,cl.lname,cl.address,cl.address1,cl.district,cl.zipcode,cl.city,cl.region,cl.country_code,cl.phone,cl.mobile,cl.fax,cl.email,cl.skype_name skype_name,cl.homepage,cl.comments,cl.tags,cl.video_code,cl.show_map,cl.image_filename,cl.hits,cl.lasthit_ip,cl.lasthit_date,cl.responses,cl.lresponder_name,cl.lresponder_email,cl.auto_publish,cl.user_activation,cl.twitter_publish twitter_publish,cl.twitter_id twitter_id FROM cbr_classified_br cl, cbr_classifieds_category c WHERE cl.deleted='N' and cl.enabled='Y' and ( cl.title like '%casa%' or cl.title like '%alugar%' or cl.title like '%pouso%' or cl.title like '%alegre%' or ) and cl.category_id = c.category_id ORDER by DATE_FORMAT(cl.publication_date,'%Y%m%d%H%i%s') DESC LIMIT 0, 12 ]