Site Tools


traders:lionheart

Lionheart Trains

This company has been taken over by Dapol where the models offered can be found.

SQL Server
DRIVER={SQL Server};SERVER=sql11.hostinguk.net;DATABASE=gaugegu1_gog2;UID=gaugegog1;PWD=g2Fr8*r6=yN-_4DUs$z!45;

Lionheart TrainsRichard Webster
Gledrid Industrial Park01691 774455
Chirk
LL14 5DGEmail: sales@dapol.co.uk
Web: http://www.lionhearttrains.com

Related articles:

Product categories produced by Lionheart Trains as listed in the Guild's product directory:
DRIVER={SQL Server};SERVER=sql11.hostinguk.net;DATABASE=gaugegu1_gog2;UID=gaugegog1;PWD=g2Fr8*r6=yN-_4DUs$z!45;
SELECT gaugegog1.Product_types_tbl.Product_type AS prx, gaugegog1.Categories_tbl.Category AS Cat, gaugegog1.sub_categories_tbl.Category AS scat FROM gaugegog1.sub_categories_tbl INNER JOIN (gaugegog1.Product_types_tbl INNER JOIN (gaugegog1.Categories_tbl INNER JOIN gaugegog1.Products_tbl ON gaugegog1.Categories_tbl.id = gaugegog1.Products_tbl.Category) ON gaugegog1.Product_types_tbl.id = gaugegog1.Products_tbl.Product_type) ON gaugegog1.sub_categories_tbl.id = gaugegog1.Products_tbl.Sub_cat GROUP BY gaugegog1.Product_types_tbl.Product_type, gaugegog1.Categories_tbl.Category, gaugegog1.sub_categories_tbl.Category, gaugegog1.Products_tbl.tcode, gaugegog1.Products_tbl.Product_type, gaugegog1.Products_tbl.Category, gaugegog1.Products_tbl.Sub_cat HAVING ((gaugegog1.Products_tbl.tcode)='LIONH') ORDER BY gaugegog1.Product_types_tbl.Product_type, gaugegog1.Categories_tbl.Category, gaugegog1.sub_categories_tbl.Category

traders/lionheart.txt · Last modified: 2021/02/08 10:34 by 127.0.0.1