explain SELECT a.*, cc.name AS category, ee.ezcity AS proploc, ee.ezcity_desc AS ezdesc, dd.name AS statename, bb.name AS countryname, u.mid AS mid, u.dealer_name AS dealer_name, u.dealer_company AS dealer_company, u.dealer_phone AS dealer_phone,
u.dealer_mobile AS dealer_mobile, u.dealer_email AS dealer_email, u.dealer_image AS dealer_image, u.dealer_type AS dealer_type FROM #__ezrealty as a LEFT JOIN #__ezrealty_catg AS cc ON cc.id = a.cid LEFT JOIN #__ezrealty_locality AS ee ON ee.id = a.locid LEFT JOIN #__ezrealty_state AS dd ON dd.id = a.stid LEFT JOIN #__ezrealty_country AS bb ON bb.id = a.cnid LEFT JOIN #__ezrealty_profile AS u ON u.mid = a.owner WHERE a.published=1 AND cc.published=1 AND (a.cid=1 OR a.cid=20 OR a.cid=21) ORDER BY a.id DESC
http://menyayu.com/?allyur
http://perevod.webmoney.ru
удалил...
10
Удали строку:
if ($row['image1']=="") $row['image1'] = "nothumb.gif";
и замени ниже строку на эту:
<image_link title="'.$row['image1desc'].'">'.($row['image1']!='' ? 'http://www.site.ru/imagedirectory/'.$row['image1'] : '').'</image_link>
А что в $u_url ?
Замени в запросе "#__" на "jos_" и выполни его.
У тебя в базе есть таблицы типа "#__ezrealty_catg" или они заываются как-то другому?
ОК. После
. "\n ORDER BY a.id DESC"
;
Добавь:
Запусти скрипт - на экран получишь запрос. Выполни его в phpmyadmin'e.
Выполни запрос через phpmyadmin:
u.dealer_mobile AS dealer_mobile, u.dealer_email AS dealer_email, u.dealer_image AS dealer_image, u.dealer_type AS dealer_type FROM #__ezrealty as a LEFT JOIN #__ezrealty_catg AS cc ON cc.id = a.cid LEFT JOIN #__ezrealty_locality AS ee ON ee.id = a.locid LEFT JOIN #__ezrealty_state AS dd ON dd.id = a.stid LEFT JOIN #__ezrealty_country AS bb ON bb.id = a.cnid LEFT JOIN #__ezrealty_profile AS u ON u.mid = a.owner WHERE a.published=1 AND cc.published=1 AND (a.cid=1 OR a.cid=20 OR a.cid=21) ORDER BY a.id DESC
и выложи результат в виде скриншота.
Тогда наверно единственный выход - оптимизировать работу скрипта.
ЗЫ: Могу взглянуть на скрипт.
А сколько на локальной машине доступно памяти php?