0 - SQL=select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, if(FIND_IN_SET('featured_companies',features) ,1,0) as featured from ( select cp.*, cp.name as companyName,cp.id as companyId1, cn.country_name as countryName,ct.name as typeName, cnt.contact_name, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(DISTINCT cg.name separator '#') as categoryNames, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.id as mainCategoryId from zd52w_jbusinessdirectory_companies cp left join zd52w_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join zd52w_jbusinessdirectory_categories cg on cg.id=cc.categoryId left join zd52w_jbusinessdirectory_categories bc on bc.id=cp.mainSubcategory left join zd52w_jbusinessdirectory_company_contact cnt on cp.id=cnt.companyId left join zd52w_jbusinessdirectory_countries cn on cp.countryId=cn.country_id left join zd52w_jbusinessdirectory_company_types ct on cp.typeId=ct.id left join zd52w_jbusinessdirectory_orders inv on inv.company_id=cp.id left join zd52w_jbusinessdirectory_packages p on (inv.package_id=p.id ) or (p.id=cp.package_id and p.price=0) left join zd52w_jbusinessdirectory_package_fields pf on p.id=pf.package_id where 1 and ((inv.state= 1 and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id and p.days = 0))) or p.price=0) and cp.state=1 and (cp.approved = 2 or cp.approved= 0) group by cp.id order by RAND() ) as slec left join zd52w_jbusinessdirectory_company_ratings cra on cra.companyId=companyId1 group by companyId1 having featured = 1 order by RAND() LIMIT 0, 4

Вы не можете посетить текущую страницу по причине:

  1. просроченная закладка/избранное
  2. поисковый механизм, у которого просрочен список для этого сайта
  3. пропущен адрес
  4. у вас нет права доступа на эту страницу
  5. Запрашиваемый ресурс не найден.
  6. В процессе обработки вашего запроса произошла ошибка.

Пожалуйста, перейдите на одну из следующих страниц:

Если проблемы продолжатся, пожалуйста, обратитесь к системному администратору сайта и сообщите об ошибке, описание которой приведено ниже..

SQL=select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, if(FIND_IN_SET('featured_companies',features) ,1,0) as featured from ( select cp.*, cp.name as companyName,cp.id as companyId1, cn.country_name as countryName,ct.name as typeName, cnt.contact_name, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(DISTINCT cg.name separator '#') as categoryNames, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.id as mainCategoryId from zd52w_jbusinessdirectory_companies cp left join zd52w_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join zd52w_jbusinessdirectory_categories cg on cg.id=cc.categoryId left join zd52w_jbusinessdirectory_categories bc on bc.id=cp.mainSubcategory left join zd52w_jbusinessdirectory_company_contact cnt on cp.id=cnt.companyId left join zd52w_jbusinessdirectory_countries cn on cp.countryId=cn.country_id left join zd52w_jbusinessdirectory_company_types ct on cp.typeId=ct.id left join zd52w_jbusinessdirectory_orders inv on inv.company_id=cp.id left join zd52w_jbusinessdirectory_packages p on (inv.package_id=p.id ) or (p.id=cp.package_id and p.price=0) left join zd52w_jbusinessdirectory_package_fields pf on p.id=pf.package_id where 1 and ((inv.state= 1 and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id and p.days = 0))) or p.price=0) and cp.state=1 and (cp.approved = 2 or cp.approved= 0) group by cp.id order by RAND() ) as slec left join zd52w_jbusinessdirectory_company_ratings cra on cra.companyId=companyId1 group by companyId1 having featured = 1 order by RAND() LIMIT 0, 4