Znajdź zawartość
Nie powiem
Witam
Proszę o podpowiedź jak do tego zapytania dodać numer telefonu klienta.
SELECT
c.`id_customer` AS `id_customer`, `id_gender`, `firstname`, `lastname`, c.`email` AS `email`, `birthday`, `date_add`, c.`active` AS `active`
, c.*, a.id_group
FROM `rk_customer_group` a
LEFT JOIN `rk_customer` c ON (a.`id_customer` = c.`id_customer`)
WHERE 1 AND a.`id_group` = 4 AND c.`deleted` != 1 AND c.id_shop IN (1)
ORDER BY `id_group` ASC
