Not getting all the products after executing my query (they appear in the application)
Yesterday i tried to obtain all products from MAGENTO database. I did
a query and i thought it was working BUT i was wrong.
I put a random SKU in the MAGENTO application, then i clicked on "search" and the product appeared but that SKU did not apprear in my query:
This is my query:
SELECT main.sku, code_brand.value AS code_brand,option_value_brand.value
FROM catalog_product_entity AS main
LEFT JOIN catalog_product_entity_int AS code_brand ON main.entity_id = code_brand.entity_id
JOIN eav_attribute_option option_brand on option_brand.attribute_id = code_brand.attribute_id and option_brand.option_id = code_brand.value
JOIN eav_attribute_option_value option_value_brand on option_brand.option_id = option_value_brand.option_id
WHERE code_brand.attribute_id = (
SELECT attribute_id
FROM eav_attribute
WHERE attribute_code LIKE 'code_brand'
AND `entity_type_id` = (
SELECT entity_type_id
FROM eav_entity_type
WHERE entity_type_code = 'catalog_product'
)
);
Whats going on here?
Can please help me to obtain ALL the products?
What should i modify?
magento-1.9
asked 34 secs ago
programming_amazingprogramming_amazing
245
add a comment |
Yesterday i tried to obtain all products from MAGENTO database. I did
a query and i thought it was working BUT i was wrong.
I put a random SKU in the MAGENTO application, then i clicked on "search" and the product appeared but that SKU did not apprear in my query:
This is my query:
SELECT main.sku, code_brand.value AS code_brand,option_value_brand.value
FROM catalog_product_entity AS main
LEFT JOIN catalog_product_entity_int AS code_brand ON main.entity_id = code_brand.entity_id
JOIN eav_attribute_option option_brand on option_brand.attribute_id = code_brand.attribute_id and option_brand.option_id = code_brand.value
JOIN eav_attribute_option_value option_value_brand on option_brand.option_id = option_value_brand.option_id
WHERE code_brand.attribute_id = (
SELECT attribute_id
FROM eav_attribute
WHERE attribute_code LIKE 'code_brand'
AND `entity_type_id` = (
SELECT entity_type_id
FROM eav_entity_type
WHERE entity_type_code = 'catalog_product'
)
);
Whats going on here?
Can please help me to obtain ALL the products?
What should i modify?
magento-1.9
asked 34 secs ago
programming_amazingprogramming_amazing
245
add a comment |
Yesterday i tried to obtain all products from MAGENTO database. I did
a query and i thought it was working BUT i was wrong.
I put a random SKU in the MAGENTO application, then i clicked on "search" and the product appeared but that SKU did not apprear in my query:
This is my query:
SELECT main.sku, code_brand.value AS code_brand,option_value_brand.value
FROM catalog_product_entity AS main
LEFT JOIN catalog_product_entity_int AS code_brand ON main.entity_id = code_brand.entity_id
JOIN eav_attribute_option option_brand on option_brand.attribute_id = code_brand.attribute_id and option_brand.option_id = code_brand.value
JOIN eav_attribute_option_value option_value_brand on option_brand.option_id = option_value_brand.option_id
WHERE code_brand.attribute_id = (
SELECT attribute_id
FROM eav_attribute
WHERE attribute_code LIKE 'code_brand'
AND `entity_type_id` = (
SELECT entity_type_id
FROM eav_entity_type
WHERE entity_type_code = 'catalog_product'
)
);
Whats going on here?
Can please help me to obtain ALL the products?
What should i modify?
magento-1.9
asked 34 secs ago
programming_amazingprogramming_amazing
245
Yesterday i tried to obtain all products from MAGENTO database. I did
a query and i thought it was working BUT i was wrong.
I put a random SKU in the MAGENTO application, then i clicked on "search" and the product appeared but that SKU did not apprear in my query:
This is my query:
SELECT main.sku, code_brand.value AS code_brand,option_value_brand.value
FROM catalog_product_entity AS main
LEFT JOIN catalog_product_entity_int AS code_brand ON main.entity_id = code_brand.entity_id
JOIN eav_attribute_option option_brand on option_brand.attribute_id = code_brand.attribute_id and option_brand.option_id = code_brand.value
JOIN eav_attribute_option_value option_value_brand on option_brand.option_id = option_value_brand.option_id
WHERE code_brand.attribute_id = (
SELECT attribute_id
FROM eav_attribute
WHERE attribute_code LIKE 'code_brand'
AND `entity_type_id` = (
SELECT entity_type_id
FROM eav_entity_type
WHERE entity_type_code = 'catalog_product'
)
);
Whats going on here?
Can please help me to obtain ALL the products?
What should i modify?
magento-1.9
magento-1.9
asked 34 secs ago
programming_amazingprogramming_amazing
245
asked 34 secs ago
programming_amazingprogramming_amazing
245
asked 34 secs ago
programming_amazingprogramming_amazing
245
asked 34 secs ago
programming_amazingprogramming_amazing
245
asked 34 secs ago
programming_amazingprogramming_amazing
245
245
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fmagento.stackexchange.com%2fquestions%2f260305%2fnot-getting-all-the-products-after-executing-my-query-they-appear-in-the-applic%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Magento Stack Exchange!
- 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.
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%2fmagento.stackexchange.com%2fquestions%2f260305%2fnot-getting-all-the-products-after-executing-my-query-they-appear-in-the-applic%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
