Cars in Iowa
Ошибка: Запрос select c._id, c.description, c.blitz, b.title as brand_title, m.title as model_title from ss_cars as c left join ss_cars_models as m on c.folder=m._id left join ss_cars_brands as b on m._master_id=b._id where c._id in (299241,343291,343529,299242,343292,341068,341069,341070,566042,239588,157235,378492,394313,528761,657834,938299,992762,1014660,1014685,472315,1006448,993023,476427,441022,1261890,279091,352000,411541,159707,297362,371015,585787,93365,648914,623244,940254,1163689,17996,251421,352813,548445,548807,688049,719779,766823,804676,843003,991970,1169530,1169693,1169864,1170429,1170649,1171674,1171727,1004080,285408,980316,1135091,1143128) order by c.source_update_time, c._id desc вызвал ошибку Unknown column 'c.source_update_time' in 'order clause'
Array ( [0] => Array ( [file] => /var/www/web/data/www/2040-cars.com/system/lib/db.php [line] => 82 [function] => db_query [args] => Array ( [0] => select c._id, c.description, c.blitz, b.title as brand_title, m.title as model_title from ss_cars as c left join ss_cars_models as m on c.folder=m._id left join ss_cars_brands as b on m._master_id=b._id where c._id in (299241,343291,343529,299242,343292,341068,341069,341070,566042,239588,157235,378492,394313,528761,657834,938299,992762,1014660,1014685,472315,1006448,993023,476427,441022,1261890,279091,352000,411541,159707,297362,371015,585787,93365,648914,623244,940254,1163689,17996,251421,352813,548445,548807,688049,719779,766823,804676,843003,991970,1169530,1169693,1169864,1170429,1170649,1171674,1171727,1004080,285408,980316,1135091,1143128) order by c.source_update_time, c._id desc ) ) [1] => Array ( [file] => /var/www/web/data/www/2040-cars.com/_content/textblocks/text/27/27 [line] => 577 [function] => db_getAssocs [args] => Array ( [0] => select c._id, c.description, c.blitz, b.title as brand_title, m.title as model_title from ss_cars as c left join ss_cars_models as m on c.folder=m._id left join ss_cars_brands as b on m._master_id=b._id where c._id in (299241,343291,343529,299242,343292,341068,341069,341070,566042,239588,157235,378492,394313,528761,657834,938299,992762,1014660,1014685,472315,1006448,993023,476427,441022,1261890,279091,352000,411541,159707,297362,371015,585787,93365,648914,623244,940254,1163689,17996,251421,352813,548445,548807,688049,719779,766823,804676,843003,991970,1169530,1169693,1169864,1170429,1170649,1171674,1171727,1004080,285408,980316,1135091,1143128) order by c.source_update_time, c._id desc ) ) [2] => Array ( [file] => /var/www/web/data/www/2040-cars.com/_content/textblocks/text/50/50 [line] => 179 [function] => get_products_list [args] => Array ( [0] => 0 [1] => [2] => date [3] => [4] => Array ( [0] => State ) [5] => Array ( [0] => Iowa ) [6] => 0 [7] => 60 ) ) [3] => Array ( [file] => /var/www/web/data/www/2040-cars.com/_content/pages/text/36/136_1 [line] => 2 [args] => Array ( [0] => /var/www/web/data/www/2040-cars.com/_content/textblocks/text/50/50 ) [function] => include ) [4] => Array ( [file] => /var/www/web/data/www/2040-cars.com/system/handler/index.php [line] => 375 [args] => Array ( [0] => /var/www/web/data/www/2040-cars.com/_content/pages/text/36/136_1 ) [function] => require ) )
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in /var/www/web/data/www/2040-cars.com/system/lib/db.php on line 84