Array ( [__construct] => Array ( [props] => ) [getList] => Array ( [tblOnEx] => saleItems_p [tblOnQue] => saleItems_p [props] => Array ( ) [cagID] => 0 [cityID] => [clauses] => [sql] => SELECT s.*, u.NAME as userName, u.LAST_NAME as userLName, city.name as cityName, sh.addr as shopAddress, sh.place as place, p.article as prodArt, p.title as prodTitle, p.text as prodText, f.path as prodImg, COALESCE((SELECT path FROM files WHERE id = (SELECT picID FROM saleImgs_p WHERE saleItemID = s.publID ORDER BY sort ASC LIMIT 1)), f.path) as img FROM saleItems_p as s LEFT JOIN b_user as u ON s.userID = u.ID LEFT JOIN city ON city.city_id = s.cityID LEFT JOIN shops as sh ON sh.id = s.shopID LEFT JOIN products as p ON p.id = s.modelID LEFT JOIN files as f ON f.id = p.picID ) )