public static void ReGenerateEntireTree()
       {
           DataTable Table = SelectQuery("SELECT id_category, id_parent FROM ps_category ORDER BY id_parent ASC, position ASC");
           Dictionary<int, int> categoryArray = new Dictionary<int,int>();

public static function regenerateEntireNtree()
	{
		$categories = Db::getInstance()->ExecuteS('SELECT

xml.Load(TempFolder + "xl\\worksheets\\sheet1.xml");
XmlNodeList elemList

<pre><a class="show_hide" href="#" rel="#slidingDiv_x">View</a></pre><div id="slidingDiv_x" class="toggleDiv" style="display: none;">

...LEFT OUTER JOIN
  (SELECT id, onze_prijs, producten_id, verwijderings_bijdrage_id
                            FROM(SELECT MAX(id) as maxid
                            FROM(producten_prijzen)
                                  GROUP BY producten_id)
                             AS x
     INNER JOIN producten_prijzen

SELECT p.id, artikel, merk, type, onze_prijs, garantie, verwijderings_bijdrage.bedrag,
                            (producten_historie.aantal_ingekocht - (p.uitgeleend + p.reparatie) - producten_historie.aantal_verkocht) AS Stock
                            FROM producten as p 
                            INNER JOIN

Table structure:
products:
ID               int(3) PK
Description     text
value           varchar(250)
lokation

Dim Sql as String
Sql = "SELECT workorder.ID, merk.merk, type.type, workorder.klacht, CONCAT('€', CONVERT(workorder.totaal, CHAR)) AS totaal
              FROM workorder
              INNER JOIN merk ON workorder.merk_id = merk.id
              INNER JOIN type ON workorder.type_id

    SELECT verkoop_order.sub_totaal, verkoop_order.btw_percentage, verkoop_order.btw_bedrag, verkoop_order.verzendkosten,
                    verkoop_order.datum_verkoop, verkoop.artikel_groep, verkoop.Omschrijving,
                    verwijderings_bijdrage.bedrag AS verwijderingsbijdrage, verkoop.Aantal, (
   SELECT prijs

quantity    description    price
1           Laser          99,-
1           Laser          99,-
1           Led effect     79,-

quantity    description

ID  product_id   price
1       1        99,-
2       1        79,-
3       1        89,-
4       2        40,-

product_id     make_id     type_id      category_id
1              1           3            1
2              2           4            7

Make              quantity      price

SELECT verkoop_order.sub_totaal,

SELECT id, companyname, city FROM crediteuren 
WHERE ( companyname LIKE '%Someon%' ) OR (city LIKE '%Someon%' )
ORDER BY companyname

SELECT id, companyname, city FROM crediteuren 
WHERE ( companyname LIKE '%someon%' ) OR (city LIKE '%someon%' )
ORDER