MYSQL CLIENT ERROR : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'saleProducts.refImages' in 'where clause' // SELECT id,rank,parentId,name_en,name_fr,name_de,name_nl,name_hu,name_it,name_pl,name_es,name_pt,name_ro,name_cz,name_sk,status,tags,dateInsert,dateUpdate,author,lastAuthor,authorId,lastAuthorId,serial,data,urlKey_en,urlKey_fr,urlKey_de,urlKey_nl,urlKey_hu,urlKey_it,urlKey_pl,urlKey_es,urlKey_pt,urlKey_ro,urlKey_cz,urlKey_sk,link,isToRegister,metaTitle_en,metaTitle_fr,metaTitle_de,metaTitle_nl,metaTitle_hu,metaTitle_it,metaTitle_pl,metaTitle_es,metaTitle_pt,metaTitle_ro,metaTitle_cz,metaTitle_sk,metaDesc_en,metaDesc_fr,metaDesc_de,metaDesc_nl,metaDesc_hu,metaDesc_it,metaDesc_pl,metaDesc_es,metaDesc_pt,metaDesc_ro,metaDesc_cz,metaDesc_sk,(SELECT image FROM productImageGalleries WHERE ref=saleProducts.refImages) AS image,description_en,description_fr,description_de,description_nl,description_hu,description_it,description_pl,description_es,description_pt,description_ro,description_cz,description_sk,shortDescription_en,shortDescription_fr,shortDescription_de,shortDescription_nl,shortDescription_hu,shortDescription_it,shortDescription_pl,shortDescription_es,shortDescription_pt,shortDescription_ro,shortDescription_cz,shortDescription_sk,categoryId,(saleProducts.ref) AS sku,purchasePrice,price,discount,productType,weight,stock,canBeOrderedOutOfStock,shippingDelayOutOfStock,shippingDelayInStock,ean,ref,refImages,refData,refTechnicalSheet,refInstructionSheet,(SELECT id FROM saleProductDatas WHERE ref=saleProducts.refData) AS saleProductData,(SELECT ROUND(SUM(rating)/COUNT(*),1) FROM customerReviews WHERE ref=saleProducts.refData AND customerReviews.dateInsert < CURDATE()) AS averageRating,(SELECT COUNT(*) FROM customerReviews WHERE ref=saleProducts.refData AND customerReviews.dateInsert < CURDATE()) AS numberRatings,(SELECT id FROM technicalSheets WHERE ref=saleProducts.refTechnicalSheet) AS technicalSheet,(SELECT id FROM instructionSheets WHERE ref=saleProducts.refInstructionSheet) AS instructionSheet,bestSeller,saleCategory,composition,optionProducts,substitutionProducts,brand,(SELECT secondaryImages FROM productImageGalleries WHERE ref=saleProducts.refImages) AS otherImages,(SELECT videos FROM productImageGalleries WHERE ref=saleProducts.refImages) AS videos,(SELECT videoFiles FROM productImageGalleries WHERE ref=saleProducts.refImages) AS videoFiles,grossWeight,netWeight,width,length,height,shippingTime,(SELECT GROUP_CONCAT(DISTINCT(SELECT name_en FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) AS orderChannels,(SELECT GROUP_CONCAT(DISTINCT(SELECT image FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) AS orderChannelsLogos,stockEU,normalPrice,discountPrice,netPrice,publicPrice,hasOptions,features FROM saleProducts WHERE (ref IN (SELECT ref FROM saleProducts WHERE refData IN (SELECT ref FROM saleProductDatas WHERE urlKey2_en LIKE 'catalog' OR urlKey_en LIKE 'catalog')) AND (SELECT GROUP_CONCAT(DISTINCT(SELECT name_en FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) LIKE '%Netsportique website%') AND (status=1) ORDER BY ref ASC LIMIT 20 OFFSET 0
Notice: Trying to get property 'data' of non-object in /application/specific/classes/saleProduct.php on line 649

Warning: Invalid argument supplied for foreach() in /application/specific/classes/saleProduct.php on line 651

Warning: Cannot modify header information - headers already sent by (output started at /application/specific/clients/mysqlConnection.php:116) in /application/specific/classes/app.php on line 774

Warning: Cannot modify header information - headers already sent by (output started at /application/specific/clients/mysqlConnection.php:116) in /application/specific/classes/app.php on line 782