Expression #1 of ORDER BY clause is not in SELECT list, references column 'salontocviet_vn.restaurant.is_promoted' which is not in SELECT list; this is incompatible with DISTINCT in SELECT distinct fr.id, fr.name FROM `restaurant`, food_res AS fr WHERE brand_did IN (1,2,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,32,33,34,39,40,41,42) AND is_active = 1 AND restaurant.id = fr.rid ORDER BY is_promoted DESC

array (
  0 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/modules/CityRestaurant/forms/list.php',
    'line' => 134,
    'function' => 'query',
    'class' => 'DB',
    'type' => '::',
    'args' => 
    array (
      0 => 'SELECT distinct fr.id, fr.name FROM `restaurant`, food_res AS fr WHERE  brand_did IN (1,2,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,32,33,34,39,40,41,42) AND is_active = 1  AND restaurant.id = fr.rid ORDER BY is_promoted DESC',
    ),
  ),
  1 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/Form.php',
    'line' => 187,
    'function' => 'draw',
    'class' => 'CityRestaurantForm',
    'object' => 
    CityRestaurantForm::__set_state(array(
       'name' => false,
       'error_messages' => false,
       'succes_messages' => false,
       'errNum' => 0,
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  2 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/Module.php',
    'line' => 27,
    'function' => 'on_draw',
    'class' => 'Form',
    'object' => 
    CityRestaurantForm::__set_state(array(
       'name' => false,
       'error_messages' => false,
       'succes_messages' => false,
       'errNum' => 0,
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  3 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/Module.php',
    'line' => 33,
    'function' => 'draw',
    'class' => 'Module',
    'object' => 
    CityRestaurant::__set_state(array(
       'data' => 
      array (
        'id' => '49786',
        'module_id' => '5757',
        'region' => 'center',
        'module' => 
        array (
          'id' => '5757',
          'name' => 'CityRestaurant',
        ),
      ),
       'forms' => 
      array (
        0 => 
        CityRestaurantForm::__set_state(array(
           'name' => false,
           'error_messages' => false,
           'succes_messages' => false,
           'errNum' => 0,
        )),
      ),
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  4 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/_cache/pages/city_list.php',
    'line' => 22,
    'function' => 'on_draw',
    'class' => 'Module',
    'object' => 
    CityRestaurant::__set_state(array(
       'data' => 
      array (
        'id' => '49786',
        'module_id' => '5757',
        'region' => 'center',
        'module' => 
        array (
          'id' => '5757',
          'name' => 'CityRestaurant',
        ),
      ),
       'forms' => 
      array (
        0 => 
        CityRestaurantForm::__set_state(array(
           'name' => false,
           'error_messages' => false,
           'succes_messages' => false,
           'errNum' => 0,
        )),
      ),
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  5 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/EnBac.php',
    'line' => 33,
    'args' => 
    array (
      0 => '/data/html/salontocviet/public_html/salon/_cache/pages/city_list.php',
    ),
    'function' => 'require_once',
  ),
  6 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/index.php',
    'line' => 47,
    'function' => 'Run',
    'class' => 'EnBac',
    'type' => '::',
    'args' => 
    array (
    ),
  ),
)