1054 Error

Unknown column 'p.expiration_type' in 'where clause' SQL=select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured from ( select cp.id, cp.name, cp.alias, cp.short_description, cp.street_number, cp.address, cp.countryId, cp.city, cp.county, cp.province, cp.area, cp.typeId, cp.website, cp.phone, cp.email, cp.state, cp.fax, cp.averageRating, cp.slogan, cp.logoLocation, cp. review_score, cp.featured,cp.publish_only_city, cp.publish_start_date, cp.publish_end_date, cp.name as companyName,cp.id as companyId1, cp.latitude, cp.longitude, cp.postalCode, cn.country_name as countryName,ct.name as typeName, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.alias as mainCategoryAlias, bc.markerLocation as categoryMaker, bc.id as mainCategoryId from #__jbusinessdirectory_companies cp left join #__jbusinessdirectory_company_category cc on cp.id=cc.companyId left join #__jbusinessdirectory_categories cg on cg.id=cc.categoryId left join #__jbusinessdirectory_categories bc on bc.id=cp.mainSubcategory and bc.published=1 left join #__jbusinessdirectory_countries cn on cp.countryId=cn.id left join #__jbusinessdirectory_company_types ct on cp.typeId=ct.id left join #__jbusinessdirectory_orders inv on inv.company_id=cp.id left join #__jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and p.status=1 and 1) left join #__jbusinessdirectory_package_fields pf on p.id=pf.package_id where (cp.name like '%' or cp.name like '%' ) and ( ( (inv.state= 1 and ( ( (now() > (inv.start_date) and (now() < ( inv.start_date + INTERVAL p.days DAY) or p.expiration_type=1)) or (now() > (inv.start_trial_date) and now() < ( inv.start_trial_date + INTERVAL p.trial_days DAY))) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0))) ) and cp.state=1 and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) group by cp.id order by cp.name ) as slec left join #__jbusinessdirectory_company_ratings cra on cra.companyId=companyId1 group by companyId1 order by companyName LIMIT 0, 20

You may not be able to visit this page because of:

  • an out-of-date bookmark/favourite
  • a search engine that has an out-of-date listing for this site
  • a mistyped address
  • you have no access to this page
  • The requested resource was not found.
  • An error has occurred while processing your request.

Try to search on the website: