1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

SELECT SQL_CALC_FOUND_ROWS pr.uniqueId, pr.uniqueUserId, pr.date_created, pr.date_lastupdate, pr.userid_lastupdate, pr.ip_lastupdate, pr.uniqueAddress, pr.adStyle, pr.adStatus, pr.syndicationId, pr.extLinkId, pr.field1 AS vehicleDate, pr.field2 AS vehicleMake, pr.field3 AS vehicleModel, pr.field4 AS vehicleModelCode, pr.field5 AS vehicleBodyStyle, pr.field6 AS vehicleCondition, pr.field7 AS vehicleExtColor, pr.field8 AS vehicleIntColor, pr.field9 AS vehicleIntFabric, pr.field10 AS vehicleDoorNumber, pr.field11 AS vehicleFuelType, pr.field12 AS vehicleTransSpeedType, pr.field13 AS vehicleTransType, pr.field14 AS vehicleEngineInfo, pr.field15 AS vehicleNumberOwners, pr.field16 AS vehicleKm, pr.field17 AS vehicleRegoNo, pr.field18 AS vehicleVin, pr.field19 AS vehicleRegoExpiry, pr.field20 AS vehicleFeatures, pr.field21 AS vehicleConversionBy, pr.field22 AS vehicleAdaCompliant, pr.field23 AS vehicleRampType, pr.field24 AS vehicleRampDetails, pr.field25 AS vehicleEntranceType, pr.field26 AS vehicleRunBoards, pr.field27 AS vehicleSideDoor, pr.field28 AS vehicleTieDownType, pr.field29 AS vehicleTieDownNo, pr.field30 AS vehicleDriveAids, pr.field31 AS vehicleInteriorSpace, pr.field32 AS vehicleIntHcFeatures, pr.field33 AS vehicleExtHcFeatures, pr.field34 AS vehicleSummDescription, pr.field35 AS vehicleDescription, pr.field36 AS vehiclePrice, pr.field37 AS vehicleBestOffer, pr.field38 AS photoFile1, pr.field39 AS photoDesc1, pr.field40 AS photoFile2, pr.field41 AS photoDesc2, pr.field42 AS photoFile3, pr.field43 AS photoDesc3, pr.field44 AS photoFile4, pr.field45 AS photoDesc4, pr.field46 AS photoFile5, pr.field47 AS photoDesc5, pr.field48 AS photoFile6, pr.field49 AS photoDesc6, pr.field50 AS contactName, pr.field64 AS photoFile7, pr.field51 AS contactInfo, pr.field65 AS photoDesc7, pr.field52 AS contactSellType, pr.field66 AS photoFile8, pr.field53 AS contactPhone1Type, pr.field67 AS photoDesc8, pr.field54 AS contactMobPhone, pr.field68 AS photoFile9, pr.field55 AS contactPhone2Type, pr.field69 AS photoDesc9, pr.field56 AS contactHPhone, pr.field70 AS photoFile10, pr.field57 AS contactPhone3Type, pr.field71 AS photoDesc10, pr.field58 AS contactWPhone, pr.field72 AS photoFile11, pr.field59 AS contactEmail, pr.field73 AS photoDesc11, pr.field60 AS contactCity, pr.field74 AS photoFile12, pr.field61 AS contactState, pr.field75 AS photoDesc12, pr.field62 AS contactRegion, pr.field76 AS photoFile13, pr.field63 AS contactZip, pr.field77 AS photoDesc13, pr.field78 AS photoFile14, pr.field79 AS photoDesc14, pr.field80 AS photoFile15, pr.field81 AS photoDesc15, pr.field82 AS photoFile16, pr.field83 AS photoDesc16, pr.field84 AS photoFile17, pr.field85 AS photoDesc17, pr.field86 AS photoFile18, pr.field87 AS photoDesc18, pr.field88 AS photoFile19, pr.field89 AS photoDesc19, pr.field90 AS photoFile20, pr.field91 AS photoDesc20, pr.field92 AS photoFile21, pr.field93 AS photoDesc21, pr.field94 AS photoFile22, pr.field95 AS photoDesc22, pr.field96 AS photoFile23, pr.field97 AS photoDesc23, pr.field98 AS photoFile24, pr.field99 AS photoDesc24, pr.field100 AS photoFile25, pr.field101 AS photoDesc25, pr.field102 AS photoFile26, pr.field103 AS photoDesc26, pr.field104 AS photoFile27, pr.field105 AS photoDesc27, pr.field106 AS photoFile28, pr.field107 AS photoDesc28, pr.field108 AS photoFile29, pr.field109 AS photoDesc29, pr.field110 AS photoFile30, pr.field111 AS photoDesc30, pr.field112 AS photoFile31, pr.field113 AS photoDesc31, pr.field114 AS photoFile32, pr.field115 AS photoDesc32, pr.field116 AS photoFile33, pr.field117 AS photoDesc33, pr.field118 AS photoFile34, pr.field119 AS photoDesc34, pr.field120 AS photoFile35, pr.field121 AS photoDesc35, pr.field122 AS photoFile36, pr.field123 AS photoDesc36, pr.field124 AS photoFile37, pr.field125 AS photoDesc37, pr.field126 AS photoFile38, pr.field127 AS photoDesc38, pr.field128 AS photoFile39, pr.field129 AS photoDesc39, pr.field130 AS photoFile40, pr.field131 AS photoDesc40, pr.field132 AS photoFile41, pr.field133 AS photoDesc41, pr.field134 AS photoFile42, pr.field135 AS photoDesc42, pr.field136 AS photoFile43, pr.field137 AS photoDesc43, pr.field138 AS photoFile44, pr.field139 AS photoDesc44, pr.field140 AS photoFile45, pr.field141 AS photoDesc45, pr.field142 AS photoFile46, pr.field143 AS photoDesc46, pr.field144 AS photoFile47, pr.field145 AS photoDesc47, pr.field146 AS photoFile48, pr.field147 AS photoDesc48, pr.field148 AS photoFile49, pr.field149 AS photoDesc49, pr.field150 AS photoFile50, pr.field151 AS photoDesc50, p.pic_publish_url, p.pic_publish_dir, p.planId, p.ad_publish_url, p.ad_publish_dir, m.sellertype, m.status, l.*, b.bus_id, b.bus_keyname, b.bus_name, b.bus_website, b.bus_member_level, b.bus_override_price_text, b.isNMEDA, b.bus_override_num_photos, b.bus_override_sliderSize, s.* FROM ( plan_records pr, plans p, amember_member_locations l, amember_members m ) LEFT JOIN amember_member_business b ON b.member_id = pr.uniqueUserId LEFT JOIN amember_member_staff s ON s.location_id = l.loc_id WHERE pr.uniqueUserId = m.member_id AND p.planId=20 AND pr.planId = p.planId AND pr.adStatus='active' AND pr.uniqueId IN (171346) AND pr.uniqueAddress = 'USED-1997-DODGE-DODGE B3500 HIGH TOP PASSENGER VAN W- HANDICAP��LIFT��-HANDICAP-VAN WAGON-FOR-SALE-PHOENIX-ARIZONA-171346' AND pr.extLinkId = l.ext_id AND l.member_id = m.member_id GROUP BY pr.uniqueId ORDER BY pr.date_lastupdate DESC LIMIT 0, 10

[TEP STOP]