#1064 - Something is wrong in your syntax obok 'FROM posts P INNER JOIN postmeta M ON P.ID=M.post_id WHERE M.meta_key ' w linii 3
#1064 - Something is wrong in your syntax obok 'CHAR(10))) FROM posts P INNER JOIN postmeta M ON P.ID=M.post_id W' w linii 2
SELECT CONCAT( P.POST_CONTENT, GROUP_CONCAT(M.meta_value ORDER BY M.meta_id SEPARATOR 'CHAR(10)')) FROM posts P INNER JOIN postmeta M ON P.ID=M.post_id WHERE M.meta_key = 'wpcf-obrazek' GROUP BY P.ID
UPDATE P, M SET P.post_excerpt = CONCAT( P.POST_CONTENT, GROUP_CONCAT(M.meta_value ORDER BY M.meta_id SEPARATOR 'CHAR(10)')) FROM posts P INNER JOIN postmeta M ON P.ID=M.post_id WHERE M.meta_key = 'wpcf-obrazek' GROUP BY P.ID
SELECT DISTINCT twr_kod, twr_nazwa, twr_numerkat, twr_koddostawcy, knt_kod, twr_iloscmin, twi_ilosc, twi_rezerwacje, twi_zamowienia, twi_dataFROM ( SELECT TwrI_TwrId, MAX(twi_data) AS twi_data FROM XL.TwrIlosci GROUP BY TwrI_TwrId) AS A RIGHT JOIN XL.TwrIlosci AS B ON A.TwrI_TwrId = B.TwrI_TwrId AND A.twi_data = B.twi_data) AS TWI INNER JOIN XL.TOWARY AS TWR ON TWR.Twr_TwrId = TWI.TwI_TwrId INNER JOIN XL.Kontrahenci AS K ON TWR.twr_kntid = K.knt_kntid