mysql - Operand should contain 1 column(s) when selecting data from another table AS value -


can 1 please me here, ive googled, , looked @ other examples error confuses me , cant seem head around this.

im struggling selecting data else in mysql query im getting following error...

operand should contain 1 column(s)

what simplified term operand?

below mysql query...

select atable_garage.id,         atable_garage.total_votes num_votes,        atable_garage.name,         atable_garage.address,         atable_garage.city,         atable_garage.postcode,         atable_garage.main_dealer,         atable_garage.phone,         atable_garage.website,         atable_garage.description,         atable_garage.years_in_business,        atable_garage.garage_image,          (select(avg(quality_of_repair) + avg(attitude_of_staff) + avg(overall_satisfaction))/3 rating,                 count(*) num_votes            atable_feedback           validated = 'y'            , atable_garage.id = garage_id)    `atable_garage`  valeting = 'y'     , active = 'y'  order rating desc, atable_garage.total_votes desc

can point out i've done wrong here? , if possible explain i'm finding difficult head around 1 in advance.

the correlated subquery can return 1 column @ time. since want have 2 column, can restrusture query converting left join.

select  atable_garage.id,          atable_garage.total_votes num_votes,         atable_garage.name,          atable_garage.address,          atable_garage.city,          atable_garage.postcode,          atable_garage.main_dealer,          atable_garage.phone,          atable_garage.website,          atable_garage.description,          atable_garage.years_in_business,         atable_garage.garage_image,           coalesce(b.rating, 0) rating,         coalesce(b.num_votes, 0) num_votes    atable_garage         left join         (             select  garage_id,                     (avg(quality_of_repair) + avg(attitude_of_staff) + avg(overall_satisfaction)) / 3.0 rating,                      count(*) num_votes                 atable_feedback                validated = 'y'             group    garage_id         ) b on  atable_garage.id = b.garage_id   valeting = 'y' , active = 'y'  order   rating desc,          atable_garage.total_votes desc

Comments

Post a Comment

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

i force app's home screen portrait , other views landscape. apple rejects app if this? if not , how force first screen launch in portrait mode? , force other screens launch in landscape. this not duplicate question search every possible answer in website. i force app's home screen portrait , other views landscape. apple rejects app if this? no apple not reject app this. have lot of apps doesn't support orientation. forcing on 1 screen won't cause app reject. if not , how force first screen launch in portrait mode? , force other screens launch in landscape. can on write : -(nsuinteger)supportedinterfaceorientations; function.
Read more

java Extracting Zip file -

i'm looking way extract zip file. far have tried java.util.zip , org.apache.commons.compress, both gave corrupted output. basically, input zip file contain 1 single .doc file. java.util.zip: output corrupted. org.apache.commons.compress: output blank file, 2 mb size. so far commercial software winrar work perfectly. there java library make use of this? this method using java.util library: public void extractzipnative(file filezip) { zipinputstream zis; stringbuilder sb; try { zis = new zipinputstream(new fileinputstream(filezip)); zipentry ze = zis.getnextentry(); byte[] buffer = new byte[(int) ze.getsize()]; fileoutputstream fos = new fileoutputstream(this.tempfolderpath+ze.getname()); int len; while ((len=zis.read(buffer))>0) { fos.write(buffer); } fos.flush(); fos.close(); } catch (filenotfoundexception e) { // todo auto-generated catch block ...
Read more

C# WinForm - loading screen -

i ask how make loading screen (just picture or something) appears while program being loaded, , disappears when program has finished loading. in fancier versions, have seen process bar (%) displayed. how can have that, , how calculate % show on it? i know there form_load() event, not see form_loaded() event, or % property / attribute anywhere. all need create 1 form splash screen , show before main start showing landing page , close splash once landing page loaded. class splashform { //delegate cross thread call close private delegate void closedelegate(); //the type of form displayed splash screen. private static splashform splashform; static public void showsplashscreen() { // make sure launched once. if (splashform != null) return; thread thread = new thread(new threadstart(splashform.showform)); thread.isbackground = true; thread.setapartmentstate(apartmentstate.sta); thread....
Read more