Skip to content

Instantly share code, notes, and snippets.

@drhuffman12

drhuffman12/common.rb

Last active February 1, 2019 17:14
Show Gist options
  • Save drhuffman12/ca93b37e696a4d989166406e4e4d88e2 to your computer and use it in GitHub Desktop.
Save drhuffman12/ca93b37e696a4d989166406e4e4d88e2 to your computer and use it in GitHub Desktop.
Download ZIP
NUT-4229_comparing_OUTER_vs_INNER_joins
Raw
common.rb
esha_pks = [6760530, 6776057, 7279784, 7370300, 8253591, 9797725, 10311137, 10455343, 11402152, 17796699, 18295998, 19227419, 21647821, 21868381, 22096443, 25284036, 32992254, 33039508, 35801083, 37408869, 37500344, 38846565, 44116874, 45503193, 45540890, 46292022, 46676413, 46997137, 48713161, 49538949, 52445686, 52668422, 55396354, 55749456, 56973217, 59940706, 66485593, 66941662, 67180364, 69097944, 70879458, 74598952, 74644922, 74715709, 81621084, 81864393, 82291812, 87092433, 91220972, 92292419, 92622167, 96111237, 96843940, 98217617, 98408699, 99470316, 102108591, 107904280, 108078113, 109046683, 110267344, 110684336, 112318653, 115528891, 115725084, 119023790, 119158512, 120247555, 123243383, 123817113, 124422809, 127195547, 129628259, 130922680, 134762489, 140120855, 143885669, 148806873, 149404244, 149810346, 149867253, 154129202, 160165198, 160803062, 163535839, 165656452, 167844561, 167987582, 168849158, 169287900, 169465839, 170000559, 170062431, 170281645, 179569209, 180810565, 181493232, 182530067, 183426692, 183809897, 187781283, 189097460, 190634136, 191865090, 195411762, 196237742, 198467050, 201314664, 208677197, 211500426, 213632735, 214322192, 215690897, 216935561, 221731712, 223579590, 230200437, 230406887, 260717586, 262949136, 264641412, 267943440, 276974033, 277237056, 277691219, 280018829, 281676590, 281830203, 284048980, 285219833, 289185152, 292117429, 292437438, 299293394, 300173681, 302888234, 304243336, 305957342, 306607402, 309428298, 314284718, 320117080, 320935185, 326469377, 326682483, 327400610, 334998567, 335821339, 337360058, 338082293, 340658614, 342049974, 342450062, 345236753, 346083534, 347605990, 356388679, 359345457, 360227743, 360356773, 366282750, 366643836, 373250447, 374612431, 376418511, 378505497, 378554838, 378959402, 385114356, 387074265, 389053655, 390791068, 395427295, 395686599, 401932894, 404681669, 404703870, 404870343, 407452474, 412894494, 417937400, 420340728, 422574975, 424578253, 426262345, 432811841, 434238210, 434947976, 437641925, 442975443, 443883465, 446464305, 447322286, 449694271, 450972416, 451127206, 452501368, 453813644, 454125624, 456347333, 457217140, 457443840, 457968840, 458956934, 459472300, 459986381, 461625951, 461872549, 463594805, 471270747, 472230671, 475575579, 481190417, 482428351, 482903493, 488637135, 490948860, 493765147, 494290030, 494665218, 495710120, 499943521, 507742779, 511742389, 514468040, 522657949, 522765830, 523651415, 525579223, 526241798, 528178015, 528614171, 531078678, 531700180, 533409766, 534556367, 535375186, 537904103, 541351806, 543516466, 546284281, 548999536, 554824473, 558615169, 560027760, 560039744, 564100486, 567343354, 567790326, 567839291, 568539458, 571923019, 572606068, 572797900, 572829375, 582077902, 582965093, 584221926, 585893371, 588325989, 590776985, 594267642, 594747599, 596562544, 596948304, 598393734, 601295641, 604271808, 604759488, 607727791, 609199499, 612471671, 613112505, 614209650, 616064068, 617323918, 621166404, 625116752, 627639690, 631055534, 636822294, 638700406, 644603217, 644870244, 645249915, 645411019, 647253236, 647761827, 648980545, 649120639, 664219230, 664583024, 666180249, 670576243, 670688173, 676685155, 676822527, 677634690, 682710104, 688695663, 689434071, 691810342, 697367626, 697947762, 701738027, 704944979, 705089999, 705583481, 706355525, 707683643, 708531037, 717234897, 719258241, 721463992, 723599063, 726791407, 729898467, 730019781, 732986530, 734208257, 735382567, 738640597, 740720951, 742818086, 753313394, 755323441, 756313067, 758718157, 763409259, 764455338, 770101002, 777263028, 779154913, 779433132, 780075244, 783388178, 787654660, 790808479, 794869205, 796902566, 798761469, 801784442, 802839092, 808871411, 809154963, 815491028, 816343412, 818279414, 818961173, 821075178, 821307739, 824099397, 827128985, 831120201, 834967252, 837745997, 838997807, 839037710, 842117573, 842849471, 844224034, 845687034, 847333655, 848990327, 850460475, 851426540, 855026632, 855307314, 855676298, 857183258, 868926413, 870235809, 870478971, 871604413, 872223047, 873040292, 873776458, 874818461, 876270519, 880386788, 884389450, 890150027, 890428091, 893477566, 894002746, 895053287, 897249992, 899514582, 902779510, 903921253, 904499131, 905967306, 914268061, 917602218, 918030746, 918055259, 918365085, 920997878, 922539737, 925641297, 937501345, 938217252, 939395678, 942482248, 944288603, 945732219, 946573947, 946580771, 948061699, 950355439, 950383998, 957472077, 959085972, 960287708, 962935225, 969125945, 971130536, 971289108, 991685240, 992157582, 992533841, 994504753, 996260870, 1000142115, 1000853442, 1001952501, 1003229606, 1005426370, 1009829873, 1011111355, 1012006786, 1012583980, 1013976450, 1014204312, 1015879404, 1018626374, 1019890589, 1021261490, 1022497324, 1030319498, 1030680344, 1034519982, 1036351888, 1036955271, 1037380046, 1042064952, 1042892985, 1047850173, 1051165011, 1057072969, 1058823085, 1061030428, 1069332481, 1071988482, 1072270419, 1072549030, 1073648192, 1074291389, 1074784701, 1078141077, 1080296715, 1082609741, 1084312204, 1088624616, 1099100948, 1103841997, 1105332908, 1113895737, 1114376831, 1116330063, 1116873492, 1116878750, 1117967511, 1120668895, 1121217503, 1122914414, 1123011878, 1124677773, 1126730879, 1126878814, 1127615393, 1128472319, 1128633811, 1130041886, 1133489621, 1133799123, 1135595924, 1140579709, 1141333566, 1144925631, 1146153283, 1150623658, 1154036832, 1156512411, 1157924469, 1158932832, 1159161809, 1160088942, 1170271337, 1170534289, 1171560952, 1172998875, 1173113197, 1176571446, 1176881677, 1177118006, 1179152345, 1180114498, 1180197182, 1181033516, 1181677982, 1181888480, 1183840891, 1186723019, 1186736963, 1187546689, 1188831447, 1192180433, 1193602564, 1195496831, 1196122846, 1200553908, 1202172239, 1203935786, 1204187809, 1204639704, 1206501418, 1209387507, 1210240865, 1212848337, 1215907708, 1220577609, 1220844424, 1228320667, 1229786380, 1236474270, 1240558415, 1241453270, 1241459283, 1241670855, 1242041266, 1246971631, 1248009103, 1248274203, 1248415474, 1249614842, 1251767479, 1255379457, 1262031654, 1262262138, 1262617016, 1273766855, 1274268676, 1276130989, 1276342474, 1279837720, 1280170292, 1283179296, 1284008723, 1285024482, 1287584627, 1288702410, 1292835755, 1293887529, 1297342965, 1297644755, 1301460785, 1308734129, 1312910513, 1313596007, 1314157731, 1316512313, 1316940106, 1319340379, 1321991690, 1334984233, 1342907667, 1352501392, 1353083299, 1354188943, 1356898436, 1357681525, 1357925243, 1358680691, 1359284776, 1359608205, 1360566931, 1363495023, 1366077137, 1366975156, 1370196060, 1371465212, 1375528184, 1377902518, 1379032863, 1386172061, 1387693970, 1389799497, 1390218073, 1390502364, 1394273186, 1394409382, 1394624276, 1395368363, 1396168586, 1397241309, 1400199175, 1401889672, 1404001790, 1406257055, 1406905875, 1407255924, 1407439939, 1407632977, 1409283667, 1410384581, 1412284128, 1414629445, 1415956104, 1415970178, 1418401774, 1420371385, 1426123317, 1426645894, 1431315855, 1433388519, 1434565437, 1441044881, 1441609448, 1443070430, 1443646312, 1446090981, 1447917889, 1458513010, 1460246130, 1464028260, 1464909217, 1465965936, 1466064063, 1466959957, 1468283108, 1470706772, 1471532358, 1474499203, 1477598426, 1478238472, 1481286617, 1482864158, 1483567523, 1484664446, 1484691267, 1486122666, 1487927319, 1490084733, 1494326909, 1498866309, 1499695437, 1500327619, 1504321522, 1504786133, 1505157411, 1510034819, 1516434105, 1522377269, 1523086574, 1524920453, 1525222219, 1529881758, 1530980235, 1531324848, 1532454372, 1535207867, 1536056797, 1536510055, 1537406309, 1538434899, 1539389814, 1540414108, 1540643794, 1544332683, 1544484256, 1544602139, 1546387491, 1548346818, 1548518219, 1549303841, 1552261972, 1554792473, 1556600194, 1558098683, 1559139276, 1560856747, 1565410730, 1566010023, 1568202205, 1568413613, 1570071128, 1571127909, 1574200368, 1576079557, 1576803589, 1577980669, 1580514207, 1580861486, 1581405910, 1582166446, 1584276606, 1586107002, 1587095477, 1592187573, 1592321611, 1594157312, 1595706811, 1596059517, 1596071245, 1596367140, 1596556003, 1598099952, 1600812348, 1601108797, 1601124541, 1601350271, 1601565600, 1604409054, 1606653080, 1607361048, 1611571226, 1617566377, 1618318925, 1625828078, 1626041585, 1626833850, 1627595709, 1628605855, 1629004258, 1629875522, 1631078012, 1632781387, 1632972766, 1634864019, 1634980739, 1636158017, 1638314016, 1638783500, 1646304363, 1650657121, 1654184569, 1657520903, 1664641095, 1664812575, 1665302657, 1668026558, 1668490254, 1671335904, 1676218537, 1676562816, 1678889913, 1681601262, 1684896131, 1685308189, 1685659919, 1687302243, 1689667044, 1690008339, 1693289462, 1697252537, 1697323889, 1698148001, 1701830829, 1703143555, 1703530315, 1709981796, 1711348261, 1711557808, 1713240924, 1716390566, 1718129994, 1719547704, 1719593706, 1721825419, 1724589418, 1726154955, 1727378835, 1731194757, 1732592462, 1733406882, 1736769843, 1737566609, 1739622032, 1740950442, 1741502876, 1741634828, 1747695687, 1751170896, 1753616510, 1753669741, 1753968752, 1755157356, 1766101026, 1770646393, 1773166534, 1773428299, 1775887699, 1777481986, 1779583822, 1780009117, 1780840298, 1781632861, 1786142720, 1787374842, 1788087982, 1788510395, 1791558954, 1793346914, 1793565592, 1793631669, 1796998614, 1801721051, 1803223419, 1807890494, 1809762668, 1810775771, 1814776369, 1819085831, 1819843814, 1821494166, 1821728301, 1823474604, 1824756607, 1825162058, 1828606919, 1829996004, 1831110518, 1833414207, 1834052967, 1838093612, 1839608953, 1841042131, 1844129416, 1846140881, 1847905664, 1850466127, 1851946354, 1854382287, 1858315720, 1859261729, 1861318086, 1861659812, 1863037051, 1863042440, 1864109906, 1865757743, 1866679243, 1866872573, 1870269582, 1870278683, 1872164023, 1880023760, 1882290134, 1884587589, 1886843855, 1889343616, 1890084614, 1891285104, 1894142956, 1897047121, 1898369042, 1906272899, 1906904962, 1907866450, 1910084813, 1911508641, 1912080230, 1912473631, 1913172444, 1914222600, 1914344168, 1914651128, 1915610036, 1915789282, 1915804895, 1916985621, 1918118610, 1922659109, 1924033687, 1929497505, 1932386802, 1932613766, 1935513459, 1941169857, 1943067120, 1943571555, 1946759824, 1951178802, 1956441518, 1958436003, 1961928167, 1963189375, 1966488066, 1971323930, 1971722687, 1972766813, 1973259078, 1974832030, 1980011368, 1985645596, 1992360563, 1994344599, 1995418050, 1997639828, 1998312759, 2000054461, 2001242920, 2003574436, 2006893136, 2007964267, 2010229286, 2016364593, 2016713103, 2017384575, 2017729917, 2022227870, 2024750495, 2034044654, 2034548646, 2038098620, 2039798393, 2041673958, 2041860467, 2045522794, 2052050358, 2053606544, 2055207769, 2055275176, 2059178863, 2059863168, 2060376249, 2060641663, 2063601419, 2066793655, 2067544530, 2068631761, 2069395736, 2069584650, 2069681718, 2082046781, 2082844563, 2083814679, 2084491312, 2087056092, 2089113263, 2090260637, 2091792302, 2092907615, 2093917844, 2097570272, 2097641673, 2097710995, 2098172279, 2099854829, 2101100314, 2103619174, 2103821460, 2105228225, 2106330431, 2107712874, 2110670356, 2112492631, 2112840623, 2117167498, 2117252979, 2119196407, 2120374380, 2123279015, 2125181111, 2126763335, 2127022383, 2128683330, 2133834372, 2140952305, 2141899690, 2142159020, 2145456971, 2145765022, 2146126951, 2146532256, 2146814255]
# esha_pks_multi_only = [1657520903, 1292835755, 1571127909, 134762489, 482903493, 2041673958, 584221926, 345236753, 1664641095, 1019890589, 387074265, 457217140, 302888234, 601295641, 2087056092, 1846140881, 1685659919, 10455343, 1574200368, 1596071245, 1000142115, 378959402, 872223047, 1886843855, 1395368363, 1951178802, 44116874, 1676562816, 2089113263, 1814776369, 1036955271, 1099100948, 292117429, 664219230, 1847905664, 1183840891, 187781283, 939395678, 1627595709, 2024750495, 1770646393, 666180249, 1312910513, 1014204312, 1941169857, 688695663, 2069584650, 2083814679, 1387693970, 1739622032, 884389450, 625116752, 855026632, 1753968752, 594267642, 834967252, 1465965936, 1301460785, 1490084733, 1334984233, 1638783500, 461625951, 70879458, 1544332683, 46292022, 420340728, 1634980739, 1865757743, 1601108797, 1251767479, 1246971631, 45503193, 1943067120, 1638314016, 221731712, 342049974, 1530980235, 52668422, 895053287, 1126878814, 893477566, 596948304, 1236474270, 1321991690, 1626833850, 170281645, 82291812, 1974832030, 1262617016, 1249614842, 148806873, 925641297, 948061699, 99470316, 1568413613, 1022497324, 2082844563, 309428298, 801784442, 2103821460, 110267344, 1401889672, 1753616510, 1069332481, 1932613766, 1080296715, 2063601419, 2066793655, 1030319498, 1535207867]
def check_for_meal_ids_per_esha_pk(found_esha_pks)
puts
found_meal_ids_per_esha_pk = {}
multi_found_meal_ids_per_esha_pk = {}
missing_meal_ids_for_esha_pks = []
found_esha_pks.each do |esha_pk|
meal_ids = meal_ids_per_esha_pk(esha_pk)
if meal_ids.empty?
missing_meal_ids_for_esha_pks << esha_pk
elsif meal_ids.size > 1
# STDERR.puts "\m\nWARNING: \n DB found multiple Meals (meal_ids: #{meal_ids}) for esha_pk: #{esha_pk}\m\m"
multi_found_meal_ids_per_esha_pk[esha_pk] = meal_ids
else
found_meal_ids_per_esha_pk[esha_pk] = meal_ids
end
print '.'
end
puts "\n For the #{found_esha_pks.size} Recipes found, there were #{found_meal_ids_per_esha_pk.values.flatten.size} 1-to-1 Meals found.\n"
STDERR.puts "\nWARNING: \n DB missing Meals for esha_pks: #{missing_meal_ids_for_esha_pks}" if !missing_meal_ids_for_esha_pks.empty?
STDERR.puts "\nWARNING: \n DB multi Meals for esha_pks: #{multi_found_meal_ids_per_esha_pk}" if !multi_found_meal_ids_per_esha_pk.empty?
STDERR.puts "\nWARNING: \n For the #{multi_found_meal_ids_per_esha_pk.keys.size} multi-meal Recipes found with a total of #{multi_found_meal_ids_per_esha_pk.values.flatten.size} Meals found for esha_pks: #{multi_found_meal_ids_per_esha_pk.keys}\n"
found_meal_ids_per_esha_pk
# TODO: remove below (for debug only)
{missing: missing_meal_ids_for_esha_pks, one_to_one: found_meal_ids_per_esha_pk.keys, multi: multi_found_meal_ids_per_esha_pk.keys} # for debug
end
Raw
paste_in_for_INNER_JOINs.rb
def meal_ids_per_esha_pk(esha_pk) # INNER JOINS
sql = <<-SQL
SELECT
r.esha_pk,
m.meal_id
FROM ic_bucket_family f
INNER JOIN ic_calorie_bucket b
ON f.family_id = b.family_id
INNER JOIN ic_meal_bucket_xref mb
ON b.bucket_id = mb.bucket_id
INNER JOIN ic_meal m
ON mb.meal_id = m.meal_id
INNER JOIN ic_meal_image_xref i
ON m.meal_id = i.meal_id
INNER JOIN ic_meal_recipe_xref mr
ON m.meal_id = mr.meal_id
INNER JOIN ic_recipe r
ON mr.recipe_id = r.recipe_id
WHERE f.family_id IN (357,367,377,387,397,407,417)
AND r.esha_pk = #{esha_pk}
AND m.user_id IS NULL
AND r.user_id IS NULL
SQL
ActiveRecord::Base.connection.execute(sql).map { |m| m["meal_id"] }.sort.uniq
end
ActiveRecord::Base.logger.level = Logger::ERROR # to minimize verbosity in rails console
# w/ INNER JOIN
check_for_meal_ids_per_esha_pk(esha_pks); nil # '; nil' to minimize verbosity in rails console
Raw
paste_in_for_LEFT_OUTER_JOINs.rb
def meal_ids_per_esha_pk(esha_pk) # OUTER JOINS
sql = <<-SQL
SELECT
r.esha_pk,
m.meal_id
FROM ic_bucket_family f
LEFT OUTER JOIN ic_calorie_bucket b
ON f.family_id = b.family_id
LEFT OUTER JOIN ic_meal_bucket_xref mb
ON b.bucket_id = mb.bucket_id
LEFT OUTER JOIN ic_meal m
ON mb.meal_id = m.meal_id
LEFT OUTER JOIN ic_meal_image_xref i
ON m.meal_id = i.meal_id
LEFT OUTER JOIN ic_meal_recipe_xref mr
ON m.meal_id = mr.meal_id
LEFT OUTER JOIN ic_recipe r
ON mr.recipe_id = r.recipe_id
WHERE f.family_id IN (357,367,377,387,397,407,417)
AND r.esha_pk = #{esha_pk}
AND m.user_id IS NULL
AND r.user_id IS NULL
SQL
ActiveRecord::Base.connection.execute(sql).map { |m| m["meal_id"] }.sort.uniq
end
ActiveRecord::Base.logger.level = Logger::ERROR # to minimize verbosity in rails console
# w/ LEFT OUTER JOIN
check_for_meal_ids_per_esha_pk(esha_pks); nil # '; nil' to minimize verbosity in rails console
Raw
results_for_INNER_JOINs.md

################################################################

my localtest:

2.4.1 :096 >   # w/ INNER JOIN
2.4.1 :097 >   check_for_meal_ids_per_esha_pk(esha_pks); nil # '; nil' to minimize verbosity in rails console

...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
  For the 987 Recipes found, there were 877 1-to-1 Meals found.

WARNING: 
  DB multi Meals for esha_pks: {10455343=>[146563, 147196], 44116874=>[146647, 147150], 45503193=>[146552, 147152, 147192], 46292022=>[146533, 147197], 52668422=>[146589, 147138], 70879458=>[146504, 147123], 82291812=>[146744, 147157], 99470316=>[146839, 147211], 110267344=>[147051, 147174], 134762489=>[146300, 147185], 148806873=>[146750, 147163], 170281645=>[146743, 147117], 187781283=>[146312, 147194], 221731712=>[146572, 147181], 292117429=>[146284, 147204], 302888234=>[146483, 148215], 309428298=>[146948, 148197], 342049974=>[146576, 147182], 345236753=>[146376, 147176], 378959402=>[146570, 147175], 387074265=>[146410, 147143], 420340728=>[146534, 147180], 457217140=>[146412, 147209], 461625951=>[146497, 147114], 482903493=>[146328, 147188], 584221926=>[146374, 147110], 594267642=>[146392, 147208], 596948304=>[146616, 147135], 601295641=>[146488, 147112], 625116752=>[146386, 147132], 664219230=>[146306, 147108], 666180249=>[146348, 147203], 688695663=>[146360, 147201], 801784442=>[147032, 147158], 834967252=>[146394, 147128], 855026632=>[146388, 147202], 872223047=>[146604, 147142], 884389450=>[146384, 147191], 893477566=>[146611, 147169], 895053287=>[146590, 147165], 925641297=>[146752, 147145], 939395678=>[146314, 147126], 948061699=>[146753, 147168], 1000142115=>[146569, 147195], 1014204312=>[146356, 147189], 1019890589=>[146408, 147205], 1022497324=>[146895, 147214], 1030319498=>[146731, 147148], 1036955271=>[146234, 147106], 1069332481=>[147072, 148133], 1080296715=>[147076, 148139], 1099100948=>[146282, 147149], 1126878814=>[146610, 147147], 1183840891=>[146310, 147124], 1236474270=>[146617, 147164], 1246971631=>[146551, 147151], 1249614842=>[146749, 147134], 1251767479=>[146545, 147177], 1262617016=>[146747, 147160], 1292835755=>[146222, 147105], 1301460785=>[146398, 147139], 1312910513=>[146354, 147120], 1321991690=>[146665, 147127], 1334984233=>[146438, 148214], 1387693970=>[146380, 147207], 1395368363=>[146728, 147144], 1401889672=>[147066, 148136], 1465965936=>[146396, 147199], 1490084733=>[146400, 147206], 1530980235=>[146577, 147184], 1535207867=>[146732, 147170], 1544332683=>[146513, 147111], 1568413613=>[146840, 147212], 1571127909=>[146298, 147115], 1574200368=>[146564, 147193], 1596071245=>[146565, 147178], 1601108797=>[146539, 147183], 1626833850=>[146666, 147161], 1627595709=>[146316, 147198], 1634980739=>[146535, 147187], 1638314016=>[146571, 147200], 1638783500=>[147107, 147116], 1657520903=>[146322, 147136], 1664641095=>[146406, 147137], 1676562816=>[146648, 147171], 1685659919=>[146524, 147118], 1739622032=>[146382, 147122], 1753616510=>[147069, 148130], 1753968752=>[146390, 147141], 1770646393=>[146346, 147133], 1814776369=>[147046, 147154], 1846140881=>[146492, 147113], 1847905664=>[146308, 147179], 1865757743=>[146538, 147190], 1886843855=>[146605, 147166], 1932613766=>[147074, 148138], 1941169857=>[146358, 147131], 1943067120=>[146553, 147186], 1951178802=>[146729, 147167], 1974832030=>[146746, 147125], 2024750495=>[146326, 147119], 2041673958=>[146364, 147210], 2063601419=>[147077, 148140], 2066793655=>[147081, 148143], 2069584650=>[146362, 147146], 2082844563=>[146947, 148195], 2083814679=>[146378, 147140], 2087056092=>[146489, 147121], 2089113263=>[146853, 147104], 2103821460=>[147049, 147156]}

WARNING: 
  For the 110 multi-meal Recipes found with a total of 221 Meals found for esha_pks: [10455343, 44116874, 45503193, 46292022, 52668422, 70879458, 82291812, 99470316, 110267344, 134762489, 148806873, 170281645, 187781283, 221731712, 292117429, 302888234, 309428298, 342049974, 345236753, 378959402, 387074265, 420340728, 457217140, 461625951, 482903493, 584221926, 594267642, 596948304, 601295641, 625116752, 664219230, 666180249, 688695663, 801784442, 834967252, 855026632, 872223047, 884389450, 893477566, 895053287, 925641297, 939395678, 948061699, 1000142115, 1014204312, 1019890589, 1022497324, 1030319498, 1036955271, 1069332481, 1080296715, 1099100948, 1126878814, 1183840891, 1236474270, 1246971631, 1249614842, 1251767479, 1262617016, 1292835755, 1301460785, 1312910513, 1321991690, 1334984233, 1387693970, 1395368363, 1401889672, 1465965936, 1490084733, 1530980235, 1535207867, 1544332683, 1568413613, 1571127909, 1574200368, 1596071245, 1601108797, 1626833850, 1627595709, 1634980739, 1638314016, 1638783500, 1657520903, 1664641095, 1676562816, 1685659919, 1739622032, 1753616510, 1753968752, 1770646393, 1814776369, 1846140881, 1847905664, 1865757743, 1886843855, 1932613766, 1941169857, 1943067120, 1951178802, 1974832030, 2024750495, 2041673958, 2063601419, 2066793655, 2069584650, 2082844563, 2083814679, 2087056092, 2089113263, 2103821460]
 => nil

################################################################

staging:

2.4.1 :096 >   # w/ INNER JOIN
2.4.1 :097 >   check_for_meal_ids_per_esha_pk(esha_pks); nil # '; nil' to minimize verbosity in rails console

...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
  For the 987 Recipes found, there were 0 1-to-1 Meals found.

WARNING: 
  DB missing Meals for esha_pks: [6760530, 6776057, 7279784, 7370300, 8253591, 9797725, 10311137, 10455343, 11402152, 17796699, 18295998, 19227419, 21647821, 21868381, 22096443, 25284036, 32992254, 33039508, 35801083, 37408869, 37500344, 38846565, 44116874, 45503193, 45540890, 46292022, 46676413, 46997137, 48713161, 49538949, 52445686, 52668422, 55396354, 55749456, 56973217, 59940706, 66485593, 66941662, 67180364, 69097944, 70879458, 74598952, 74644922, 74715709, 81621084, 81864393, 82291812, 87092433, 91220972, 92292419, 92622167, 96111237, 96843940, 98217617, 98408699, 99470316, 102108591, 107904280, 108078113, 109046683, 110267344, 110684336, 112318653, 115528891, 115725084, 119023790, 119158512, 120247555, 123243383, 123817113, 124422809, 127195547, 129628259, 130922680, 134762489, 140120855, 143885669, 148806873, 149404244, 149810346, 149867253, 154129202, 160165198, 160803062, 163535839, 165656452, 167844561, 167987582, 168849158, 169287900, 169465839, 170000559, 170062431, 170281645, 179569209, 180810565, 181493232, 182530067, 183426692, 183809897, 187781283, 189097460, 190634136, 191865090, 195411762, 196237742, 198467050, 201314664, 208677197, 211500426, 213632735, 214322192, 215690897, 216935561, 221731712, 223579590, 230200437, 230406887, 260717586, 262949136, 264641412, 267943440, 276974033, 277237056, 277691219, 280018829, 281676590, 281830203, 284048980, 285219833, 289185152, 292117429, 292437438, 299293394, 300173681, 302888234, 304243336, 305957342, 306607402, 309428298, 314284718, 320117080, 320935185, 326469377, 326682483, 327400610, 334998567, 335821339, 337360058, 338082293, 340658614, 342049974, 342450062, 345236753, 346083534, 347605990, 356388679, 359345457, 360227743, 360356773, 366282750, 366643836, 373250447, 374612431, 376418511, 378505497, 378554838, 378959402, 385114356, 387074265, 389053655, 390791068, 395427295, 395686599, 401932894, 404681669, 404703870, 404870343, 407452474, 412894494, 417937400, 420340728, 422574975, 424578253, 426262345, 432811841, 434238210, 434947976, 437641925, 442975443, 443883465, 446464305, 447322286, 449694271, 450972416, 451127206, 452501368, 453813644, 454125624, 456347333, 457217140, 457443840, 457968840, 458956934, 459472300, 459986381, 461625951, 461872549, 463594805, 471270747, 472230671, 475575579, 481190417, 482428351, 482903493, 488637135, 490948860, 493765147, 494290030, 494665218, 495710120, 499943521, 507742779, 511742389, 514468040, 522657949, 522765830, 523651415, 525579223, 526241798, 528178015, 528614171, 531078678, 531700180, 533409766, 534556367, 535375186, 537904103, 541351806, 543516466, 546284281, 548999536, 554824473, 558615169, 560027760, 560039744, 564100486, 567343354, 567790326, 567839291, 568539458, 571923019, 572606068, 572797900, 572829375, 582077902, 582965093, 584221926, 585893371, 588325989, 590776985, 594267642, 594747599, 596562544, 596948304, 598393734, 601295641, 604271808, 604759488, 607727791, 609199499, 612471671, 613112505, 614209650, 616064068, 617323918, 621166404, 625116752, 627639690, 631055534, 636822294, 638700406, 644603217, 644870244, 645249915, 645411019, 647253236, 647761827, 648980545, 649120639, 664219230, 664583024, 666180249, 670576243, 670688173, 676685155, 676822527, 677634690, 682710104, 688695663, 689434071, 691810342, 697367626, 697947762, 701738027, 704944979, 705089999, 705583481, 706355525, 707683643, 708531037, 717234897, 719258241, 721463992, 723599063, 726791407, 729898467, 730019781, 732986530, 734208257, 735382567, 738640597, 740720951, 742818086, 753313394, 755323441, 756313067, 758718157, 763409259, 764455338, 770101002, 777263028, 779154913, 779433132, 780075244, 783388178, 787654660, 790808479, 794869205, 796902566, 798761469, 801784442, 802839092, 808871411, 809154963, 815491028, 816343412, 818279414, 818961173, 821075178, 821307739, 824099397, 827128985, 831120201, 834967252, 837745997, 838997807, 839037710, 842117573, 842849471, 844224034, 845687034, 847333655, 848990327, 850460475, 851426540, 855026632, 855307314, 855676298, 857183258, 868926413, 870235809, 870478971, 871604413, 872223047, 873040292, 873776458, 874818461, 876270519, 880386788, 884389450, 890150027, 890428091, 893477566, 894002746, 895053287, 897249992, 899514582, 902779510, 903921253, 904499131, 905967306, 914268061, 917602218, 918030746, 918055259, 918365085, 920997878, 922539737, 925641297, 937501345, 938217252, 939395678, 942482248, 944288603, 945732219, 946573947, 946580771, 948061699, 950355439, 950383998, 957472077, 959085972, 960287708, 962935225, 969125945, 971130536, 971289108, 991685240, 992157582, 992533841, 994504753, 996260870, 1000142115, 1000853442, 1001952501, 1003229606, 1005426370, 1009829873, 1011111355, 1012006786, 1012583980, 1013976450, 1014204312, 1015879404, 1018626374, 1019890589, 1021261490, 1022497324, 1030319498, 1030680344, 1034519982, 1036351888, 1036955271, 1037380046, 1042064952, 1042892985, 1047850173, 1051165011, 1057072969, 1058823085, 1061030428, 1069332481, 1071988482, 1072270419, 1072549030, 1073648192, 1074291389, 1074784701, 1078141077, 1080296715, 1082609741, 1084312204, 1088624616, 1099100948, 1103841997, 1105332908, 1113895737, 1114376831, 1116330063, 1116873492, 1116878750, 1117967511, 1120668895, 1121217503, 1122914414, 1123011878, 1124677773, 1126730879, 1126878814, 1127615393, 1128472319, 1128633811, 1130041886, 1133489621, 1133799123, 1135595924, 1140579709, 1141333566, 1144925631, 1146153283, 1150623658, 1154036832, 1156512411, 1157924469, 1158932832, 1159161809, 1160088942, 1170271337, 1170534289, 1171560952, 1172998875, 1173113197, 1176571446, 1176881677, 1177118006, 1179152345, 1180114498, 1180197182, 1181033516, 1181677982, 1181888480, 1183840891, 1186723019, 1186736963, 1187546689, 1188831447, 1192180433, 1193602564, 1195496831, 1196122846, 1200553908, 1202172239, 1203935786, 1204187809, 1204639704, 1206501418, 1209387507, 1210240865, 1212848337, 1215907708, 1220577609, 1220844424, 1228320667, 1229786380, 1236474270, 1240558415, 1241453270, 1241459283, 1241670855, 1242041266, 1246971631, 1248009103, 1248274203, 1248415474, 1249614842, 1251767479, 1255379457, 1262031654, 1262262138, 1262617016, 1273766855, 1274268676, 1276130989, 1276342474, 1279837720, 1280170292, 1283179296, 1284008723, 1285024482, 1287584627, 1288702410, 1292835755, 1293887529, 1297342965, 1297644755, 1301460785, 1308734129, 1312910513, 1313596007, 1314157731, 1316512313, 1316940106, 1319340379, 1321991690, 1334984233, 1342907667, 1352501392, 1353083299, 1354188943, 1356898436, 1357681525, 1357925243, 1358680691, 1359284776, 1359608205, 1360566931, 1363495023, 1366077137, 1366975156, 1370196060, 1371465212, 1375528184, 1377902518, 1379032863, 1386172061, 1387693970, 1389799497, 1390218073, 1390502364, 1394273186, 1394409382, 1394624276, 1395368363, 1396168586, 1397241309, 1400199175, 1401889672, 1404001790, 1406257055, 1406905875, 1407255924, 1407439939, 1407632977, 1409283667, 1410384581, 1412284128, 1414629445, 1415956104, 1415970178, 1418401774, 1420371385, 1426123317, 1426645894, 1431315855, 1433388519, 1434565437, 1441044881, 1441609448, 1443070430, 1443646312, 1446090981, 1447917889, 1458513010, 1460246130, 1464028260, 1464909217, 1465965936, 1466064063, 1466959957, 1468283108, 1470706772, 1471532358, 1474499203, 1477598426, 1478238472, 1481286617, 1482864158, 1483567523, 1484664446, 1484691267, 1486122666, 1487927319, 1490084733, 1494326909, 1498866309, 1499695437, 1500327619, 1504321522, 1504786133, 1505157411, 1510034819, 1516434105, 1522377269, 1523086574, 1524920453, 1525222219, 1529881758, 1530980235, 1531324848, 1532454372, 1535207867, 1536056797, 1536510055, 1537406309, 1538434899, 1539389814, 1540414108, 1540643794, 1544332683, 1544484256, 1544602139, 1546387491, 1548346818, 1548518219, 1549303841, 1552261972, 1554792473, 1556600194, 1558098683, 1559139276, 1560856747, 1565410730, 1566010023, 1568202205, 1568413613, 1570071128, 1571127909, 1574200368, 1576079557, 1576803589, 1577980669, 1580514207, 1580861486, 1581405910, 1582166446, 1584276606, 1586107002, 1587095477, 1592187573, 1592321611, 1594157312, 1595706811, 1596059517, 1596071245, 1596367140, 1596556003, 1598099952, 1600812348, 1601108797, 1601124541, 1601350271, 1601565600, 1604409054, 1606653080, 1607361048, 1611571226, 1617566377, 1618318925, 1625828078, 1626041585, 1626833850, 1627595709, 1628605855, 1629004258, 1629875522, 1631078012, 1632781387, 1632972766, 1634864019, 1634980739, 1636158017, 1638314016, 1638783500, 1646304363, 1650657121, 1654184569, 1657520903, 1664641095, 1664812575, 1665302657, 1668026558, 1668490254, 1671335904, 1676218537, 1676562816, 1678889913, 1681601262, 1684896131, 1685308189, 1685659919, 1687302243, 1689667044, 1690008339, 1693289462, 1697252537, 1697323889, 1698148001, 1701830829, 1703143555, 1703530315, 1709981796, 1711348261, 1711557808, 1713240924, 1716390566, 1718129994, 1719547704, 1719593706, 1721825419, 1724589418, 1726154955, 1727378835, 1731194757, 1732592462, 1733406882, 1736769843, 1737566609, 1739622032, 1740950442, 1741502876, 1741634828, 1747695687, 1751170896, 1753616510, 1753669741, 1753968752, 1755157356, 1766101026, 1770646393, 1773166534, 1773428299, 1775887699, 1777481986, 1779583822, 1780009117, 1780840298, 1781632861, 1786142720, 1787374842, 1788087982, 1788510395, 1791558954, 1793346914, 1793565592, 1793631669, 1796998614, 1801721051, 1803223419, 1807890494, 1809762668, 1810775771, 1814776369, 1819085831, 1819843814, 1821494166, 1821728301, 1823474604, 1824756607, 1825162058, 1828606919, 1829996004, 1831110518, 1833414207, 1834052967, 1838093612, 1839608953, 1841042131, 1844129416, 1846140881, 1847905664, 1850466127, 1851946354, 1854382287, 1858315720, 1859261729, 1861318086, 1861659812, 1863037051, 1863042440, 1864109906, 1865757743, 1866679243, 1866872573, 1870269582, 1870278683, 1872164023, 1880023760, 1882290134, 1884587589, 1886843855, 1889343616, 1890084614, 1891285104, 1894142956, 1897047121, 1898369042, 1906272899, 1906904962, 1907866450, 1910084813, 1911508641, 1912080230, 1912473631, 1913172444, 1914222600, 1914344168, 1914651128, 1915610036, 1915789282, 1915804895, 1916985621, 1918118610, 1922659109, 1924033687, 1929497505, 1932386802, 1932613766, 1935513459, 1941169857, 1943067120, 1943571555, 1946759824, 1951178802, 1956441518, 1958436003, 1961928167, 1963189375, 1966488066, 1971323930, 1971722687, 1972766813, 1973259078, 1974832030, 1980011368, 1985645596, 1992360563, 1994344599, 1995418050, 1997639828, 1998312759, 2000054461, 2001242920, 2003574436, 2006893136, 2007964267, 2010229286, 2016364593, 2016713103, 2017384575, 2017729917, 2022227870, 2024750495, 2034044654, 2034548646, 2038098620, 2039798393, 2041673958, 2041860467, 2045522794, 2052050358, 2053606544, 2055207769, 2055275176, 2059178863, 2059863168, 2060376249, 2060641663, 2063601419, 2066793655, 2067544530, 2068631761, 2069395736, 2069584650, 2069681718, 2082046781, 2082844563, 2083814679, 2084491312, 2087056092, 2089113263, 2090260637, 2091792302, 2092907615, 2093917844, 2097570272, 2097641673, 2097710995, 2098172279, 2099854829, 2101100314, 2103619174, 2103821460, 2105228225, 2106330431, 2107712874, 2110670356, 2112492631, 2112840623, 2117167498, 2117252979, 2119196407, 2120374380, 2123279015, 2125181111, 2126763335, 2127022383, 2128683330, 2133834372, 2140952305, 2141899690, 2142159020, 2145456971, 2145765022, 2146126951, 2146532256, 2146814255]

WARNING: 
  For the 0 multi-meal Recipes found with a total of 0 Meals found for esha_pks: []
 => nil
Raw
results_for_LEFT_OUTER_JOINs.md

################################################################

my localtest:

2.4.1 :064 >   # w/ LEFT OUTER JOIN
2.4.1 :065 >   check_for_meal_ids_per_esha_pk(esha_pks); nil # '; nil' to minimize verbosity in rails console

...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
  For the 987 Recipes found, there were 877 1-to-1 Meals found.

WARNING: 
  DB multi Meals for esha_pks: {10455343=>[146563, 147196], 44116874=>[146647, 147150], 45503193=>[146552, 147152, 147192], 46292022=>[146533, 147197], 52668422=>[146589, 147138], 70879458=>[146504, 147123], 82291812=>[146744, 147157], 99470316=>[146839, 147211], 110267344=>[147051, 147174], 134762489=>[146300, 147185], 148806873=>[146750, 147163], 170281645=>[146743, 147117], 187781283=>[146312, 147194], 221731712=>[146572, 147181], 292117429=>[146284, 147204], 302888234=>[146483, 148215], 309428298=>[146948, 148197], 342049974=>[146576, 147182], 345236753=>[146376, 147176], 378959402=>[146570, 147175], 387074265=>[146410, 147143], 420340728=>[146534, 147180], 457217140=>[146412, 147209], 461625951=>[146497, 147114], 482903493=>[146328, 147188], 584221926=>[146374, 147110], 594267642=>[146392, 147208], 596948304=>[146616, 147135], 601295641=>[146488, 147112], 625116752=>[146386, 147132], 664219230=>[146306, 147108], 666180249=>[146348, 147203], 688695663=>[146360, 147201], 801784442=>[147032, 147158], 834967252=>[146394, 147128], 855026632=>[146388, 147202], 872223047=>[146604, 147142], 884389450=>[146384, 147191], 893477566=>[146611, 147169], 895053287=>[146590, 147165], 925641297=>[146752, 147145], 939395678=>[146314, 147126], 948061699=>[146753, 147168], 1000142115=>[146569, 147195], 1014204312=>[146356, 147189], 1019890589=>[146408, 147205], 1022497324=>[146895, 147214], 1030319498=>[146731, 147148], 1036955271=>[146234, 147106], 1069332481=>[147072, 148133], 1080296715=>[147076, 148139], 1099100948=>[146282, 147149], 1126878814=>[146610, 147147], 1183840891=>[146310, 147124], 1236474270=>[146617, 147164], 1246971631=>[146551, 147151], 1249614842=>[146749, 147134], 1251767479=>[146545, 147177], 1262617016=>[146747, 147160], 1292835755=>[146222, 147105], 1301460785=>[146398, 147139], 1312910513=>[146354, 147120], 1321991690=>[146665, 147127], 1334984233=>[146438, 148214], 1387693970=>[146380, 147207], 1395368363=>[146728, 147144], 1401889672=>[147066, 148136], 1465965936=>[146396, 147199], 1490084733=>[146400, 147206], 1530980235=>[146577, 147184], 1535207867=>[146732, 147170], 1544332683=>[146513, 147111], 1568413613=>[146840, 147212], 1571127909=>[146298, 147115], 1574200368=>[146564, 147193], 1596071245=>[146565, 147178], 1601108797=>[146539, 147183], 1626833850=>[146666, 147161], 1627595709=>[146316, 147198], 1634980739=>[146535, 147187], 1638314016=>[146571, 147200], 1638783500=>[147107, 147116], 1657520903=>[146322, 147136], 1664641095=>[146406, 147137], 1676562816=>[146648, 147171], 1685659919=>[146524, 147118], 1739622032=>[146382, 147122], 1753616510=>[147069, 148130], 1753968752=>[146390, 147141], 1770646393=>[146346, 147133], 1814776369=>[147046, 147154], 1846140881=>[146492, 147113], 1847905664=>[146308, 147179], 1865757743=>[146538, 147190], 1886843855=>[146605, 147166], 1932613766=>[147074, 148138], 1941169857=>[146358, 147131], 1943067120=>[146553, 147186], 1951178802=>[146729, 147167], 1974832030=>[146746, 147125], 2024750495=>[146326, 147119], 2041673958=>[146364, 147210], 2063601419=>[147077, 148140], 2066793655=>[147081, 148143], 2069584650=>[146362, 147146], 2082844563=>[146947, 148195], 2083814679=>[146378, 147140], 2087056092=>[146489, 147121], 2089113263=>[146853, 147104], 2103821460=>[147049, 147156]}

WARNING: 
  For the 110 multi-meal Recipes found with a total of 221 Meals found for esha_pks: [10455343, 44116874, 45503193, 46292022, 52668422, 70879458, 82291812, 99470316, 110267344, 134762489, 148806873, 170281645, 187781283, 221731712, 292117429, 302888234, 309428298, 342049974, 345236753, 378959402, 387074265, 420340728, 457217140, 461625951, 482903493, 584221926, 594267642, 596948304, 601295641, 625116752, 664219230, 666180249, 688695663, 801784442, 834967252, 855026632, 872223047, 884389450, 893477566, 895053287, 925641297, 939395678, 948061699, 1000142115, 1014204312, 1019890589, 1022497324, 1030319498, 1036955271, 1069332481, 1080296715, 1099100948, 1126878814, 1183840891, 1236474270, 1246971631, 1249614842, 1251767479, 1262617016, 1292835755, 1301460785, 1312910513, 1321991690, 1334984233, 1387693970, 1395368363, 1401889672, 1465965936, 1490084733, 1530980235, 1535207867, 1544332683, 1568413613, 1571127909, 1574200368, 1596071245, 1601108797, 1626833850, 1627595709, 1634980739, 1638314016, 1638783500, 1657520903, 1664641095, 1676562816, 1685659919, 1739622032, 1753616510, 1753968752, 1770646393, 1814776369, 1846140881, 1847905664, 1865757743, 1886843855, 1932613766, 1941169857, 1943067120, 1951178802, 1974832030, 2024750495, 2041673958, 2063601419, 2066793655, 2069584650, 2082844563, 2083814679, 2087056092, 2089113263, 2103821460]
 => nil

################################################################

staging:

2.4.1 :064 >   # w/ LEFT OUTER JOIN
2.4.1 :065 >   check_for_meal_ids_per_esha_pk(esha_pks); nil # '; nil' to minimize verbosity in rails console

...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
  For the 987 Recipes found, there were 877 1-to-1 Meals found.

WARNING: 
  DB multi Meals for esha_pks: {10455343=>[146563, 147196], 44116874=>[146647, 147150], 45503193=>[146552, 147152, 147192], 46292022=>[146533, 147197], 52668422=>[146589, 147138], 70879458=>[146504, 147123], 82291812=>[146744, 147157], 99470316=>[146839, 147211], 110267344=>[147051, 147174], 134762489=>[146300, 147185], 148806873=>[146750, 147163], 170281645=>[146743, 147117], 187781283=>[146312, 147194], 221731712=>[146572, 147181], 292117429=>[146284, 147204], 302888234=>[146483, 168375], 309428298=>[146948, 168378], 342049974=>[146576, 147182], 345236753=>[146376, 147176], 378959402=>[146570, 147175], 387074265=>[146410, 147143], 420340728=>[146534, 147180], 457217140=>[146412, 147209], 461625951=>[146497, 147114], 482903493=>[146328, 147188], 584221926=>[146374, 147110], 594267642=>[146392, 147208], 596948304=>[146616, 147135], 601295641=>[146488, 147112], 625116752=>[146386, 147132], 664219230=>[146306, 147108], 666180249=>[146348, 147203], 688695663=>[146360, 147201], 801784442=>[147032, 147158], 834967252=>[146394, 147128], 855026632=>[146388, 147202], 872223047=>[146604, 147142], 884389450=>[146384, 147191], 893477566=>[146611, 147169], 895053287=>[146590, 147165], 925641297=>[146752, 147145], 939395678=>[146314, 147126], 948061699=>[146753, 147168], 1000142115=>[146569, 147195], 1014204312=>[146356, 147189], 1019890589=>[146408, 147205], 1022497324=>[146895, 147214], 1030319498=>[146731, 147148], 1036955271=>[146234, 147106], 1069332481=>[147072, 168325], 1080296715=>[147076, 168331], 1099100948=>[146282, 147149], 1126878814=>[146610, 147147], 1183840891=>[146310, 147124], 1236474270=>[146617, 147164], 1246971631=>[146551, 147151], 1249614842=>[146749, 147134], 1251767479=>[146545, 147177], 1262617016=>[146747, 147160], 1292835755=>[146222, 147105], 1301460785=>[146398, 147139], 1312910513=>[146354, 147120], 1321991690=>[146665, 147127], 1334984233=>[146438, 168374], 1387693970=>[146380, 147207], 1395368363=>[146728, 147144], 1401889672=>[147066, 168328], 1465965936=>[146396, 147199], 1490084733=>[146400, 147206], 1530980235=>[146577, 147184], 1535207867=>[146732, 147170], 1544332683=>[146513, 147111], 1568413613=>[146840, 147212], 1571127909=>[146298, 147115], 1574200368=>[146564, 147193], 1596071245=>[146565, 147178], 1601108797=>[146539, 147183], 1626833850=>[146666, 147161], 1627595709=>[146316, 147198], 1634980739=>[146535, 147187], 1638314016=>[146571, 147200], 1638783500=>[147107, 147116], 1657520903=>[146322, 147136], 1664641095=>[146406, 147137], 1676562816=>[146648, 147171], 1685659919=>[146524, 147118], 1739622032=>[146382, 147122], 1753616510=>[147069, 168322], 1753968752=>[146390, 147141], 1770646393=>[146346, 147133], 1814776369=>[147046, 147154], 1846140881=>[146492, 147113], 1847905664=>[146308, 147179], 1865757743=>[146538, 147190], 1886843855=>[146605, 147166], 1932613766=>[147074, 168330], 1941169857=>[146358, 147131], 1943067120=>[146553, 147186], 1951178802=>[146729, 147167], 1974832030=>[146746, 147125], 2024750495=>[146326, 147119], 2041673958=>[146364, 147210], 2063601419=>[147077, 168332], 2066793655=>[147081, 168335], 2069584650=>[146362, 147146], 2082844563=>[146947, 168377], 2083814679=>[146378, 147140], 2087056092=>[146489, 147121], 2089113263=>[146853, 147104], 2103821460=>[147049, 147156]}

WARNING: 
  For the 110 multi-meal Recipes found with a total of 221 Meals found for esha_pks: [10455343, 44116874, 45503193, 46292022, 52668422, 70879458, 82291812, 99470316, 110267344, 134762489, 148806873, 170281645, 187781283, 221731712, 292117429, 302888234, 309428298, 342049974, 345236753, 378959402, 387074265, 420340728, 457217140, 461625951, 482903493, 584221926, 594267642, 596948304, 601295641, 625116752, 664219230, 666180249, 688695663, 801784442, 834967252, 855026632, 872223047, 884389450, 893477566, 895053287, 925641297, 939395678, 948061699, 1000142115, 1014204312, 1019890589, 1022497324, 1030319498, 1036955271, 1069332481, 1080296715, 1099100948, 1126878814, 1183840891, 1236474270, 1246971631, 1249614842, 1251767479, 1262617016, 1292835755, 1301460785, 1312910513, 1321991690, 1334984233, 1387693970, 1395368363, 1401889672, 1465965936, 1490084733, 1530980235, 1535207867, 1544332683, 1568413613, 1571127909, 1574200368, 1596071245, 1601108797, 1626833850, 1627595709, 1634980739, 1638314016, 1638783500, 1657520903, 1664641095, 1676562816, 1685659919, 1739622032, 1753616510, 1753968752, 1770646393, 1814776369, 1846140881, 1847905664, 1865757743, 1886843855, 1932613766, 1941169857, 1943067120, 1951178802, 1974832030, 2024750495, 2041673958, 2063601419, 2066793655, 2069584650, 2082844563, 2083814679, 2087056092, 2089113263, 2103821460]
 => nil
Raw
summary.md

For localtest and staging, w/ LEFT OUTER JOIN, I get the same results:

...
For the 987 Recipes found, there were 877 1-to-1 Meals found.
...
For the 110 multi-meal Recipes found with a total of 221 Meals found for esha_pks...
...

For localtest, w/ INNER JOIN, I get the same results as I did for LEFT OUTER JOIN's.

For staging, w/ INNER JOIN, I don't get any Recipes for these esha_pk's:

...
For the 987 Recipes found, there were 0 1-to-1 Meals found.
...
For the 0 multi-meal Recipes found ...
...

aka (for left outer join results):

total recipes:

  877
+ 110
=====
  987

total meals:

  877
+ 221
=====
 1098
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment