Selecteer nu een GSM! Kies hieronder een mobiele telefoon die samengaat met je abonnement.
0 AND has_retlinks > 0 AND eigenschap_nr = 37 AND landencode = "NL" AND type_nr = 1 ' . 'GROUP BY toestel_nr '; // Add sorting switch ($sort) { case 2: $query .= 'ORDER BY ppm, sales DESC, prodName'; break; case 3: $query .= 'ORDER BY datum_verkrijgbaar DESC, sales DESC, prodName'; break; case 4: $query .= 'ORDER BY prodName, sales DESC'; break; case 5: $query = 'SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr, NULL AS ppm FROM `Toestel` INNER JOIN `Merk` USING (merk_nr) INNER JOIN `Toestel_eigenschap` USING (toestel_nr) WHERE categorie_nr = 1 AND verkrijgbaar_nr = 7 AND eigenschap_nr = 37 GROUP BY toestel_nr ORDER BY sales DESC, prodName'; break; default: $query .= 'ORDER BY sales DESC, prodName'; break; } $rows = $db->fetchAll($query); ?>