No valid database connection Got error 28 from storage engine SQL=SELECT o.*, c.name AS catname, c.alias AS catalias, c.id AS cat_id, t.name as typename, t.id as typeid, image.path as imagepath, image.fname as imagefilename, image.type as imagetype, (SELECT a.name FROM compravendita_estateagent_agents AS a WHERE a.id = o.agent AND a.published=1) AS agentname, (SELECT ct.name FROM compravendita_estateagent_countries AS ct WHERE ct.ccode = o.country AND ct.published=1) AS country FROM compravendita_estateagent as o LEFT JOIN ( SELECT * FROM compravendita_estateagent_images AS img WHERE 1 AND (img.type = '.jpg' OR img.type = '.gif' OR img.type = '.png') AND img.ordering = 1 AND img.published = 1 ) as image ON (image.objid = o.id) LEFT JOIN compravendita_estateagent_categories AS c ON (o.cat = c.id) LEFT JOIN compravendita_estateagent_type AS t ON (o.type = t.id) WHERE (o.cat=82 OR o.cat IN(64)) AND (
((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-12-23 07:56:40') AND o.publish_down >= '2025-12-23 07:56:40')
OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-12-23 07:56:40' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2025-12-23 07:56:40'))
OR (o.publish_up = '0000-00-00 00:00:00' AND o.publish_down = '0000-00-00 00:00:00')
)
AND o.access<=0 AND o.published=1 ORDER BY obj_id ASC LIMIT 0, 10
indietro
indietro
|
|
