Einzelne Abfragen zu einer für CSV Export

[kosovafan]

Hallo,

ich rufe bisher immer die Datenbank 3 x ab und erstelle mir daraus eine CSV Datei.

SELECT
    products_id as ArtID,
    products_model as Artikelnummer,
    products_ean as EAN,
    products_sort as "Master Sort",
    products_master_slave_order as "Int. Sort",
    products_vpe_value as VPE,
    products_price as "VK Netto",
    products_weight as Gewicht,
    products_shippingtime as Lieferzeit,
    products_image as Bild1,
    products_status as Status,
    disabled_shippings as Spedition
FROM xt_products;

SELECT
    products_id as ArtID,
    products_name as Artikelname,
    products_short_description as Kurzbeschreibung,
    products_description as Beschreibung,
    products_keywords as "Keyword Suche"
FROM xt_products_description;

SELECT
    link_id as ArtID,
    url_text as url_text,
    meta_title as "Meta Title 55-60",
    meta_description as "Meta Description 150"
FROM xt_seo_url WHERE `link_type` = 1;

Wie könnte man die Abfragen zusammenbringen so das daraus das im Anhang befindliche Template über PHPMYADMIN heruntergeladen werden kann? Würde mich sehr über Hilfe freuen.

Mfg & Danke
Silvio

 

[Yaslaw]

Klassiker. Ein JOIN. Den solltest du lernen, das ist die Grundlage von SQL. Anleitungen dazu gibt es Tausende.

SELECT
    p.products_id as ArtID,
    p.products_model as Artikelnummer,
    p.products_ean as EAN,
    p.products_sort as "Master Sort",
    p.products_master_slave_order as "Int. Sort",
    p.products_vpe_value as VPE,
    p.products_price as "VK Netto",
    p.products_weight as Gewicht,
    p.products_shippingtime as Lieferzeit,
    p.products_image as Bild1,
    p.products_status as Status,
    p.disabled_shippings as Spedition,
    d.products_name as Artikelname,
    d.products_short_description as Kurzbeschreibung,
    d.products_description as Beschreibung,
    d.products_keywords as "Keyword Suche",
    u.url_text as url_text,
    u.meta_title as "Meta Title 55-60",
    u.meta_description as "Meta Description 150"
FROM 
    xt_products p
    left join xt_products_description d on p.products_id = d.products_id
    left join xt_seo_url u on p.products_id = u.link_id

 

[kosovafan]

Danke klappt er gibt die Werte zwar doppelt bis dreifach aus, weil link_id noch rein muss aber das wird sich lösen.

Vielen Dank.
Silvio