How to write sql for zend 3?
0
How to write sql for zend 3?
I can not do it.
select email as publihser_email, phone_number as publisher_phone_number, CONCAT(first_name,' ',last_name) as publisher_name
from users
where id in(
select distinct publisher_id from apartments where publisher_type=0
)
UNION
select email as publihser_email, phone_number as publisher_phone_number, name as publisher_name
from organizations
where id in(
select distinct publisher_id from apartments where publisher_type=1
);
sql zend-framework
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
asked Nov 19 '18 at 8:49
KarenKaren
813
add a comment |
0
How to write sql for zend 3?
I can not do it.
select email as publihser_email, phone_number as publisher_phone_number, CONCAT(first_name,' ',last_name) as publisher_name
from users
where id in(
select distinct publisher_id from apartments where publisher_type=0
)
UNION
select email as publihser_email, phone_number as publisher_phone_number, name as publisher_name
from organizations
where id in(
select distinct publisher_id from apartments where publisher_type=1
);
sql zend-framework
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
asked Nov 19 '18 at 8:49
KarenKaren
813
add a comment |
0
0
0
How to write sql for zend 3?
I can not do it.
select email as publihser_email, phone_number as publisher_phone_number, CONCAT(first_name,' ',last_name) as publisher_name
from users
where id in(
select distinct publisher_id from apartments where publisher_type=0
)
UNION
select email as publihser_email, phone_number as publisher_phone_number, name as publisher_name
from organizations
where id in(
select distinct publisher_id from apartments where publisher_type=1
);
sql zend-framework
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
asked Nov 19 '18 at 8:49
KarenKaren
813
How to write sql for zend 3?
I can not do it.
select email as publihser_email, phone_number as publisher_phone_number, CONCAT(first_name,' ',last_name) as publisher_name
from users
where id in(
select distinct publisher_id from apartments where publisher_type=0
)
UNION
select email as publihser_email, phone_number as publisher_phone_number, name as publisher_name
from organizations
where id in(
select distinct publisher_id from apartments where publisher_type=1
);
sql zend-framework
sql zend-framework
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
asked Nov 19 '18 at 8:49
KarenKaren
813
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
asked Nov 19 '18 at 8:49
KarenKaren
813
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
edited Nov 19 '18 at 8:50
jarlh
29.1k52138
29.1k52138
asked Nov 19 '18 at 8:49
KarenKaren
813
asked Nov 19 '18 at 8:49
KarenKaren
813
asked Nov 19 '18 at 8:49
KarenKaren
813
813
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
0
$select_wherein2 = new Select('apartments');
$select_wherein2
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 1]);
$select2 = new Select('organizations');
$select2
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => 'name'])
->where->in('id',$select_wherein2);
$select_wherein = new Select('apartments');
$select_wherein
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 0]);
$select = new Select('users');
$select
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => new Expression("CONCAT(first_name,' ',last_name)")])
->where
->in('id',$select_wherein);
$select->combine($select2);
//TEST
echo $select->getSqlString($db->getPlatform());
RESULT:
( SELECT `users`.`email` AS `publihser_email`, `users`.`phone_number` AS `publisher_phone_number`, CONCAT(first_name,' ',last_name) AS `publisher_name` FROM `users` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '0') ) UNION ( SELECT `organizations`.`email` AS `publihser_email`, `organizations`.`phone_number` AS `publisher_phone_number`, `organizations`.`name` AS `publisher_name` FROM `organizations` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '1') )
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371089%2fhow-to-write-sql-for-zend-3%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
$select_wherein2 = new Select('apartments');
$select_wherein2
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 1]);
$select2 = new Select('organizations');
$select2
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => 'name'])
->where->in('id',$select_wherein2);
$select_wherein = new Select('apartments');
$select_wherein
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 0]);
$select = new Select('users');
$select
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => new Expression("CONCAT(first_name,' ',last_name)")])
->where
->in('id',$select_wherein);
$select->combine($select2);
//TEST
echo $select->getSqlString($db->getPlatform());
RESULT:
( SELECT `users`.`email` AS `publihser_email`, `users`.`phone_number` AS `publisher_phone_number`, CONCAT(first_name,' ',last_name) AS `publisher_name` FROM `users` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '0') ) UNION ( SELECT `organizations`.`email` AS `publihser_email`, `organizations`.`phone_number` AS `publisher_phone_number`, `organizations`.`name` AS `publisher_name` FROM `organizations` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '1') )
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
add a comment |
0
$select_wherein2 = new Select('apartments');
$select_wherein2
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 1]);
$select2 = new Select('organizations');
$select2
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => 'name'])
->where->in('id',$select_wherein2);
$select_wherein = new Select('apartments');
$select_wherein
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 0]);
$select = new Select('users');
$select
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => new Expression("CONCAT(first_name,' ',last_name)")])
->where
->in('id',$select_wherein);
$select->combine($select2);
//TEST
echo $select->getSqlString($db->getPlatform());
RESULT:
( SELECT `users`.`email` AS `publihser_email`, `users`.`phone_number` AS `publisher_phone_number`, CONCAT(first_name,' ',last_name) AS `publisher_name` FROM `users` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '0') ) UNION ( SELECT `organizations`.`email` AS `publihser_email`, `organizations`.`phone_number` AS `publisher_phone_number`, `organizations`.`name` AS `publisher_name` FROM `organizations` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '1') )
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
add a comment |
0
0
0
$select_wherein2 = new Select('apartments');
$select_wherein2
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 1]);
$select2 = new Select('organizations');
$select2
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => 'name'])
->where->in('id',$select_wherein2);
$select_wherein = new Select('apartments');
$select_wherein
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 0]);
$select = new Select('users');
$select
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => new Expression("CONCAT(first_name,' ',last_name)")])
->where
->in('id',$select_wherein);
$select->combine($select2);
//TEST
echo $select->getSqlString($db->getPlatform());
RESULT:
( SELECT `users`.`email` AS `publihser_email`, `users`.`phone_number` AS `publisher_phone_number`, CONCAT(first_name,' ',last_name) AS `publisher_name` FROM `users` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '0') ) UNION ( SELECT `organizations`.`email` AS `publihser_email`, `organizations`.`phone_number` AS `publisher_phone_number`, `organizations`.`name` AS `publisher_name` FROM `organizations` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '1') )
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
$select_wherein2 = new Select('apartments');
$select_wherein2
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 1]);
$select2 = new Select('organizations');
$select2
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => 'name'])
->where->in('id',$select_wherein2);
$select_wherein = new Select('apartments');
$select_wherein
->quantifier(Select::QUANTIFIER_DISTINCT)
->columns(['publisher_id'])
->where(['publisher_type' => 0]);
$select = new Select('users');
$select
->columns([
'publihser_email' => 'email',
'publisher_phone_number' => 'phone_number',
'publisher_name' => new Expression("CONCAT(first_name,' ',last_name)")])
->where
->in('id',$select_wherein);
$select->combine($select2);
//TEST
echo $select->getSqlString($db->getPlatform());
RESULT:
( SELECT `users`.`email` AS `publihser_email`, `users`.`phone_number` AS `publisher_phone_number`, CONCAT(first_name,' ',last_name) AS `publisher_name` FROM `users` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '0') ) UNION ( SELECT `organizations`.`email` AS `publihser_email`, `organizations`.`phone_number` AS `publisher_phone_number`, `organizations`.`name` AS `publisher_name` FROM `organizations` WHERE `id` IN (SELECT DISTINCT `apartments`.`publisher_id` AS `publisher_id` FROM `apartments` WHERE `publisher_type` = '1') )
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
answered Nov 19 '18 at 14:24
Xuan ThuXuan Thu
6914
6914
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371089%2fhow-to-write-sql-for-zend-3%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
