Problem with SELECT for Multisite

  • Anderson Narciso

    (@andersonnarciso)


    8 years, 3 months ago

    Hi guys!

    Guys, why my select dont work? 🙁

    $select .= "
SELECT
ID as id,
(SELECT blog_id FROM wp_blogs WHERE site_id = '1') AS blogid,
FROM
wp_9_posts
WHERE
post_status = 'publish' AND
post_type = 'sites'
";

    Other option that I’ve tested and also do not work:

    (SELECT blog_id FROM wp_blogs WHERE domain != 'site.com') AS blogid

    If I put domain = ‘site.com’ works, if I put != ‘site.com’ doesn’t work

    I’m not very good with selects..

Viewing 1 replies (of 1 total)
  • Thread Starter Anderson Narciso

    (@andersonnarciso)

    8 years, 3 months ago

    Other option that I’ve tested and also do not work

    (SELECT blog_id FROM wp_blogs WHERE domain = (SELECT option_value FROM wp_options WHERE option_name = 'siteurl')) AS blogid,

Viewing 1 replies (of 1 total)
  • The topic ‘Problem with SELECT for Multisite’ is closed to new replies.

Tags