You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY prc_id ORDER BY prc_price ASC LIMIT 1' at line 1
SELECT prc_id FROM shop_prices WHERE prc_prodID = GROUP BY prc_id ORDER BY prc_price ASC LIMIT 1
array(4) {
  [0]=>
  array(4) {
    ["file"]=>
    string(87) "/data/vhosts/lovelyandco.co.uk/httpdocs/admin/extensions/shop/classes/class.product.php"
    ["line"]=>
    int(547)
    ["function"]=>
    string(7) "dbQuery"
    ["args"]=>
    array(1) {
      [0]=>
      string(97) "SELECT prc_id FROM shop_prices WHERE prc_prodID =  GROUP BY prc_id ORDER BY prc_price ASC LIMIT 1"
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(78) "/data/vhosts/lovelyandco.co.uk/httpdocs/site/includes/content-shop_product.php"
    ["line"]=>
    int(13)
    ["function"]=>
    string(10) "get_prices"
    ["class"]=>
    string(7) "product"
    ["object"]=>
    object(product)#10 (55) {
      ["id"]=>
      NULL
      ["dateAdded"]=>
      NULL
      ["dateModified"]=>
      NULL
      ["sectionID"]=>
      NULL
      ["title"]=>
      NULL
      ["slug"]=>
      NULL
      ["summary"]=>
      NULL
      ["desc"]=>
      NULL
      ["tags"]=>
      NULL
      ["colour1"]=>
      NULL
      ["colour2"]=>
      NULL
      ["colour3"]=>
      NULL
      ["ss_img"]=>
      NULL
      ["show_ss"]=>
      NULL
      ["expired"]=>
      NULL
      ["available"]=>
      NULL
      ["pos"]=>
      NULL
      ["active"]=>
      NULL
      ["vat"]=>
      NULL
      ["featured"]=>
      NULL
      ["featuredPos"]=>
      NULL
      ["ship_choice"]=>
      NULL
      ["shipping"]=>
      NULL
      ["ship_selected"]=>
      NULL
      ["ship_insurance"]=>
      NULL
      ["thumbnail"]=>
      NULL
      ["code"]=>
      NULL
      ["unit_term"]=>
      NULL
      ["option_label"]=>
      NULL
      ["option2_label"]=>
      NULL
      ["option3_label"]=>
      NULL
      ["option4_label"]=>
      NULL
      ["cost"]=>
      NULL
      ["info_req"]=>
      NULL
      ["info_label"]=>
      NULL
      ["archived"]=>
      NULL
      ["base_price"]=>
      NULL
      ["base_sale_price"]=>
      NULL
      ["size_req"]=>
      NULL
      ["col_req"]=>
      NULL
      ["option_req"]=>
      NULL
      ["option2_req"]=>
      NULL
      ["option3_req"]=>
      NULL
      ["option4_req"]=>
      NULL
      ["turnaround"]=>
      NULL
      ["shipping_cat"]=>
      NULL
      ["option_desc"]=>
      NULL
      ["option2_desc"]=>
      NULL
      ["option3_desc"]=>
      NULL
      ["option4_desc"]=>
      NULL
      ["images"]=>
      NULL
      ["stock"]=>
      NULL
      ["trans_id"]=>
      NULL
      ["lang":"product":private]=>
      string(2) "en"
      ["sale_item"]=>
      bool(false)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &array(3) {
        ["orderby"]=>
        string(9) "prc_price"
        ["sort"]=>
        string(3) "ASC"
        ["limit"]=>
        string(1) "1"
      }
    }
  }
  [2]=>
  array(4) {
    ["file"]=>
    string(54) "/data/vhosts/lovelyandco.co.uk/httpdocs/site/index.php"
    ["line"]=>
    int(228)
    ["args"]=>
    array(1) {
      [0]=>
      string(78) "/data/vhosts/lovelyandco.co.uk/httpdocs/site/includes/content-shop_product.php"
    }
    ["function"]=>
    string(7) "include"
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(49) "/data/vhosts/lovelyandco.co.uk/httpdocs/index.php"
    ["line"]=>
    int(2)
    ["args"]=>
    array(1) {
      [0]=>
      string(54) "/data/vhosts/lovelyandco.co.uk/httpdocs/site/index.php"
    }
    ["function"]=>
    string(12) "include_once"
  }
}