{"status":"error","error":"query_failed","query":"SELECT SQL_CALC_FOUND_ROWS\r\n\t\t\tproducts.id,products.code,products.typeid,products.collectionid,poemid,\r\n\t\t\tproducts.price_retail,products.price_retail_discount,products.price_wholesale,products.days_default as days,products.title_en as title,\r\n\t\t\tgroup_concat(distinct pictures.id,'^',pictures.safename,'^',pictures.extension order by pictures.picturetypeid desc,pictureorder asc separator '|') as pics,\r\n\t\t\tgroup_concat(products_versions.id) as vers,\r\n\t\t\tproducts.soldout,products.newin\r\n\t\tfrom products\r\n\t\t\t\tleft join products_versions on (products.id=products_versions.productid)\r\n\t\t\t\t,pictures\r\n\t\twhere 1=1 and products.active_el=1 and price_retail>0\r\n\t\t\tand products.active_el=1\r\n\t\t\tand pictures.articleid=products.id and pictures.type=2\r\n\t\t\t   and products.collectionid=12  \r\n\t\tgroup by products.id\r\n\t\torder by  \r\n\t\t\tif(products.soldout,2,1),\r\n\t\tprice_retail asc,products.code desc\r\n\t\tlimit -15,15","dberrno":null,"dberror":null}